1z0-533 Oracle Hyperion Planning 11 Essentials Questions and Answers

Administrators use Smart Lists to create custom drop-down lists that users access from data

form cells. When clicking into cells whose members are associated with a Smart List (as a member

property), users select items from drop-down lists instead of entering data. Users cannot type

in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when

users click into the cells.

Perform these tasks to create and administer Smart Lists:

* Define Smart Lists

* Associate Smart Lists with members.

* Select dimensions for which Smart Lists are displayed.

Set the time balance as “last” when you want the parent value to represent the value of the last member in the branch (often at the end of a time period).

Note:

Essbase - Time balance properties

The tags :

first,

last,

average,

and expense

are available exclusively for use with accounts dimension members.

Using this tag requires an accounts dimension and a time dimension

If an accounts dimension member uses the time balance property, it affects how Essbase calculates the parent of that member in the time dimension. By default, a parent in the time dimension is calculated based on the consolidation and formulas of its children. For example, in the database in this scenarion, the Q1 member is the sum of its children (Jan, Feb, and Mar). However, setting a time balance property causes parents, for example Q1, to roll up differently.

If you set the time balance as first, last, or average, set the skip property to tell Essbase what to do when it encounters missing values or values of 0.

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.

After you establish or update user and group security, the Planning application needs to be

refreshed to complete the update to Analytic Services security filters.

Incorrect:

D: This options badly worded. We here assume that the security of the member has not changed.

C, E: no security has changed.

Data types:

How values are stored and displayed:

*Currency (A)

*Non-Currency (B)

*Percentage (C)

*Smart List (F)

*Date (G)

*Text (E)

*Unspecified

F

or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate Type

to None.

Note:

The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.All members in the accounts dimension inherit the accounts property. You can create an outline that does not have an accounts dimension.

In addition to other capabilities, the Report Designer provides cascaded output of

reports in Excel. This will enable end users to create a report in Excel and cascade

it to separate sheets based on members of a dimension not included as part of the

report.