3 Months Free Update
3 Months Free Update
3 Months Free Update
You want an import to stop if a duplicate node is found. How do you do this?
An issue exists in which "reserved" key words have been used or included in the custom alias property for a downstream system. The reserved words are "Dynamic" and "MBRNAME".
The steps for creating a real-time validation are:
1. Create a custom property to verify that the value input in the custom alias property does not contain the reserved words.
2. Test the custom property.
3. Create a custom Validation with the "Property Equals Value" class.
4. Test the validation.
5. Assign the Validation to a version.
Choose three validations that are often implemented for downstream systems.
Per the example:
What are the three outcomes after running the action script?
You maintain the Market hierarchy in DRM.
A target system needs an alternate hierarchy of the Market dimension that contains the lowest level of markets (city) rolling up by market size (nodes Large, Medium, and Small).
Identify the ways to meet this requirement in DRM.
1. Create a property category called "Market Size" and populate the values as "Large", "Medium", and "Small"
2. Create a property called "Market Size" and populate the values as "Large", "Medium", and "Small"
3. Create a node type called "Market Size" and populate the values as "Large", "Medium", and "Small"
4. Create an alternate hierarchy in the Market dimension with nodes "Large", "Medium", and "Small". Add cities as shared nodes under the appropriate Market Size nodes.
Identify two reasons to build validations using derived properties vs. validations using property queries?
A department may only have 10 cost centers. How can you address this requirement?
New cost centers are added to the Entity hierarchy nightly from the ERP system. Identify the two true statements about the ERP system.
What two DRM features allow you to group hierarchies used for data mappings for easier selection and browsing?
Identify the four true statements about designing property categories, property definitions, and validations for target and source systems.
Per the Example:
You need to load both the Product and Market hierarchies to multiple Essbase databases.
Identify three DRM objects that could be used across both Product and Market hierarchies?