1Z0-533 Online Practice Questions and Answers

Correct Answer: ADF

Note: WFP ?Workforce planning. Oracle Hyperion Capital Expense Planning (CAPEX) software is a specialized planning module that automates the planning of capital assets and capital asset related expenses, such as depreciation, maintenance and insurance.

Correct Answer: ACDE

Administrators can use Copy Data to copy plans from one dimensional intersection to another (A), including relational data and supporting detail (C).

You can copy account annotations (E), supporting detail, and cell text (D). You cannot copy planning unit annotations.

Reference: Oracle Hyperion Planning, Fusion Edition, Copying Data

Correct Answer: AD

ESSCMD is the original command line interface for administration commands.

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.

Correct Answer: ABC

A: Planning Web Client provides complete functionality for Web users. Use the Web interface to roll out applications to large, distributed organizations without installing software on client computers.

All software resides on the server. Many administrative features that were formerly in the Planning Desktop are now available through Planning Web.

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.

Correct Answer: D

Hyperion Planning Utilities can only be used locally.

Correct Answer: AC

Dynamic Calc members in a block storage outline that Essbase calculates only at retrieval time. Essbase discards calculated values after completing the retrieval request.

Correct Answer: ABC

Ways to create data blocks:

1.

Data Load, (B)

2.

DataCopy Command, (A)

3.

Sparse Dimension Consolidation,

4.

Member Formulas:

4a. Assiging a constant value to a sparse member,

4b. Turning Create Block on Equation setting on and assiging a non constant value (C)

4c. Create non missing blocks

B: The moment we load data to essbase, It creates block for those combinations automatically.

C: Controls, within a calculation script, whether or not new blocks are created when a calculation formula assigns anything other than a constant to a member of a sparse dimension. SET

CREATEBLOCKONEQ overrides the Create Block on Equation setting for the database.

If calculations result in a value for a sparse dimension member for which no block exists, Analytic Services creates a new block. Sometimes, the new blocks are not desired; for example, when they contain no other values. In large databases,

creation and processing of unneeded blocks can increase processing time as well as the storage requirement for a database.

For the situation when new blocks would be created as a result of assigning something other than a constant to a member of a sparse dimension, Analytic Services provides the Create Blocks on Equation setting. For example, when the

Create Blocks on Equation setting is ON and West is assigned a value where it did not have a value before, new blocks are created. When this setting is OFF, new blocks are not created.

Incorrect answer:

Copy Data--Use to copy data from one part of your database to another. You select the source data to copy and specify the target or destination value.

D: Aggregate data. There is no such specific command or utility. It is just a general concept in the Hyperion context.

Correct Answer: ABDE

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

Correct Answer: B

Set the time balance as "last" when you want the parent value to represent the value of the last member in the branch (often at the end of a time period).

Note:

Essbase - Time balance properties

The tags :

first,

last,

average,

and expense

are available exclusively for use with accounts dimension members.

Using this tag requires an accounts dimension and a time dimension

If an accounts dimension member uses the time balance property, it affects how Essbase calculates the parent of that member in the time dimension. By default, a parent in the time

dimension is calculated based on the consolidation and formulas of its children. For example, in the database in this scenarion, the Q1 member is the sum of its children (Jan, Feb, and Mar). However, setting a time balance property causes

parents, for example Q1, to roll up differently.

If you set the time balance as first, last, or average, set the skip property to tell Essbase what to do when it encounters missing values or values of 0.

Correct Answer: AE

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.

Reference: Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3, Overview of the Review Process