Page: 1
/ 5
Total 69 questions
Identify three key benefits of the Planning solution.
- A. Standardized data forms for plan data entry available both for the Web and in Excel
- B. One tool to budget and forecast as well as provide reporting for very detailed Actuals Information
- C. Central repository of business rules that can be run by end users to calculate plan data
- D. Detailed security down to the cell level
- E. Flexible solution customizable for almost any kind of budgeting and forecasting process
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
Workspace?
- A. Planning
- B. EPMA
- C. ODI
- D. LCM
- E. Calculation Manager
- F. EAS
- G. FR Studio
Answer : A,B,D,E
Explanation: A: Planning is available within Oracle Enterprise Performance Management
Workspace -
B: Oracle Enterprise Performance Management Architect (EPMA) is accessible from the
EPM Workspace.
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
applications
Identify the three differences between Grid Spreader and Mass Allocate.
- A. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
- B. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
- C. Both M-3CG Allocate and Grid Spreader require special roles in Shared Services.
- D. Grid Spreader gives users a "preview" to the spread result before saving whereas Mass Allocate will automatically save results to the server.
- E. Both Mass Allocate and Grid Spreader support relational spread.
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?
- A. Define Product Status as a Smart List.
- B. Define Product Status as a Separate Dimension.
- C. Define Product Status as an Attribute.
- D. Define Product Status as a Varying Attribute.
- E. Define Product Status as an alternate hierarchy in the Product dimension.
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 11.1.1.3
Identify the three true statements about the CapEx Planning module.
- A. Is a prebuilt plan type focused on capital expense related planning
- B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security
- C. Can be initialized within an existing Planning application
- D. Can be created as a stand-alone application
- E. Because planning limits an application to three plan types, Capex Planning must be the third plan type.
Answer : A,B,C
Explanation:
Capex (Capital Expense Planning Process) is:
- Planning for new asset purchase
Depreciation/Amortization calculations
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?
- A. The business rule has not been assigned to the data form.
- B. The business rule was created for another plan type.
- C. The valid locations have not been defined for the business rule.
- D. The valid locations have not been defined for the data form.
- E. The Validate and Launch privileges have not been granted for the business rule.
- F. The Validate and Launch privileges have not been granted for the data form.
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?
- A. FIX (Budget, @LEVMBRS (Market,0)) "Marketing expense" = "Marketing expense "->Corporate * ("Marketing expense" Actual / "Marketing expense" -> Actual > TotalMarket); ENDFIX
- B. FIX (Budget, (@LEVMBRS (Market, 0) ) ) "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing expense" > TotalMarket) ; ENDFIX
- C. FIX (Budget, (@LEVMBRS (Market, 0) ) --- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX
- D. FIX (@LEVMBRS (Market, 0) ) "Marketing expense" = "Marketing expense"~>Corporate * (Marketing expense Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX
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?
- A. Run a business rule to change the employee's status.
- B. Change the employee's status on a data form using the Smart List drop down.
- C. Change the employee's status on a data form using the free form text measure.
- D. Change the employee status attribute association in the Employee dimension.
- E. Delete the employee from Workforce Planning.
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.
Incorrect answer:
Deleting the employee is a bad praxis. It would remove old salary entries.
You do not access the attributes directly on the Employee dimension.
Note: The Workforce Planning Module for Hyperion Planning provides a robust set of calculations and pre-defined web-forms that allows organizations to track and budget down to the benefit-level for each employee.
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.
- A. The planning unit is set to first pass.
- B. Another user owns the planning unit.
- C. The user has read access to the members on the data form.
- D. The form contains summary-level members in a bottom up version.
- E. The form is set to Read Only.
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.
Users -
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?
- A. The user doesn't have the Launch Business Rules role in Shared Services.
- B. The user hasn't been assigned Validate or Launch Privileges in EAS.
- C. The location for the Business Rule hasn't been defined.
- D. The user hasn't been assigned access to the Business Rule in the Planning Web client.
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
Incorrect answer:
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.
- A. Select or reject records based on certain criteria.
- B. Flip the sign for records with a certain member tagged with a comment.
- C. Split or join columns in a source.
- D. Find and replace manipulations on source records.
- E. Map data based on an external table.
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")?
- A. Block Storage Option Essbase database
- B. Aggregate Storage Option Essbase database
- C. Relational database
- D. XOLAP database
- E. Proprietary database
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?
- A. Anyone with write access to the planning unit
- B. Anyone with write access to the planning application
- C. Anyone with read or write access to the planning unit
- D. The owner of the planning unit
- E. The administrator
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 11.1.1.3,
Overview of the Review Process -
Identify the two true statements about shared members.
- A. You can assign a custom attribute value to a shared member.
- B. You can define a member formula for a shared member.
- C. You can assign security rights to a shared member.
- D. There is no limit to the number of shared members that you can create for the base member.
- E. Shared members may be defined for Accounts and Entity dimensions only.
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?
- A. Aggregate
- B. Copy Data
- C. Clear Block
- D. Clear Data
- E. Create Block
- F. Allocate
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.
Note:
* 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 -
30 days access 