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

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

What four read or write security assignments allow end users to be able to view at least some data?

  1. At least one member in the Scenario dimension

  2. At least one member In the Version dimension

  3. At least one member in the Period dimension

  4. At least one member in the Account dimension

  5. At least one member in the Entity- dimension

  6. If security has been assigned for a Custom dimension, at least one member in the user- defined custom dimension

Answer: A,B,E,F

Explanation: Scenario,Version amp; Entity make up a planning unit so security needs to be applied here and then also to the custom dimension if it has security.

Question No: 32

You are designing a form for fast retrieval speed. Assuming a plan type with two dense dimensions and four sparse dimensions, what is the optimal layout?

  1. Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns

  2. Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV

  3. Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV

  4. Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns

  5. The layout of sparse and dense dimensions has no impact on form performance; only the number cells on a data form impacts form performance.

Answer: A

Explanation: The Hyperion Planning gurus gave us the following advice:

*Row and Column contain dense dimensions only

*Page and Point of View (POV) contain sparse dimensions only

Suppress Missing Data option enabled so as to not display Rows or Columns without data Split data forms into multiple data forms that contain fewer Rows and Columns

To put it more simply – KEEP DATA FORMS SMALL!

Note: Dense dimension: In block storage databases, a dimension likely to contain data for every combination of dimension members. For example, time dimensions are often dense because they can contain all combinations of all members.

Sparse dimension: In block storage databases, a dimension unlikely to contain data for all member combinations when compared to other dimensions. For example, not all customers have data for all products

Point of View (POV): Shows information about other members that are valid for the defined row and column members. POVs identify the database members that populate a data form, and define data intersections. Members on the rows, columns, and POV axes are constant (except when they have dynamic user variables).

Page lists: Display different views (pages) of selected member combinations that can span dimensions, enabling you to work with various member combinations.

Question No: 33

You have a new Planning administrator to manage the Capital Expenditure application. He will assign security for the application as well as maintain dimensions in EPMA, Business Rules in Calculation Manager, and load data via Essbase rules files. He will not need access to other applications. Choose the two valid roles that will address part or this entire requirement.

  1. Administrator for the CapEx application

  2. Administrator for the Planning Server

  3. Provisioning Manager for the CapEx application

  4. Planning Calculation Manager for the CapEx application

  5. Dimension Editor for the CapEx dimensions

  6. Application Manager in Essbase for the CapEx dimensions

Answer: D,E Explanation:

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.

Question No: 34

A Business Rule is launched from a data form. What will Planning utilize to provide a valid list of members for a run-time prompt?

  1. Members defined on the data form

  2. Planning Metadata security

  3. Business Rules security access privileges

  4. Essbase security filters

  5. Business Rules Basic User Role

Answer: A

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

Reference: Oracle Hyperion Planning, Fusion Edition, Release, Entering Runtime Prompts

Question No: 35

You need to create a highly formatted, printable Income statement for each store in your company. Each report should be emailed to the store manager at the close of each week (each store has a different store manager). What is the best way to deliver this solution?

  1. With Financial Reporting, create a book for each store that contains a Pamp;L for each store and use the book to distribute the reports to store managers via email.

  2. With Financial Reporting, create a store Pamp;L and use batch bursting to distribute the report to store managers via email.

  3. With Web Analysis, create an income statement that store managers can log in and access.

  4. Within Smart View Report Designer, use the Cascade feature to generate and distribute each store income statement via email.

  5. Create a Planning Pamp;L Data form and use email notification to send to store managers.

Answer: D Explanation:

In addition to other capabilities, the Report Designer provides cascaded output of reports in Excel. This will enable end users to create a report in Excel and cascade it to separate sheets based on members of a dimension not included as part of the report.

Question No: 36

Identify the correct set of required dimensions for Planning.

  1. Account

  2. Entity

  3. Version

  4. Years and Periods combined into one dimension

  5. Scenario

  6. Minimum one user-defined dimension

Answer: A,B,C,D,E

Explanation: The required dimensions for a Hyperion Planning Application.

Required Dimensions: Period

Year Scenario Version Entity Account

Other Dimensions: Alias

Smart Lists

Multicurrency applications require two additional dimensions: Currency



Period and Year

