Transcription

Oracle Hyperion Data RelationshipManagement Exam Study Guide

Objective & AudienceObjectiveHelp you prepare to take the Oracle Hyperion Data RelationshipManagement Essentials (1Z1-588) exam by providingpointers to resources that you can use in your preparation.Targeted Audience Technical / Functional ConsultantsStrong foundation and expertise in implementing ,configuring and designing the Oracle Hyperion DataRelationship Management 11.1.2 solutionParticipated in couple of Oracle Hyperion Data RelationshipManagement implementationsFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Exam Topics & ObjectivesExam TopicsOracle Hyperion Data Relationship Management Essentials examconsists of twelve topics:1. Implementation Scope and Risks2. DRM Overview3. Managing the Initial Data Load4. Managing Properties and Property Categories5. Alternate Hierarchies6. Mappings7. Managing Data Feeds8. Versioning9. Business Rules10. Users11. Workflow12. API IntegrationExam ObjectivesThe exam objectives are defined by learner or practitionerlevel of knowledge: Learner-level: questions require the candidate to recall information todetermine the correct answer.Example: Define the term network. Practitioner-level: questions require the candidate to derive the correct answerfrom the application of their knowledge, which can only be attained by extensiveexperience with the product.Example: The client requests xyz functionality, would you recommend a, b or c?For Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Training OptionsFor each exam topic there have been identified alternative training options that areavailable at Oracle. The training options are divided into three categories: Boot CampsThe Boot Camps are designed as a "jump start" training to enhance your skillsby providing role-based training on industry-leading Oracle solutions andservices. The boot camps are built as concise, intensive, and real-time trainingto give partners a competitive advantage as they prepare to build powerfulsolutions for their own customer base. Partners can choose to attend these bootcamps in class or in a live virtual class format to maximize the effectiveness andthe time allocated to training. Instructor-Led Training (delivered by Oracle University)Partners can take any publicly-scheduled Oracle University courses at steepdiscounts. Benefit from hands on experience to gain real working skill and worktoward Oracle certifications. Online TrainingOracle Partners are entitled free access to the Oracle Knowledge Center(OUKC), a vast library of recorded product courses. New courses are regularlyadded to the library, providing partners with the latest information and training tomaster new products or to increase proficiency on the new releases.For Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 1: Implementation Scope and RisksObjectives Describe best practices for project scoping and establishingimplementation timelines Describe common implementation risks Describe phasing implementations Describe implementation roles and responsibilities Evaluate common customer Issues Evaluate common customer strengths Describe testing and rollout best onerPractitionerPractitionerTraining Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation SpecialistGuided Learning PathSample Question Select the two options that will complete this sentence to make it a true statement:"A customer who uses best practices in the master data management of relationships andhierarchies .“A. utilizes multiple points of maintenance for hierarchies and data relationshipsB. syncs master data to reporting systemsC. utilizes a web-based solution for mastering relationships between customer contactinformation and customer order informationD. syncs master data to ERP systemsE. utilizes a solution that is not based on business user requirementsFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 2: DRM OverviewObjectives Describe DRM key features Manage versions Manage hierarchies Manage nodes Use Property Queries Manage Exports / Reports Use Audit Data Describe user roles and responsibilities Describe the DRM erLearnerLearnerLearnerLearnerTraining Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation SpecialistGuided Learning PathSample Question Select the valid filter that that can be applied to narrow the transaction history results whensearching the transaction history?A. Property DescriptionB. Action DescriptionC. Specific transaction IDD. From and/or To valuesE. Node DescriptionFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 3: Managing the Initial Data LoadObjectives Perform structural reconciliation Manage naming collisions Manage duplicate ning Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation SpecialistGuided Learning PathFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 4: Managing Properties and Property CategoriesObjectives Manage properties from upstream and downstream systems Manage similar properties Manage property defaults Manage calculated properties (derived, inherited, lookup) Manage property scoping Manage node types Manage property categories Define and load properties and actitionerTraining Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation SpecialistGuided Learning PathSample Question Which special characters can cause issues when used in DRM metadata objects (e.g. propertyname)?A. B. C. &D. /E. \F. - 2nd question located on next pageFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 4: Managing Properties and Property Categories(continued)Sample Question Identify the true statements about designing properties for downstream systems.1. System names should not match property definition names2. Property definitions must have unique fully qualified names and labels acrossnamespaces.3. List values can be used to control end-user updates.4. List values in property definitions should match accepted formats and values ofdownstream systems.5. Users should build similar validations that are required for your downstream system.A. 1, 2, 4 onlyB. 1, 2, 3, 4 onlyC. 1, 3, 4 onlyD. 3, 4, 5 onlyE. 1, 2, 3, 4, 5For Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 5: Alternate HierarchiesObjectives Define and build alternate hierarchies Support differences or force consistency Build alternate hierarchies from attributes and an exportLevelLearnerPractitionerPractitionerTraining Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Specialist GuidedLearning PathSample Question Per the naBaton RougeNew OrleansNorthNew YorkNew York CityMassachusettsBostonWestCaliforniaLos AngelesSan FranciscoYou maintain the Market hierarchy in DRM. A target system needs a mapping of Sales Managers toSales Region (North, West, and South). Each Region will have a single Sales Manager. A SalesManager will be responsible for only one Region. What is the best way to meet this requirement?A. Create an alternate hierarchy in the Market dimension with Regions rolling up to Sales ManagerB. Create a local property called "Sales Manager" for the entity node and populate the assignedsales manager at the city nodes.C. Create a global inheriting property called "Sales Manager" for the entity node andpopulate the assigned sales manager for the Market nodes.D. Create a property category called "Region" for the Sales Manager node and populate theassigned regionE. Create a property called "Region" for the Sales Manager node and populate the assigned regionFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 6: MappingsObjectives Manage basic one-to-one or one -to-many mappings using properties Manage basic one-to-one or one -to-many mappings using hierarchies Manage complex many-to-many mappingsLevelLearnerLearnerPractitionerTraining Options OPN Boot Camp– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation Boot Camp OU Instructor Led Training– Oracle Hyperion Data Relationship Management 11.1.2 Administration OPN Competency Center– Oracle Hyperion Data Relationship Management 11.1 .2 Implementation SpecialistGuided Learning PathSample Question- located on next pageFor Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 6: Mappings(continued)Sample Question Per the example:All Products100 (Colas, TBH Colas Product Family)100-10 (Cola, TBH Cola Classic)100-20 (Diet Cola, TBH The Original Diet Cola)100-30 (Cola Zero, TBH Cola Zero with Zero Calories)200 (Root Beers, Root Beers Product Family)200-10 (Root Beer, TBH Root Beer Classic)200-20 (Diet Root Beer, TBH The Original Diet Root Beer)200-30 (Root Beer Zero, TBH Root Beer Zero with Zero Calories)300 (Fruit Sodas, Fruitastic Sodas Product Family)300-10 (Strawberry, Strawberry Fruitastic)400-10 (Grape, Grape Fruitastic)You need to build the Product hierarchy in your budgeting and forecasting system. Users will not plan at theSKU level but the product category level (e.g. Colas, Root Beer, etc.). Users will input into nodes that exist atthe SKU level called “Colas Budget Input”, “Root Beer Budget Input”, etc. For every product category, abudget input node should be loaded to the budgeting and forecasting system. The resulting hierarchy in thebudgeting system should look like the following:All Products100 (Colas, TBH Colas Product Family)100-10 (Cola, TBH Cola Classic)100-20 (Diet Cola, TBH The Original Diet Cola)100-30 (Cola Zero, TBH Cola Zero with Zero Calories)100 Budget Input200 (Root Beers, Root Beers Product Family)200-10 (Root Beer, TBH Root Beer Classic)200-20 (Diet Root Beer, TBH The Original Diet Root Beer)200-30 (Root Beer Zero, TBH Root Beer Zero with Zero Calories)200 Budget Input300 (Fruit Sodas, Fruitastic Sodas Product Family)300-10 (Strawberry, Strawberry Fruitastic)400-10 (Grape, Grape Fruitastic)300 Budget InputIdentify the valid ways to meet this requirement in DRM.A. Create an export that pulls the Product Category nodes. Modify the export output to add a newcolumn with the node value that appends the “Budget Input” text to create a parent child format.Import and blend the new nodes into the DRM Product hierarchy.B. Create an export that pulls the Product Category nodes. In the export, pull in the Name column twice andon the select “Name” column, append the “Budget Input” text creating a parent child type of export.C. Create a derived property definition called “Budget Input”. Build derived logic to check - if at the ProductCategory level in the hierarchy, populate the property with a concatenation of the name and “Budget Input”.Create a single export that pulls both the full hierarchy in parent child format and the Budget input property tocreate a complete hierarchy in parent – child format. Use the export output to build the Product hierarchy inthe Budgeting and forecasting system.D. Create a derived property definition called “Budget Input”. Build derived logic to check if at theProduct Category level, populate the property with a concatenation of the name and “Budget Input”.Create an export book that combines a Hierarchy export for full Product hierarchy and a secondexport selecting the Name and Budget Input properties. Use the export output to build the Producthierarchy in the Budgeting and forecasting system.For Oracle employees and authorized partners only. Do not distribute to third parties. 2012 Oracle Corporation – Proprietary and Confidential

Topic 7: Managing Data FeedsObjectives Identify upstream and downstream systems Identify and analyze interfaces used Describe timing of feeds Describe file formats and restrictions Describe Imports, Action