Pass the Oracle Planning 1z0-533 Questions and answers with CertsForce

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

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.

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.

The Hyperion Planning gurus gave us the following advice:

*Row and Column contain dense dimensions only

*Page and Point of View (POV) contain sparse dimensions only

Suppress Missing Data option enabled so as to not display Rows or Columns without data

Split data forms into multiple data forms that contain fewer Rows and Columns

To put it more simply – KEEP DATA FORMS SMALL!

Note: Dense dimension: In block storage databases, a dimension

likely to contain data for every combination of dimension

members. For example, time dimensions are often dense

because they can contain all combinations of all members.

Sparse dimension: In block storage databases, a dimension

unlikely to contain data for all member combinations when

compared to other dimensions. For example, not all

customers have data for all products

Point of View (POV): Shows information about other members that are valid for the defined

row and column members. POVs identify the database members that populate a data form,

and define data intersections. Members on the rows, columns, and POV axes are constant

(except when they have dynamic user variables).

Page lists: Display different views (pages) of selected member combinations that can span

dimensions, enabling you to work with various member combinations.

A:Usage of dynamic calc in sparse dimensionincludes benefits such asshorter aggregations smaller database size.

C:Consider the number of members underneath a sparse parent. It's generally good practice to have few (up to 20) members under dynamic sparse parents if your block size is not massively huge. This number might increase if your block size is tiny.

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.

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)

Capex (Capital Expense Planning Process) is:

- Planning for new asset purchase

– Depreciation/Amortization calculations

– Planning for action on existing assets

– Planning for driver based/user defined asset related expenses

– Capital purchases process management (future release)

– Reporting on Asset

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.

When launched, a business rule can prompt you to enter variable information, called a runtime

prompt. The business rule designer sets up runtime prompts.

If a business rule has a runtime prompt and Use Members on Forms is selected, the default

member on the runtime prompt window matches the current member in the page or POV

axes of the open data form.