You specify a time period and year for each value. Base time periods, such as months, are automatically rolled up to summary time periods, such as quarters and total year. As administrators, you specify base time periods and distribution of weeks in the Period dimension when you create application views. You use the year dimension to add years to the calendar.

Scenario and Version

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.


The Entity dimension represents the flow of Planning information through your organization. You can establish an entity for each group or responsibility center that submits a budget plan. These units could be geographic regions, departments, or divisions, depending on your requirements.


The Account dimension specifies the data to be collected from budget planners. You can establish accounts for all budgeted items to the necessary level of detail. Examples of accounts are Rent Expense and Cash on Hand.


You can plan in one or more currencies. The Currency dimension identifies the currency in which values are displayed. In the Currency dimension, you set up the following categories:

  • Which currencies are used by applications and reporting

  • How currencies are displayed in reports and data forms

  • How currencies are translated into other currencies

  • When currency conversion occurs


This dimension contains a member to store exchange rate values for each currency. It also contains a member for input values and currency overrides.

Alias and Smart Lists

In addition to the required Planning dimensions, you must set up an Alias dimension if you want to assign aliases to dimensions such as Account or Entity. If you want to use Smart Lists in your application, you must set up a Smart List dimension.

Reference: Required Dimensions for a Hyperion Planning Application

Question No: 37

You have a measure in your Accounts dimension for quot;Pricequot;. Price Is Input by users (along with Units). Sales is calculated as Units * Price. Identify the correct property that should be assigned to Price to meet this requirement.

  1. Stored

  2. Dynamic Calc

  3. Dynamic Calc and Store

Answer: A

Explanation: Stored should be used.

Ensurepass 2018 PDF and VCE

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

Question No: 38

Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension. Identify the three true statements about deleting members from a Planning application.

  1. You must delete members one by one.

  2. You must delete a reference to a member from all data forms before deleting it from the dimension.

  3. In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to quot;ITquot; in this data form.

  4. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.

  5. A database refresh is required after deleting members from the Entity dimension.

Answer: B,D,E

Explanation: B: members of the dimension entity must be first delete in data forms and then in the library dimension

D: Make a backup to retain the information. E: A refresh of the database is required.

Question No: 39

Identity the true statement about Custom Menus.

  1. Custom menus can provide links to data forms, Business Rules, URLs, and Planning preferences.

  2. Custom menus require Java scripting knowledge to create.

  3. You can assign security to custom menus so that only specific users or groups can see the custom menu.

  4. Custom menus are assigned to data forms only.

  5. Custom menus are limited to a single list of tasks; you cannot group them into sub categories.

Answer: A

Explanation: Custom menus can be used to launch the following:

  • Business Rules

  • Context sensitive data forms

  • URL

  • Context sensitive Process Management

Question No: 40

Identify the three true statements about attribute dimensions.

  1. Planning supports hierarchies and aliases for attribute dimensions.

  2. Planning supports all attribute types (for example. Boolean, Date, Text).

  3. Planning supports varying attributes (where an attribute can vary over one or more other


  4. Attribute dimensions can be assigned to dense dimensions.

  5. Attribute dimensions may only be assigned to one base dimension.

Answer: A,B,E Explanation: A:

To create and change attributes, attribute values, and aliases: 1 Select Administration, then Dimensions.

  1. Select a sparse dimension for which to define an attribute, attribute value, or alias. Only sparse dimensions can contain attributes.

  2. Select the top level in the dimension hierarchy, and click Edit.

  3. In the Dimension Properties dialog box, click Custom Attributes. 5 Select options.

    1. To create attributes, click Create. Type an attribute name, and select a data type: Text, Date, Boolean, or Numeric.

    2. To modify attributes, click Modify, and update the attribute name.

    3. To set aliases for attributes, select an attribute and an attribute value, click Alias. Select an

alias table, type an alias name, and click Close. 6 Click Close.

When you click Close, the hierarchy is validated and an error displays if issues are detected.

7 Update and validate business rules and reports.

B: Attributes can have data types of text, date, Boolean, and numeric.

E: An attribute dimension is a special type of dimension that is associated with a standard dimension. A standard dimension is any dimension that is not an attribute dimension. When an attribute dimension is associated with a standard dimension, the standard dimension is the base dimension for that attribute dimension. I

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.