Identify the two statements about the Planning Import security utility.

Correct Answer: AD 🗳️
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.

Identify the two true statements about a sparse Entity dimension In Hyperion Planning.

Correct Answer: BE 🗳️
E: The Scenario and Version dimensions represent the broadest categories of data in your application. Scenario describes the type of data that a plan includes, such as budget, actual, or forecast, as well as the time span that the plan covers.
Version allows for flexibility and iterative planning cycles. For example, your application could have two versions, Working and Final, for each scenario. You can also use versions to model possible outcomes based on different assumptions about interest rates, growth rates, and so on. For example, your application an have a Best Case and Worst Case version for each scenario.
Note:
Essbase maximizes performance by dividing the Essbase - Standard dimensions of an application into two types:
✑ dense dimensions
✑ sparse dimensions.
Sparse and dense are a property of the values of an attribute.

Sparse -
Data is normally stored in sparse form. If no value exists for a given combination of dimension values, no row exists in the fact table. For example, if not every product is sold in every market. In this case, Market and Product are sparse dimensions.
It's why in the reporting tool Obiee for instance, by default, data are considered sparse.

Dense -
Most multidimensional databases may also contain dense dimensions. A fact table is considered to have dense data if it has (of a high probability to have) one row for every combination of its associated dimension levels.

In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?

Correct Answer: ACD 🗳️
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
References:

You are designing a monthly projection Planning application. A starting point projection file is received with the current month data. Data forms, Business Rules, and Essbase data load rules, and reports should always focus on the current projection month.
What is most efficient way to design the components to reduce maintenance each month?

Correct Answer: E 🗳️
In Business Rules use a global variable.
In Essbase, use a substitution variable.