1Z0-533 Online Practice Questions and Answers

Correct Answer: BE

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.

Correct Answer: AB

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.

Reference: HYPERION SYSTEM 9 PLANNING, RELEASE 9 . 2 . 0 . 3 About Security in Planning

Correct Answer: ACE

A: If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern.

E:

Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks in a month. This determines how data in summary time periods spreads within the base time period. When users enter data into summary time

periods, such as quarters, the value is distributed over base time periods in the summary time period.

Correct Answer: A

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.

Reference: Hyperion System 9 Planning, Planning Units

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

Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking into cells whose members are associated with a Smart List (as a

member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells.

Perform these tasks to create and administer Smart Lists:

*

Define Smart Lists

*

Associate Smart Lists with members.

*

Select dimensions for which Smart Lists are displayed.

Correct Answer: B

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.

Correct Answer: CE

C: When you define an entity member, you assign a plan type for which it is valid. If you do not assign a plan type to a member, that member's children do not have access to that plan type. If you move a member, and the new parent of that member is valid for different plan types, then the member remains valid only for the plan types it has in common with the new parent.

Your organization may require that different entity members prepare different plans. For example, in your organization all entity members may submit expense plans, but entity members that are cost centers do not submit revenue plans.

When you define entity members you specify the plan types for which they are valid. Because data forms are associated with plan

types, this allows you to control which entity members can enter data for each plan type.

E: You would need two plan type. To add a Capital Expense plan type to an existing application see Note below.

Note: To add the Capital Asset Planning plan type to a Planning application:

1 In Performance Management Architect, select Navigate, then Administer, then Application Library.

2 In the Application Library, right-click the application to which you want to add the Capital Asset Planning plan type, select Initialize, then select Capital Asset or Workforce and Capital Asset if the application will use both plan types.

3 To confirm the initialization, click Yes.

Correct Answer: ACE

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.

Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1

Correct Answer: AB

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.