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

We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size.

Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions.Note: Optimal range is 8 to 100 kb

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.

B: Replicated Partition:

A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.

C:

Transparent partition: 

A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

Note: @XREF

Enables a database calculation to incorporate values from another Essbase database.

The following terminology is used to describe the @XREF function:

Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).

Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).

Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).

The @XREF function retrieves values from a data source to be used in a calculation on a data target. @XREF does not impose member and dimension mapping restrictions, which means that the data source and data target outlines can be different.

Note #2:

Hyperion planning's Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan types in Hyperion Planning or equivalent databases in underlying Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

During refresh:

* Essbase security filters are updated (C, D)

* Currency conversion calc scripts are updated

* Accounts or associated properties are propagated from the relational database to the Essbase database

* Custom attributes are added, modified, or deleted in the Essbase database

* Exchange rate values are repopulated in the Essbase outline

* Member formulas for certain accounts are generated or updated

* Additions or changes to alias tables and their association to dimensions or members are updated (A)

* The Essbase database is restructured

* UDAs are added to the Essbase database

B: members of the dimension entity must be first delete in data forms and then in the library dimension

D: Make a backup to retain the information.

E: A refresh of the database is required.

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.

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.