1z0-533 Exam Dumps - Oracle Planning Questions and Answers

Fragmentation is unused disk space.

EssBase Database fragmentation is likely to occur with the following:

Read/write databases that users are constantly updating with data (E).

Databases that execute calculations around the clock

Databases that frequently update and recalculate dense members (B)

Data loads that are poorly designed

Databases that contain a significant number of Dynamic Calc and Store members

Databases that use an isolation level of uncommitted access with commit block set to zero

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. "

You candynamically build the Entity dimension in the Planning applicationwith the help ofODI, DIM and EPMA.

With Version 11(and later)you can also use the outline loader.

Incorrect:

not A:you can't use essbase load rules, metadata has to be loaded to planning and then pushed to essbase.

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

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.

A: Planning is available within Oracle Enterprise Performance Management Workspace

B: Oracle Enterprise Performance Management Architect (EPMA) is accessible from the EPM Workspace.

D: The Shared Services Web application and the LCM utility communicate over TCP/IP to the EPM Workspace Core Service.

Note: One of the smartest tools Oracle/Hyperion ever integrated into its product suite was the migration utility. Overtime this has evolved to the LifeCycle Managment utility or LCM for short. Actually Oracle/Hyperion has taken it even one step further by calling its fully integrated migration tool the BI+ Artifact LifeCycle Management utility even though they have retained the same acronym, LCM.

E: Calculation Manager was introduced in EPM workspace common Foundation Services in release 11.

Single interface for both Hyperion

Planning and Financial Management

– Graphical flow provides better

understanding of calculation process

– Re-usable rules to share among

applications

B:

"If you specify a Dynamic Calc or Dynamic Calc and Store member explicitly in a calculation script, the calculation script fails. You cannot do a calculation script calculation of a Dynamic Calc or Dynamic Calc and Store member. To use a calculation script to calculate a member explicitly, do not tag the member as Dynamic Calc.

E: The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a query).

Incorrect answer:

F: Storing the information is no advantage in this scenario.

User-defined custom dimensions differ from the Entity and Account dimensions in that you

assign valid plan types at the dimension level, not at the member level. All members of a user defined custom dimension are valid for plan types assigned at the dimension level.

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.

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.