1z0-533 Practice Exam Questions with Answers Oracle Hyperion Planning 11 Essentials Certification

C: Columns cannot be split or joined at runtime in the source.

D: Essbase reads the data values or members in the data source, changes them based on the rules in the rules file, and loads the changed data values into the database and the changed members into the outline. Essbase does not change the data source.

First calculate the aggregated saleries.

Then make the custom calculation on the saleries.

Finally use the result of the custom calculation to product the benefits.

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.

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.

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.

A: Reducing the amount of rows and columns that need to be accessed would increase performance.

B: The client machine could also be a bottleneck.

E: Indexing and caching would help when loading data into a form.

Scenarios and versions are the basis of the planning review cycle. Entities submit planning data

for a particular scenario and version. The combination of scenario, version, and entity is called

a planning unit and is the basic unit for preparing, reviewing, and approving plan data.

Not C: Business Rules are a powerful to automate complex calculations.

However, arule typically runs a specific calculation/allocation on a single Essbase Database.

E: Macros are used to avoid duplicating code.

Incorrect:

not A:ESSCMD is the original command line interface for administration commands.

Not B: Cacl scripts is a powerful to automate calculations.

Not D:MaxL, a "multi-dimensional database access language" which provides both a superset of ESSCMD commands, but with a syntax more akin to SQL, as well as support for MDX queries.

Hyperion Planning Utilities can only be used locally.

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.

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.

You can change the status of the Employee through options from a Drop down/Smart List on a data form by running a Business Rule.

Incorrect answer:

Deleting the employee is a bad praxis. It would remove old salary entries.

You do not access the attributes directly on the Employee dimension.

Note: The Workforce Planning Module for Hyperion Planning provides a robust set of calculations and pre-defined web-forms that allows organizations to track and budget down to the benefit-level for each employee.

A: Properties for User-Defined Custom Dimensions include property Valid for Plan Types which is used to select plan types for which the dimension is valid. Clearing this option makes all members of the dimension invalidfor the deselected plan type.

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.

Note: Specify one to three plan types for the application. A separate Essbase database is created for each plan type. You cannot change the name or number of plan types after creating an

application.

As you create accounts, entities, and other elements of the application, you associate them with

plan types, so the database for each plan type contains only information relevant to the plan

type. This optimizes application design, size, and performance.

B: Oracle Hyperion Essbase Administration Services (Essbase Administration Services) software is a robust, cross-platform graphical user interface that makes Essbase administration tasks easy to perform.

Administrators can simultaneously view and edit properties for multiple Hyperion Essbase databases, applications, users, scripts, and other objects from a single intuitive view.

Essbase Administration Services also provides wizards, editors, dynamic menus, and other tools to help you implement, monitor, and maintain analytic and enterprise performance management applications.

C: Enterprise Performance Management Architect (EPMA) enables administrators to manage, create, and deploy Hyperion applications within one interface. EPMA can do adds, moves, modify properties, etc.

D: Oracle Hyperion Data Relationship Management (DRM) is an enterprise change management solution for building and retaining consistency within master data assets despite endless changes necessary to support underlying transactional and analytical systems.

After you establish or update user and group security, the Planning application needs to be

refreshed to complete the update to Analytic Services security filters.

Incorrect:

D: This options badly worded. We here assume that the security of the member has not changed.

C, E: no security has changed.