Oracle 1z0-588 - Oracle Hyperion Data Relationship Management Essentials
A user has been assigned the Data Creator role. Identify the two true statements.
The Time Balance property definition is applicable to the Account hierarchy only and is not valid for any other hierarchy. You would like to simplify the view for end users so they do not see the Time Balance property for the Entity dimension.
What method will achieve this requirement?
Which filters can you apply to narrow the transaction history results when searching the transaction history?
Identify the three true statements about version types.
Per the example:
Your organization has two ERPs: PeopleSoft (PS) and SAP. Each ERP has its own chart of accounts. Each chart of accounts is mapped to a consolidated chart of accounts. The Finance department maintains the consolidated account hierarchy.
Identify the steps in the correct order to manage the mapping of the local chart of accounts in the consolidated chart of accounts structure using DRM hierarchies.
1. Build the consolidated chart of accounts hierarchy.
2. Build the PeopleSoft and SAP chart of accounts hierarchies.
3. Create a property category called CoA Map with two property definitions: PS CoA Mapping and SAP CoA Mapping.
4. Create an alternate Market hierarchy with limb nodes "large", "Medium", and "Small". Insert cities as leaf nodes under the appropriate Market Size nodes.
5. Use the Blend function to merge the PeopleSoft and sap chart of accounts to the correct consolidated account node In the consolidated hierarchy.
6. Drag and drop the PeopleSoft and SAP chart of accounts to the correct consolidated account in the consolidated hierarchy.
Identify the valid Import sections and the required columns for each section.
1. Version, Required column: version name
2. Hierarchy, Required columns: hierarchy name, top node
3. Hierarchy, Required columns: hierarchy name
4. Node, Required column: node name
5. Relationship, Required columns: parent node name, child node name
6. Hierarchy Node, Required columns: hierarchy name, node name
7. Hierarchy Node, Required columns: hierarchy name
An Anonymous User in DRM is_____.
Review the example below:
Product
All Products
Alternate Product Hierarchy
All Products
High Calorie, Sugar Filled Products
Your target Essbase database requires an alternate of the Product, rolling up product SKUs by Caffeinated and NonCaffeinated. You currently maintain this value as a property. Once a valid export is built, what are the two ways you can create the new hierarchy in an existing version?
Identify three ways to narrow the scope of the first phase of the DRM implementation.
Per the example:
You have three entity hierarchies within the same version. The Essbase Storage property is set to local. The Alias Description property is set to Global. Identify the true statements.
1. If the Essbase administrator changes the Essbase Storage property from "Stored" to "Dynamic" for a node in the primary hierarchy, the property will change for all hierarchies.
2. If the Essbase administrator changes the Alias Description property for a node it\ the primary hierarchy, the property will change for all hierarchies,
3. If the Ecssbase administrator changes the Alias Description property for a node in the non- primary hierarchy, the property will not change for other hierarchies.
4. If the Essbase administrator changes the Alias Description or Essbase Storage property to a node in a hierarchy, the values will not update in the other hierarchies unless the DisableSharedNodes is set to False.
5. Because the Alias Description property is set to Global, the property will update across all versions for the node.
