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

The Import Security utility performs a Oracle Hyperion Planning security import.

A: The ImportSecurity utility loads access permissions for users or groups from a text file into Planning.

(To add users or groups, see the Oracle Hyperion Enterprise Performance Management System Security Administration Guide. . not B) 

Importing access permissions overwrites existing access assignments only for imported members, data forms, data form folders, task lists, Calculation Manager business rules, and Calculation Manager business rule folders. All other existing access permissions remain intact. (not E).

The SL_CLEARALL parameter clears all existing access permissions; you can use it with other parameters to replace existing access permissions. See also Exporting Access Permissions.

D: To import access permissions into Planning:

Locate the ImportSecurity utility by navigating to the bin directory.

From the Command Prompt, enter this case-sensitive command, one space, and the parameters, separating each with a comma. Enclose the parameters with double quotation marks:

ImportSecurity.cmd [-f:passwordFile] “appname,username,[delimiter],[RUN_SILENT],[SL_CLEARALL]”

This command can be scheduled.

Not C: Business Rules are a powerful to automate complex calculations.

However, arule typically runs a specific calculation/allocation on a single Essbase Database.

E: Macros are used to avoid duplicating code.

Incorrect:

not A:ESSCMD is the original command line interface for administration commands.

Not B: Cacl scripts is a powerful to automate calculations.

Not D:MaxL, a "multi-dimensional database access language" which provides both a superset of ESSCMD commands, but with a syntax more akin to SQL, as well as support for MDX queries.

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.

A: Reducing the amount of rows and columns that need to be accessed would increase performance.

B: The client machine could also be a bottleneck.

E: Indexing and caching would help when loading data into a form.

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 Administrator’s Online Help)

The number of stored members in sparse Dimensions will help us in finding potential number of blocks

Potential Number of Blocks = Stored Members in Market * Stored Products in Scenario.

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.