1Z0-533 Oracle Hyperion Planning 11 Essentials

Exam Number: 1Z0-533
Exam Title: Oracle Hyperion Planning 11 Essentials
Associated Certification Paths: Oracle Hyperion Planning 11 Certified Implementation Specialist

Exam Details:
Duration: 120 minutes
Number of Questions: 70
Passing Score: 66%
Validated Against:  This exam has been validated against 11.1.1.
Format: Multiple Choice

Training Increases Your Chance of Passing
Complete Recommended Training

Complete the training below to prepare for your exam (optional):
Oracle Hyperion Planning 11.1.1: Create & Manage Applications
Oracle Hyperion Planning 11.1.1 for Interactive Users

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Resources available to partners only
Training Opportunities for Oracle Partner Network Members
Hyperion Planning 11.1.1 Implementation Boot Camp
Hyperion Planning 11.1.2 Implementation Boot Camp
Oracle Hyperion Planning 11.1.1 Implementation Specialist Guided Learning Path

Review Exam Topics
Overview of Hyperion Planning

Describe the main features of Hyperion Planning
Describe the product architecture of Hyperion Planning
Access Planning through Workspace

Creating a Planning Applciation
Set up data source
Describe and use the Calendar
Described and use Plan Types

Modeling in Planning
Describe dimensions
Describe members and member properties
Create scenario dimensions
Create version dimensions
Set up entity dimensions
Set up account dimensions
Describe dense and sparse dimensions
Set up currencies and exchange rates
Set up user defined dimensions and attribute dimensions Data Loading
Describe different dimension build alternatives
Describe different data load alternatives
Share Planning data within an application and outside an application

EPMA
Describe EPM Architect
Create dimension members in EPMA

Forms Designer
Create and edit data forms and folders
Manage user variables
Create Custom Menus
Create Smart Lists

Planning End User Functions
Perform Planning End User features over the web
Use End User features in Smart View
Use work flow process management to copy data between application versions

Calculations, Business Rules, & Calculation Manager
Describe Business Rules and capabilities
Create and manage business rules
Describe and use member formulas and calc scripts
Use Calculation Manager

Planning Security and Administration
Describe security in Planning
Describe user provisioning in Shared Services
Provision users and groups for Planning
Generate provisioning reports
Assign access rights in Dimension Editor
Import access rights
Create security filters
Perform general application administration tasks

Other
Describe financial reporting basics
Described and use Workforce Planning
Describe and use Capital Expense Planning

QUESTION 1
Identify the two statements about the Planning Import security utility.

A. Imports Planning application access for users and groups
B. Imports users and groups into Planning
C. Requires the source text file to be named PLANSECFILE.txt
D. Can be scheduled to run nightly using an encrypted password
E. Clears existing security definitions by default before the import takes place

Answer: A,D

Explanation: The Import Security utility performs a Oracle Hyperion Planning security import.
A: The ImportSecurity utility loads access permissions for users or groups from a text file into Planning.
(To add users or groups, see the Oracle Hyperion Enterprise Performance Management System
Security Administration Guide. . not B)
Importing access permissions overwrites existing access assignments only for imported members,
data forms, data form folders, task lists, Calculation Manager business rules, and Calculation
Manager business rule folders. All other existing access permissions remain intact. (not E).
The SL_CLEARALL parameter clears all existing access permissions; you can use it with other
parameters to replace existing access permissions. See also Exporting Access Permissions.
D: To import access permissions into Planning:
Locate the ImportSecurity utility by navigating to the bin directory.
From the Command Prompt, enter this case-sensitive command, one space, and the parameters,
separating each with a comma. Enclose the parameters with double quotation marks:
ImportSecurity.cmd [-f:passwordFile]
“appname,username,[delimiter],[RUN_SILENT],[SL_CLEARALL]”
This command can be scheduled.

QUESTION 2
Identify the two true statements about a sparse Entity dimension In Hyperion Planning.

A. You cannot build alternate rollups or assign custom attributes.
B. Base currencies are assigned to entity members.
C. Exchange rates are assigned to entity members.
D. Entity along with Scenario and Period make up a planning unit.
E. Entity along with Scenario and Version make up a planning unit.

Answer: B,E

Explanation: E: The Scenario and Version dimensions represent the broadest categories of data in your application. Scenario describes the type of data that a plan includes, such as budget, actual, or forecast, as well as the time span that the plan covers.
Version allows for flexibility and iterative planning cycles. For example, your application could have two versions, Working and Final, for each scenario. You can also use versions to model possible outcomes based on different assumptions about interest rates, growth rates, and so on. For
example, your application an have a Best Case and Worst Case version for each scenario.
Note:
Essbase maximizes performance by dividing the Essbase – Standard dimensions of an application
into two types:
dense dimensions
sparse dimensions.
Sparse and dense are a property of the values of an attribute.
Sparse
Data is normally stored in sparse form. If no value exists for a given combination of dimension values, no row exists in the fact table. For example, if not every product is sold in every market. In this case, Market and Product are sparse dimensions.
It’s why in the reporting tool Obiee for instance, by default, data are considered sparse.
Dense
Most multidimensional databases may also contain dense dimensions. A fact table is considered to have dense data if it has (of a high probability to have) one row for every combination of its associated dimension levels.

QUESTION 3
In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?

A. Dimension and member changes are pushed to Essbase.
B. Cell text and supporting detail changes are pushed to Essbase.
C. Security filters for dimensions and members are pushed to Essbase.
D. Security filters for shared members are pushed to Essbase.
E. Data changes are pushed to Essbase.

Answer: A,C,D

Explanation: During refresh:
* Essbase security filters are updated (C, D)
* Currency conversion calc scripts are updated
* Accounts or associated properties are propagated from the relational database to the Essbase database
* Custom attributes are added, modified, or deleted in the Essbase database
* Exchange rate values are repopulated in the Essbase outline
* Member formulas for certain accounts are generated or updated
* Additions or changes to alias tables and their association to dimensions or members are updated (A)
* The Essbase database is restructured
* UDAs are added to the Essbase database

Reference: Oracle Hyperion Planning, Fusion Edition, Creating and Refreshing Application Databases

QUESTION 4
You are designing a monthly projection Planning application. A starting point projection file is received with the current month data. Data forms, Business Rules, and Essbase data load rules, and reports should always focus on the current projection month.

What is most efficient way to design the components to reduce maintenance each month?

A. Manually update the forms each month and use a “CurMth” substitution variable for Business Rules, Essbase data load rules, and reports.
B. Manually update the forms each month; Use “CurMo” Global variable for Business Rules and use a “CurMth” substitution variable for Essbase data load rules, and reports.
C. Use the Planning data form utility to update data forms and use a “CurMth” substitution variable for Business Rules, Essbase data load rules, and reports.
D. Use a “CurMth” substitution variable for data forms, Business Rules, Essbase data load rules, and reports.
E. Use the Planning data form utility to update data forms; Use “CurMo” Global variable for Business Rules and use a “CurMth” substitution variable for Essbase data load rules, and reports.

Answer: E

Explanation: In Business Rules use a global variable.In Essbase, use a substitution variable.

Click here to view complete Q&A of 1Z0-533 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-533 Certification, Oracle 1Z0-533 Training at certkingdom.com