1Z0-533 Online Practice Questions and Answers

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.

Correct Answer: ACE

A: Open the Dimension Library and select File >

New > Dimension. Enter a name and description, then select the Alias type.

C: From planning 9 3 1 you can also create attribute hierarchy in planning.

E: Attribute dimensions have a type setting--text, numeric, Boolean, or date. Text is the default setting.

Correct Answer: A

Custom menus can be used to launch the following:

Business Rules

Context sensitive data forms

URL

Context sensitive Process Management

Correct Answer: D

You can use the Create Blocks action to make sure that blocks are created in the database for sparse member combinations in a specified slice of data. Since there is a potential for a large increase in the database size when creating blocks,

be careful when adding this action to your business rule. To help you get an idea of the size, the system displays a calculation of the block size and maximum possible blocks that would exist for the specified data slice after the business rule

is launched. Since some blocks may exist in the database, this calculation does not represent the exact amount of the increase.

Note: You can choose from four possible actions to include in a graphical business rule:

Aggregate

Data, Copy Data, Clear Data, and Create Blocks.

*

Create Blocks--Use to specify a data slice to ensure that blocks are created for all sparse member combinations in that slice.

*

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 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 to clear cells or to clear blocks of data.

Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1, Adding a Create Blocks Actio

Correct Answer: D

All users can set personal preferences in the current application.

To set personal preferences:

1 Select File, then Preferences.

2 Click Planning, then perform an action:

*

Select Application Settings to set e-mail options, select an alias table, and set options for member selection and workflow.

*

Select Display Options to set options for number formatting, page selection, warnings for large data forms, and the number of dimensions to show on a page.

Correct Answer: C

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.

Correct Answer: C

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.

Correct Answer: ACDE

A: To add supporting detail that calculates values in a data form:

1 Open a data form in Excel,

2 In the data form, select the data cells for which you want to add detail.

3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

4 Etc.

7. Enter data for the items for which you want to set or calculate values.

When you enter numbers into the Supporting Detail window, use the scaling that was set up for the data values in the data form.

8 Click OK.

Values are dynamically calculated and aggregated before the data is saved.

C: Supporting detail can include text, values, and operators that define how data aggregates.

Supporting detail also provides a way to drill down into data to better understand its basis. For example, if the bottom-level member in your outline is pens, you can add line items in supporting detail for ballpoint, fountain, marker, and so on. Then you can aggregate the detail values to the pen member in the outline.

D:Oracle Hyperion Smart View for Office (Excel, PowerPoint, Word, and Outlook), are some of the various Oracle tools that enable users to interact with an Oracle Essbase application.

Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

E: In Planning applications, when you delete supporting detail for a cell, you affect the associated value in the relational database. You specify how to handle the stored Essbase value.

Note (on A and E): To synchronize supporting detail with Essbase:

1 Open a data form in Excel

2 In the data form, click the cell that has the supporting detail you want to remove.

3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

4 In the Supporting Detail window, delete the information, then click OK.

5 Select an option from the displayed message to specify how to handle the aggregate value of the deleted

supporting detail stored in Essbase:

To delete the value from Essbase, click Yes, set the value(s) to #Missing.

To leave the data value in Essbase as is, click No, leave the value(s) as is.

Correct Answer: CD

C: Access cannot be assigned directly to a shared member. You assign access rights to shared members in one of two ways:

*

From the security assigned directly to the base member

*

From the security assigned at the parent or ancestor of the shared member

D: You can create multiple shared members for the base member. A base member must exist before you can create a shared member, but there is no limit to the number of shared members you can create for the base member.

E: Shared members are available for Entity, Account, and user-defined custom dimensions. " Shared members contain read-only values and are only available in the Entity dimension. "

Correct Answer: AE

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.

Reference: Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3, Overview of the Review Process