1Z0-533 Online Practice Questions and Answers

Correct Answer: AD

The Import Security utility performs a Oracle Hyperion Planning security import.

A: The ImportSecurity utility loads access permissions for users or groups from a text file into Planning.

(To add users or groups, see the Oracle Hyperion Enterprise Performance Management System Security Administration Guide. . not B)

Importing access permissions overwrites existing access assignments only for imported members, data forms, data form folders, task lists, Calculation Manager business rules, and Calculation Manager business rule folders. All other existing

access permissions remain intact. (not E).

The SL_CLEARALL parameter clears all existing access permissions; you can use it with other parameters to replace existing access permissions. See also Exporting Access Permissions.

D: To import access permissions into Planning:

Locate the ImportSecurity utility by navigating to the bin directory.

From the Command Prompt, enter this case-sensitive command, one space, and the parameters, separating each with a comma. Enclose the parameters with double quotation marks:

ImportSecurity.cmd [-f:passwordFile] "appname,username,[delimiter],[RUN_SILENT],[SL_CLEARALL]"

This command can be scheduled.

Correct Answer: BC

Planner:

The majority of Hyperion Planning users are planners who are responsible for department or project budgets. They conveniently work over the Web or the Spreadsheet Add-in to:

Enter, submit, and view data

Use pre-defined policies, procedures, routines, reports, and worksheets to enter, analyze, and report on application data

Interactive User:

Examples of an interactive user include a department head, sales director, or unit manager who submits budget information and data for approval. Interactive users can enter and view data. They can also create, maintain, and initiate:

Data entry forms on the Web

Spreadsheet Add-in worksheets

Reports using Hyperion Reports

Integrations using Hyperion Application Link

Business rules using Hyperion Business Rules

Correct Answer: AE

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.

Correct Answer: A

Stored should be used.

Note: The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.

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: ABCEF

A: Essbase data load rules: A set of criteria that determines how to load data from a text-based file, a spreadsheet, or a relational data set into a database.

You can use either the Data Load Rules and the Essbase Administration Services for Essbase 7/Analytic Administration Services for Analytic Services 9.2 or Hyperion Application Link with the Hyperion Essbase Adapter to load data into a

Planning application.

B: Oracle Data Integrator (ODI) is a comprehensive data integration platform that handles any data integration requirements--high-volume, high-performance batches, event-driven, trickle-feed integration processes, and SOA-enabled data

services.

C: One of the methods of loading Essbase cubes is by using the Hyperion Data Integration Management and its corresponding Essbase Adapter.

Data Integration Management is integrated with Informatica PowerCenter. It provides a way of uniting disparate sources of data across an enterprise. For example, it can integrate data stored in multiple warehouses and data marts, relational

database management systems (RDBMS), and on-line analytical processing (OLAP) stores.

E: The Outline Load Utility that comes with Oracle EPM 11 is a utility for loading the metadata as well as data into your Planning applications. Using the utility we can load metadata for the default dimensions like Account, Period, Year, Scenario, Version, Currency, Entity as well as user-defined dimensions, attributes and UDAs.

F: Enterprise Performance Management Architect or EPMA provides a uniform platform for metadata management across most of the Hyperion components. It enables administrators to manage, create, and deploy Hyperion applications within one interface. With EPMA you can configure dimensions, such as the Entity, and define properties from predefined, sample libraries.

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: DE

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.