Oracle 1z0-533 - Oracle Hyperion Planning 11 Essentials

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.

Asymmetric rows and columns are ones in which different sets of members are selected across the same dimension.

A: To develop a calculation script that exports a subset of data, you first specify the SET

DATAEXPORTOPTIONS command to define options for export content, format, and process Use FIX…ENDFIX or EXCLUDE…ENDEXCLUDE calculations to select a slice of the database and use a DATAEXPORTCOND command to select data based on data values.

Note: The DATAEXPORT command enables calculation scripts to export data in binary or text, or directly to a relational database. A set of data-export-related calculation commands qualify what

data to export and provide various output and formatting options.

Compared to using other methods to export data, using a calculation script has the following

advantages and disadvantages:

Advantages:

Enables exporting a subset of data.

* Supports multiple targets: flat files, relational databases, and binary files (not B, C, D)

* Provides many flexible options for type and format or data.

* As part of a calculation script, can be easily deployed in a batch process.

* Can be very fast when the dynamic calculation export option is not used because DATAEXPORT directly accesses Kernel storage blocks in memory. (E)

* Provides, through binary export-import, a faster way to back up and restore data because the

compressed format used by binary export requires less storage for the export files.

* Can be used as a debug tool to trace batch calculation results by using the DATAEXPORT

command before and after other calculation commands to track data changes.

Disadvantages

Contains limited data formatting options compared to Report Writer formatting.

A:Usage of dynamic calc in sparse dimensionincludes benefits such asshorter aggregations smaller database size.

C:Consider the number of members underneath a sparse parent. It's generally good practice to have few (up to 20) members under dynamic sparse parents if your block size is not massively huge. This number might increase if your block size is tiny.

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.

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.

Fragmentation is unused disk space.

EssBase Database fragmentation is likely to occur with the following:

Read/write databases that users are constantly updating with data (E).

Databases that execute calculations around the clock

Databases that frequently update and recalculate dense members (B)

Data loads that are poorly designed

Databases that contain a significant number of Dynamic Calc and Store members

Databases that use an isolation level of uncommitted access with commit block set to zero

In Business Rules use a global variable.

In Essbase, use a substitution variable.

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 Data—Use 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 Data—Use 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 Blocks—Use to specify a data slice to ensure that blocks are created for all sparse

member combinations in that slice.