Oracle Hyperion Data Relationship Management Essentials v7.0 (1z0-588)

Page:    1 / 5   
Total 80 questions


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, For both the SAP and
PS account properties, users should be able to select from a drop-down list the correct accounts that should be mapped to the consolidated account. Many SAP or PS accounts could be mapped to a single consolidated account.
What property type should you set for the SAP Account Property and PS Account Property, assuming that you have built the SAP and PS chart of account hierarchies in DRM?

  • A. Lookup
  • B. List
  • C. AscNodes
  • D. AscNode
  • E. RangeList


Answer : B

What are the four valid functions available in the DRM Migration utility?

  • A. Extract hierarchies and property values from one DRM version.
  • B. Extract property definitions, property categories, validations, and queries from a DRM application to an XML file.
  • C. Load hierarchies and property values to a DRM version.
  • D. Load metadata from an XML file into a Data Relationship Management application.
  • E. Compare metadata differences between two sources, such as a development DRM instance to a production DRM instance.
  • F. Generate an HTML report from the results.


Answer : B,C,E,F

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

  • A. 1, 2, 4, 5 only
  • B. 1, 2, 4, 5, 6 only
  • C. 1, 3, 4, 5, 6 only
  • D. 1, 2, 4, 5, 7 only
  • E. 1, 3, 4, 5, 7 only
  • F. 1, 2, 3, 4, 5, 6, 7


Answer : A

Select the four valid reasons why you would create a different version.

  • A. To maintain monthly versions
  • B. To maintain versions for major reorganization
  • C. To apply security for different hierarchies
  • D. To allow multiple people to simultaneously work on the same data
  • E. For "What If" modeling for a hierarchy
  • F. To create property categories that are specific to a version
  • G. For historical comparisons


Answer : D,E,F,G

An Anonymous User in DRM is_____.

  • A. used by Administrators to test security from the perspective of different end users
  • B. similar to a "read only" type role for end users
  • C. used by Administrators to grant guest access to DRM for a short period of time
  • D. not a valid role in version 11.1.2.1


Answer : C

Identify the three true statements about the timing of DRM integrations.

  • A. Exports may be run any time on any version.
  • B. Imports may be run any time on any version.
  • C. Property queries may be run any time on any version.
  • D. DRM integrations may be scheduled or run on demand.
  • E. Once a version has been finalized, only data Managers may run exports.


Answer : C,D,E

What two DRM features allow you to group hierarchies used for data mappings for easier selection and browsing?

  • A. Version
  • B. Property category
  • C. Hierarchy group
  • D. Node type
  • E. Hierarchy master


Answer : B,C

You decide to implement node type? for the Account dimension. What are the required steps that must be completed to implement a node type?
1. Under Administer, create node types with valid assigned DRM elements.
2. Create a hierarchy property that contains a list of values thatmatches the node types defined.
3. Create a local node property called "HierarchyNodeType".
4. For version, set the HierarchyNodeType to "Dimension".
5. For the hierarchy, set the Dimension property to the desired Node type value (for example. Account dimension type for the Account hierarchy).
6. Upload a glyph for each node type.

  • A. 1, 2, 3, 5 only
  • B. 1,3, 4, 5 only
  • C. 1, 2, 3, 4, 5 only
  • D. 1, 2, 3, 5, 6 only
  • E. 1, 2, 3, 4, 5, 6


Answer : B

Identify the four true statements about designing property categories, property definitions, and validations for target and source systems.

  • A. Allow users to type in property values for properties that only have a limited set of valid values.
  • B. Create derived property definitions that are hidden from users that can be used in exports for target systems.
  • C. Create separate property categories for each target and source system.
  • D. Name property definitions different then target system names.
  • E. Create similar validations that are used by source systems.
  • F. Create similarvalidations that are used by target systems.


Answer : B,C,D,E

Which option describes the benefits of the Import DRM feature over the Action Script DRM feature?

  • A. Import supports the import of hierarchies into new and existing versions.
  • B. You can preview hierarchies and metadata before merging with existing data sets.
  • C. It is easy to create formats directly from source systems.
  • D. You can view twi^nr11"1 and failures.
  • E. It can be automated through the batch client.


Answer : A

select the three valid web service methods from DRM workflow actions.

  • A. UpdateNodeAccessMembers
  • B. ApproveRequest
  • C. GetRequestBy Id
  • D. Addnode type
  • E. CreateRequet
  • F. ApplyNodeTypePro


Answer : D,E,F

Which three statements are true about the stakeholders in a DRM implementation?

  • A. Business users are initially brought into the project during the testing process.
  • B. Source and target systems administrators have minimal involvement during the DRM implementation.
  • C. The DRM administrator use both prebuilt and custom property definitions and property categories to create versions and hierarchies as dictated by requirements and design.
  • D. The DRM administrator creates validations dictated by requirements and design.
  • E. A data governance team defines overall standards for the DRM implementation.


Answer : A,B,C

Identify the three true statements about the Initial Data Load process when you first implement DRM.

  • A. You can set the initial load to stop if duplicates are found.
  • B. Duplicate node identifier information should be consistent with the Shared Node Maintenance system preferences so that you can import duplicate nodes as shared nodes.
  • C. Validations should be built before the initial data load.
  • D. You must setup node types before building property definitions.
  • E. Skipping blank values and using default values to minimize the size of the data loaded is recommended.


Answer : B,D,E

New cost centers are added to the Entity hierarchy nightly from the ERP system. Identify the two true statements about the ERP system.

  • A. It is considered an upstream system.
  • B. It is considered a downstream system.
  • C. Because it is used as a source for the Entity dimension, you may not feed entity data back to the ERP system.
  • D. It may be imported into an existing version using Import.
  • E. The ERP system feed can be automated using the batch client.


Answer : A,B

Identify the three true statements about Workflow in DRM.

  • A. Change requests are stored in a draft state for approval.
  • B. Change requests are validated against a version and committed to the draft version.
  • C. Change requests pending approval cannot be changes until the change has been approved.
  • D. Change requests are committed to a version once the request is approved.
  • E. Workflow is exposed through the API.


Answer : A,C,D

Page:    1 / 5   
Total 80 questions