1z0-533 Exam Dumps : Oracle Hyperion Planning 11 Essentials

A:

To create and change attributes, attribute values, and aliases:

1 Select Administration, then Dimensions.

2 Select a sparse dimension for which to define an attribute, attribute value, or alias.

Only sparse dimensions can contain attributes.

3 Select the top level in the dimension hierarchy, and click Edit.

4 In the Dimension Properties dialog box, click Custom Attributes.

5 Select options.

5.1 To create attributes, click Create. Type an attribute name, and select a data type: Text,

Date, Boolean, or Numeric.

5.2 To modify attributes, click Modify, and update the attribute name.

5.3 To set aliases for attributes, select an attribute and an attribute value, click Alias. Select an

alias table, type an alias name, and click Close.

6 Click Close.

When you click Close, the hierarchy is validated and an error displays if issues are detected.

7 Update and validate business rules and reports.

B: Attributes can have data types of text, date, Boolean, and numeric.

E: An attribute dimension is a special type of dimension that is associated with a standard dimension. A standard dimension is any dimension that is not an attribute dimension. When an attribute dimension is associated with a standard dimension, the standard dimension is the base dimension for that attribute dimension. I

Planning data forms can be accessed from within the EPM Workspace and from Smart View Planning Provider.

Note: Smart View provides a common Microsoft Office interface for Oracle Essbase, Oracle Hyperion Financial Management, Fusion Edition, Oracle Hyperion Planning, Fusion Edition, Oracle Enterprise Performance Management Workspace, Fusion Edition, Oracle Business Intelligence Enterprise Edition, and Oracle's Hyperion® Enterprise® data. Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint interfaces.

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.