A: If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern.

E:

Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks

in a month. This determines how data in summary time periods spreads within the base time

period. When users enter data into summary time periods, such as quarters, the value is

distributed over base time periods in the summary time period.

The Hyperion Planning gurus gave us the following advice:

*Row and Column contain dense dimensions only

*Page and Point of View (POV) contain sparse dimensions only

Suppress Missing Data option enabled so as to not display Rows or Columns without data

Split data forms into multiple data forms that contain fewer Rows and Columns

To put it more simply – KEEP DATA FORMS SMALL!

Note: Dense dimension: In block storage databases, a dimension

likely to contain data for every combination of dimension

members. For example, time dimensions are often dense

because they can contain all combinations of all members.

Sparse dimension: In block storage databases, a dimension

unlikely to contain data for all member combinations when

compared to other dimensions. For example, not all

customers have data for all products

Point of View (POV): Shows information about other members that are valid for the defined

row and column members. POVs identify the database members that populate a data form,

and define data intersections. Members on the rows, columns, and POV axes are constant

(except when they have dynamic user variables).

Page lists: Display different views (pages) of selected member combinations that can span

dimensions, enabling you to work with various member combinations.

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.

First calculate the aggregated saleries.

Then make the custom calculation on the saleries.

Finally use the result of the custom calculation to product the benefits.

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

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.

Hyperion Planning Utilities can only be used locally.