Identify three key benefits of the Planning solution.
Answer : A,C,E
Explanation: A: Hyperion Planning leverages Multidimensional functionalities and capabilities of Essbase to the fullest to provide varied planning options along with inherent
Data Forms, MS Excel, Web based grid interface for the data entry and reporting needs. ata Forms in Hyperion planning provides a standard centralized grid-based interface for data entry and data-checks. Customizing or fixing a Data Form issues take lesser time and effort compared to the Excel based spreadsheets.
C: Use of a central repository makes administration and maintenance of business rules easy, because the repository stores information for several applications in one database.
A user or group who has the role of basic user can do these tasks:
* Launch business rules and sequences to which the user has access
* View business rules and sequences to which the users has access
* View all variables and macros
* Edit business rules, sequences, macros, variables, and projects for which the user was granted editing privileges
E: Oracle Hyperion Planning provides an in-depth look at business operations and its related impact on financials, by tightly integrating financial and operational planning models. With Oracle Hyperion Planning you can meet your immediate financial planning needs while enabling a platform for future cross-functional expansion and automated process integration.
Reference: Hyperion Business Rules, Administrative Guide
Planning administrators can access which four administration tools via the EPM
Answer : A,B,D,E
Explanation: A: Planning is available within Oracle Enterprise Performance Management
B: Oracle Enterprise Performance Management Architect (EPMA) is accessible from the
D: The Shared Services Web application and the LCM utility communicate over TCP/IP to the EPM Workspace Core Service.
Note: One of the smartest tools Oracle/Hyperion ever integrated into its product suite was the migration utility. Overtime this has evolved to the LifeCycle Managment utility or LCM for short. Actually Oracle/Hyperion has taken it even one step further by calling its fully integrated migration tool the BI+ Artifact LifeCycle Management utility even though they have retained the same acronym, LCM.
E: Calculation Manager was introduced in EPM workspace common Foundation Services in release 11.
Single interface for both Hyperion
Planning and Financial Management
Graphical flow provides better
understanding of calculation process
Re-usable rules to share among
Identify the three differences between Grid Spreader and Mass Allocate.
Answer : A,B,D
Explanation: Grid spread allocates data across the cells on the webform and runs on the client browser.Mass allocate triggers a calc script which can allocate data beyond cells those are available in the form.
If your administrator has enabled Grid Spread as a data form property, you can specify an amount or percentage by which Planning increases or decreases values across multiple dimensions on the data form, based on the existing values in the target cells. You immediately see the result in the data form and can save the new data or discard it. When calculating the spread data, Planning ignores read-only and locked cells and cells having supporting detail. Data integrity is ensured by spreading values only to cells to which you have access.
If you have the Mass Allocate role (assigned in Oracle's Hyperion Shared Services) and an administrator has enabled Mass Allocate as the data form property, you can spread data using the powerful feature, Mass Allocate, which:
-> Allocates data to all the source cell's descendants
-> Allocates across multiple dimensions
-> Spreads data even to cells not displayed on the data form
-> Does not require that you have access to the target cells
-> Cannot be undone after you mass allocate values
-> Is processed with dynamically-created calc scripts
-> Executes the calc scripts against the Essbase server, against all dimension combinations
-> Can use customized spreading patterns, created by an administrator (see the Oracle Hyperion Planning Administrators Online Help)
Product status is a data element you need to include in your Planning application. Each product will have a product status that can vary over time. You will use product status in calculations and will need to report sales by product status and across products in a cross tab format.
What is the best way to meet all of these requirements?
Answer : D
Explanation: Varying Attributes -
About Varying Attributes -
A product typically has attributes that describe or define the product. For example, a product could have an attribute describing the size of the product in ounces and an attribute describing the flavor of the product. In such a scenario, Product would be a base dimension while Ounces and Flavor would be attribute dimensions.
A varying attribute enables you to track two values in relation to a third dimension called an independent dimension. You could, for example, track your product in eight ounces over a year.In this scenario, Time is the independent dimension. The value of this third factor can vary (hence the name). For example, you could track your product over a year, a quarter, or a month.
Reference: Oracle Hyperion Planning, Fusion Edition, Release 184.108.40.206
Identify the three true statements about the CapEx Planning module.
Answer : A,B,C
Capex (Capital Expense Planning Process) is:
- Planning for new asset purchase
Planning for action on existing assets
Planning for driver based/user defined asset related expenses
Capital purchases process management (future release)
Reporting on Asset
Assuming EAS Business rules, a user cannot see a business rule on a data Form. What are three possible causes?
Answer : A,C,E
Explanation: A: Business Rules can be assigned to data forms.
C: You can manage database locations, and the access privileges of repository objects that are assigned to them, using the Location Editor. You can use the Location Editor to create, edit, and copy database locations, assign new access privileges to locations, copy access privileges from one location to another, and copy business rules from one location to another.
E: When you validate a business rule, Business Rules determines whether the member or members you select exist in the database and whether the syntax of the business rule is correct.
You need to have access privileges to all rules in the sequence before you can launch it.
Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1
You need to create an allocation Business Rule that allocates marketing expense from corporate down to each region based on FY10 actuals for the Budget scenario. What is the correct formula assuming this syntax is used in an enhanced calc script?
Answer : B
In the Workforce Planning module, an employee is terminated. What two activities do you perform in WFP, so that total salary numbers are correctly calculated?
Answer : A,B
Explanation: You can change the status of the Employee through options from a Drop down/Smart List on a data form by running a Business Rule.
A planner is supposed to be able to submit data within a data form.
What are all the possible causes for an end user not being able to enter data on a data form? Select all that apply.
Answer : C,D,E
Explanation: C, E: By assigning access to a data form, you control which users can change its design (for example, its layout and instructions) and input data. Users can select only members to which they have read or write access. Users can edit data forms only if they have access to at least one member of each secured dimension. For example, if users have read-only access to the Europe entity, the rows and columns on data forms that include the Europe entity are displayed as read-only.
can change data only for members to which they have write access.
D: For bottom-up versions, rows and columns with level 0 members allow data entry. Rows or columns set to a parent member are read-only. The point of view must also be set to the level 0 member to allow data entry on a bottom-up version. Target versions allow data entry in parent and children members.
If you assign children to bottom-up versions, these versions display as read-only parents on data forms.
You've created an EAS business rule and assigned it to the data form but an end user can't see it. What are two valid reasons?
Answer : A,B
Explanation: A: If the user does not have the launch the Business Rules role, it could prevent the user from seeing the rule.
B: The Validate or launch Privilege enables a users or users you specify to validate and launch the business rule sequence
C: The business rule has already been assigned to the Data Form.
Identify two ways that Essbase data load rules cannot manipulate source data files.
Answer : C,D
Explanation: C: Columns cannot be split or joined at runtime in the source.
D: Essbase reads the data values or members in the data source, changes them based on the rules in the rules file, and loads the changed data values into the database and the changed members into the outline. Essbase does not change the data source.
Reference:Understanding Data Loading and Dimension Building
Planning utilizes which type of database to store data (for example, "the numbers")?
Answer : A
Explanation: Since version 7, Essbase has supported two "storage options" (BSO and
ASO) which take advantage of sparsity to minimize the amount of physical memory and disk space required to represent large multidimensional spaces. The Essbase patent describes the original method, which aimed to reduce the amount of physical memory required without increasing the time required to look up closely-related values. With the introduction of alternative storage options, marketing materials called this the Block
Storage Option (Essbase BSO), later referred to as Essbase Analytics.
(BSO) enables driver-based scenario modeling, forecasting, and predictive analytic applications.
Note: To give you our idea of the ideal application of ASO and BSO,:
ASO Database: The ASO database is ideal for dynamically built Essbase cubes that are usually Read Only and used for reporting, presentation, and analysis. This type of database would also tend to have a rather large outline where at least one dimension has a significant amount of members. A parts dimension or product dimension comes to mind.Behind this ASO database would be a large BSO parent Essbase database, from which the dynamic ASO databases are built on the fly.
BSO Database: The BSO database is ideal for virtually any size cube, but where performance is not necessarily the number one priority. Accuracy and completeness of data would be the main consideration. The BSO database is ideal as the large parent database where users from many different departments can trigger jobs which will dynamically build ASO reporting cubes on an as needed basis. The typical BSO database is ideally suited for financial analysis applications.
A Planning Unit has a status of First Pass; what two user types can input data?
Answer : A,E
Explanation: A: In all Planning Units states except the Not Started state, users with read access can view data, view the process state, view the history, and read and enter annotations.
E: The Administrator have full access.
Reference: Reference: Oracle Hyperion Planning, Fusion Edition, Release 220.127.116.11,
Overview of the Review Process -
Identify the two true statements about shared members.
Answer : C,D
Explanation: C: Access cannot be assigned directly to a shared member. You assign access rights to shared members in one of two ways:
* From the security assigned directly to the base member
* From the security assigned at the parent or ancestor of the shared member
D: You can create multiple shared members for the base member. A base member must exist before you can create a shared member, but there is no limit to the number of shared members you can create for the base member.
E: Shared members are available for Entity, Account, and user-defined custom dimensions.
" Shared members contain read-only values and are only available in the Entity dimension.
What four prebuilt actions are available In EAS Business Rules?
Answer : A,B,D,E
Explanation: You can choose from four possible actions to include in a graphical business rule: Aggregate
Data, Copy Data, Clear Data, and Create Blocks.
* Aggregate Data Use to calculate your database by specifying which dimensions to calculate and what calculation options you want to use during the aggregation.
* Copy DataUse to copy data from one part of your database to another. You select the source data to copy and then specify the target or destination value.
* Clear DataUse to define a subset of data that will be cleared from the database before a new value is added. You can choose either to clear cells or to clear blocks of data.
* Create BlocksUse to specify a data slice to ensure that blocks are created for all sparse member combinations in that slice.
Reference: Hyperion Business Rules, Administrative Guide, About Adding Actions to
Graphical Business Rules -