Free Practice Questions for Oracle 1z0-533 Exam

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.

B: Replicated Partition:

A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.

C:

Transparent partition: 

A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

Note: @XREF

Enables a database calculation to incorporate values from another Essbase database.

The following terminology is used to describe the @XREF function:

Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).

Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).

Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).

The @XREF function retrieves values from a data source to be used in a calculation on a data target. @XREF does not impose member and dimension mapping restrictions, which means that the data source and data target outlines can be different.

Note #2:

Hyperion planning's Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan types in Hyperion Planning or equivalent databases in underlying Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

Asymmetric rows and columns are ones in which different sets of members are selected across the same dimension.

D: The planning Calculation Manager Administrator enables you to create business rules using Hyperion Calculation Manager.

E: The global Shared Services role of Dimension Editor creates and manages dimensions.

The global Calculation Manager administrator role enables you to create, edit and delete Planning, FinancialManagement, and Essbase objects.

The Financial Management Calculation Manager administrator role enables to create, edit and delete Financial Management objects.

Custom menus can be used to launch the following:

– Business Rules

– Context sensitive data forms

– URL

– Context sensitive Process Management

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.

To set up the calendar:

1.In the Classic Application Wizard, click Calendar.

2 Select a Base Period option to set how calendars roll up:

*12 Months: Four quarters per year; months roll up into parent quarters and quarters into

years.

*Quarters: Quarters roll up into years.

* Custom: A custom time period, such as weeks or days.

Etc.

Note:

The calendar establishes the application’s base time periods, starting fiscal year and month, and

total number of years. Select the base time period and monthly distribution pattern based on

the number of fiscal weeks in a month. The base time period options are the bottom-level time

periods in the application. You can create a custom base time period, such as weeks or days. Use

monthly distribution patterns to determine how data entered into a summary time period is

distributed or spread among the base time period you select. During data entry, users can enter

data into summary time periods, such as years or quarters. Planning distributes these values over

the base time periods that constitute the summary time period.

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.

Data types:

How values are stored and displayed:

*Currency (A)

*Non-Currency (B)

*Percentage (C)

*Smart List (F)

*Date (G)

*Text (E)

*Unspecified

F

or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate Type

to None.

Note:

The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.All members in the accounts dimension inherit the accounts property. You can create an outline that does not have an accounts dimension.

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.

Incorrect:

not E: Supporting details are stored in Planning Applications RDBMS not in Essbase.