[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-533 Dumps with VCE and PDF Download 11-20

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan Oracle Official New Released 1z0-533
100% Free Download! 100% Pass Guaranteed!

Oracle Hyperion Planning 11 Essentials

Question No: 11

Identify the one Planning component that is not accessible over the Web.

  1. Dimension Editor for Planning

  2. Shared Services

  3. Exchange Rates Definition

  4. Planning Utilities

  5. Create and Manage Database Options

  6. Create Data Sources

Answer: D

Explanation: Hyperion Planning Utilities can only be used locally.

Question No: 12

Assuming you have a Period dimension with calendar months rolling to quarters to total years. If you assign the property Time Balance Last to the quot;Headcountquot; account member, what will user see for Q1?

  1. January#39;s value

  2. March#39;s value

  3. The total of January February March

  4. The average of January February March

Answer: B

Explanation: 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).


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.

Question No: 13

You have the following design requirement: You need to track customer status For a sales planning application. Valid options for customer status include: Active, Inactive, Out of Business. Customer status can change on a month-by-month basis.

What is the best way to build Customer Status into the Planning application?

  1. Attribute dimension

  2. Varying attribute dimension

  3. Smart List

  4. Free Form Text

  5. Alternate hierarchy

Answer: C

Explanation: 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.

Question No: 14

What are the three supported methods to create and update a member and its properties (assuming Classic or non-Classic Planning applications)?

  1. Planning Web Client

  2. EAS

  3. EPMA

  4. DRM

  5. Outline Load Utility

Answer: B,C,D

Explanation: 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.

Question No: 15

You need to calculate benefit expense in your Planning application using the following

logic: Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to each cost center.

Given the following components, what is the correct order of calculation:

1-Custom calculation (Total Salary * Factor) 2-Aggregate benefits

3-Aggregate salaries

A. 1, 2, 3

B. 3, 2, 1

C. 2, 3, 1

D. 3, 1, 2

Answer: D

Explanation: 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.

Question No: 16

Identify the two true statements about a sparse Entity dimension In Hyperion Planning.

  1. You cannot build alternate rollups or assign custom attributes.

  2. Base currencies are assigned to entity members.

  3. Exchange rates are assigned to entity members.

  4. Entity along with Scenario and Period make up a planning unit.

  5. Entity along with Scenario and Version make up a planning unit.

Answer: B,E

Explanation: E: The Scenario and Version dimensions represent the broadest categories of data in your application. Scenario describes the type of data that a plan includes, such as budget, actual, or forecast, as well as the time span that the plan covers.

Version allows for flexibility and iterative planning cycles. For example, your application could have two versions, Working and Final, for each scenario. You can also use versions to model possible outcomes based on different assumptions about interest rates, growth

rates, and so on. For example, your application an have a Best Case and Worst Case version for each scenario.


Essbase maximizes performance by dividing the Essbase – Standard dimensions of an application into two types:

dense dimensions sparse dimensions.

Sparse and dense are a property of the values of an attribute. Sparse

Data is normally stored in sparse form. If no value exists for a given combination of dimension values, no row exists in the fact table. For example, if not every product is sold in every market. In this case, Market and Product are sparse dimensions.

It#39;s why in the reporting tool Obiee for instance, by default, data are considered sparse.


Most multidimensional databases may also contain dense dimensions. A fact table is considered to have dense data if it has (of a high probability to have) one row for every combination of its associated dimension levels.

Question No: 17

A planning unit is the basic unit .

  1. for preparing, reviewing, and approving data.

  2. for calculating and storing currency plan data.

  3. for assigning security to plan data.

  4. for reporting and analyzing plan data.

  5. made up of Scenario, Entity, and Account.

Answer: A

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


a planning unit and is the basic unit for preparing, reviewing, and approving plan data. Reference: Hyperion System 9 Planning, Planning Units

Question No: 18

What option contributes to making an Enhanced Calc Script more flexible than a native Essbase Calc Script?

  1. Run on Save

  2. @CALCMODE function

  3. Run time prompts

  4. Can be run over the web

  5. Substitution Variables

  6. Custom Defined Functions

Answer: C

Explanation: An Enhanced Calc Script is a calc script created with Business Rules that contains run-time prompts.

Question No: 19

Given the following:

Measures (Dense): 40 stored members, 50 total members Time (Dense): 17 stored members, 17 total members Scenario (Dense): 2 stored members, 5 total members Market (Sparse): 100 stored members, 100 total members Product (Sparse): 500 stored members, 550 total members How many potential blocks could be created?

  1. Potential Blocks = 40 * 17*2

  2. Potential Blocks = 40* 17*2*8

  3. Potential Blocks = 100 * 500

  4. Potential Blocks = 100 * 500 * 8

  5. Potential Blocks = 100 * 550

  6. Potential Blocks = 100 * 550 * 8

Answer: C

Explanation: The number of stored members in sparse Dimensions will help us in finding potential number of blocks

Potential Number of Blocks = Stored Members in Market * Stored Products in Scenario.

Question No: 20

Identify the three characteristics of the Scenarios dimension.

  1. Security can be assigned to members of the Scenario dimension.

  2. It allows the administrator to assign valid periods for data entry

  3. It allows bottoms up or target planning

  4. Exchange rate tables are tied to the Scenario dimension.

  5. One member in the scenario dimension may be valid for Plan Type.

Answer: A,B,D

Explanation: A: Specify access rights to members of the Scenario dimension for groups or users. Access rights

determine users or groups can view or modify data. A user or group can have only one of these

access rights: Read, Write, or None. Access rights for a user can be combined based on groups

to which the user belongs.

B: When creating a scenario For Start Yr., Start Period, End Yr., and End Period are used to select the time period to associate with the scenario.

D: The Scenario dimension has an Exchange Table property with value of the name of an exchange rate table defined in the application.

Reference: Oracle Hyperion Planning, Fusion Edition

100% Ensurepass Free Download!
Download Free Demo:1z0-533 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-533 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.