Oracle Oracle Certifications 1Z0-533 Questions & Answers

• Question 11:

  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 "Headcount" account member, what will user see for Q1?

  A. January's value

  B. March's value

  C. The total of January+February +March

  D. The average of January + February + March

  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.

• Question 12:

  Identify the correct set of required dimensions for Planning.

  A. Account

  B. Entity

  C. Version

  D. Years and Periods combined into one dimension

  E. Scenario

  F. Minimum one user-defined dimension

  Correct Answer: ABCDE

  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

  HSP_Rates

  Note:

  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.

  Entity

  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.

  Account

  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.

  Currency

  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

  HSP_Rates

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

  As a Planning end user, you need to add additional commentary to your plan, documenting assumptions and other notes.

  What are the six available options to add this information?

  A. Supporting detail

  B. Planning unit annotations

  C. Cell text

  D. Free form text (if defined by your Planning administrator)

  E. Smart Lists (if defined by your Planning administrator)

  F. Attach a document to a data form from Workspace (if enabled by your Planning administrator)

  G. Financial Reporting Annotations in a Financial Reporting document (against the Planning application)

  Correct Answer: ABCDFG

  Incorrect answer:

  With a smart list you can only select from pre-defined options in a list-

• Question 14:

  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.

  A. Administrator for the CapEx application

  B. Administrator for the Planning Server

  C. Provisioning Manager for the CapEx application

  D. Planning Calculation Manager for the CapEx application

  E. Dimension Editor for the CapEx dimensions

  F. Application Manager in Essbase for the CapEx dimensions

  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.

• Question 15:

  Identify the two true statements about Enterprise performance Management Architect.

  A. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications.

  B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in 11.1.1.3.

  C. You can create Planning, TM, Essbase, and FDM applications in EPMA.

  D. Data can be shared from a Planning application to an FM application within EPMA.

  E. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.

  F. In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet)

  Correct Answer: BD

  B: Calculation Manager, a component of Hyperion Enterprise Performance

  Management Architect, is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase.

  D: EPMA Data Synchronization--Enables data synchronization within Hyperion applications. You can use the Data Synchronizer to:

  *Create data movement synchronizations between Hyperion applications. For example, an administrator can synchronize data between two Financial Management; two Planning

  applications, and between one Financial Management and a Planning application

  *Create data mappings for reuse *Create flat file and interface table mappings to import data into Hyperion applications

  Note:

  

• Question 16:

  You are designing a new Planning application.

  Which two requirements dictate multiple plan types in a single Planning application?

  A. Multiple currencies are required.

  B. Currency rates must be kept in a separate database.

  C. Sales are planned by product and channel, and salary expenses are planned by position.

  D. Security is applied to the Entity dimension but can differ for users for accounts "sales" and "expenses".

  E. You have decided to implement the Capital Expense planning module in addition to PSL budgeting.

  F. Data cannot be shared across the Organization dimension.

  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.

• Question 17:

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

  A. Run on Save

  B. @CALCMODE function

  C. Run time prompts

  D. Can be run over the web

  E. Substitution Variables

  F. Custom Defined Functions

  Correct Answer: C

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

• Question 18:

  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?

  A. Potential Blocks = 40 * 17*2

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

  C. Potential Blocks = 100 * 500

  D. Potential Blocks = 100 * 500 * 8

  E. Potential Blocks = 100 * 550

  F. Potential Blocks = 100 * 550 * 8

  Correct Answer: C

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

  Identify the true statements regarding Supporting Detail. Select all that apply.

  A. Importing Supporting Detail from Excel is supported.

  B. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible

  C. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.

  D. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.

  E. Supporting Detail is stored in Essbase.

  Correct Answer: ACDE

  A: To add supporting detail that calculates values in a data form:

  1 Open a data form in Excel,

  2 In the data form, select the data cells for which you want to add detail.

  3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

  4 Etc.

  7. Enter data for the items for which you want to set or calculate values.

  When you enter numbers into the Supporting Detail window, use the scaling that was set up for the data values in the data form.

  8 Click OK.

  Values are dynamically calculated and aggregated before the data is saved.

  C: Supporting detail can include text, values, and operators that define how data aggregates.

  Supporting detail also provides a way to drill down into data to better understand its basis. For example, if the bottom-level member in your outline is pens, you can add line items in supporting detail for ballpoint, fountain, marker, and so on. Then you can aggregate the detail values to the pen member in the outline.

  D:Oracle Hyperion Smart View for Office (Excel, PowerPoint, Word, and Outlook), are some of the various Oracle tools that enable users to interact with an Oracle Essbase application.

  Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

  E: In Planning applications, when you delete supporting detail for a cell, you affect the associated value in the relational database. You specify how to handle the stored Essbase value.

  Note (on A and E): To synchronize supporting detail with Essbase:

  1 Open a data form in Excel

  2 In the data form, click the cell that has the supporting detail you want to remove.

  3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

  4 In the Supporting Detail window, delete the information, then click OK.

  5 Select an option from the displayed message to specify how to handle the aggregate value of the deleted

  supporting detail stored in Essbase:

  To delete the value from Essbase, click Yes, set the value(s) to #Missing.

  To leave the data value in Essbase as is, click No, leave the value(s) as is.

• Question 20:

  Fragmentation in an underlying Planning Essbase database that is caused by what two actions?

  A. Delete member from a sparse dimension.

  B. Delete member from a dense dimension.

  C. Renaming a member.

  D. Renaming an alias.

  E. Submitting data / deleting data frequently.

  Correct Answer: BE

  Fragmentation is unused disk space.

  EssBase Database fragmentation is likely to occur with the following:

  Read/write databases that users are constantly updating with data (E).

  Databases that execute calculations around the clock

  Databases that frequently update and recalculate dense members (B)

  Data loads that are poorly designed

  Databases that contain a significant number of Dynamic Calc and Store members

  Databases that use an isolation level of uncommitted access with commit block set to zero