Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 1:

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

  A. At least one member in the Scenario dimension
  B. At least one member In the Version dimension
  C. At least one member in the Period dimension
  D. At least one member in the Account dimension
  E. At least one member in the Entity- dimension
  F. If security has been assigned for a Custom dimension, at least one member in the user-defined custom dimension
  A. At least one member in the Scenario dimension
  B. At least one member In the Version dimension
  E. At least one member in the Entity- dimension
  F. If security has been assigned for a Custom dimension, at least one member in the user-defined custom dimension

  ---

  Scenario,Version and 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 2:

  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.
  A. Importing Supporting Detail from Excel is supported.
  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.

  ---

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

  Planning utilizes which type of database to store data (for example, "the numbers")?

  A. Block Storage Option Essbase database
  B. Aggregate Storage Option Essbase database
  C. Relational database
  D. XOLAP database
  E. Proprietary database
  A. Block Storage Option Essbase database

  ---

  Since version 7, Essbase has supported two "storage options" (BSO and ASO) which take advantage of sparsity to minimize the amount of physical memory and disk space required to represent large multidimensional spaces. The Essbase

  patent describes the original method, which aimed to reduce the amount of physical memory required without increasing the time required to look up closely-related values. With the introduction of alternative storage options, marketing

  materials called this the Block Storage Option (Essbase BSO), later referred to as

  Essbase Analytics.

  (BSO) enables driver-based scenario modeling, forecasting, and predictive analytic applications.

  Note: To give you our idea of the ideal application of ASO and BSO,:

  ASO Database: The ASO database is ideal for dynamically built Essbase cubes that are usually Read Only and used for reporting, presentation, and analysis. This type of database would also tend to have a rather large outline where at least

  one dimension has a significant amount of members. A parts dimension or product dimension comes to mind.Behind this ASO database would be a large BSO parent Essbase database, from which the dynamic ASO databases are built on

  the fly.

  BSO Database: The BSO database is ideal for virtually any size cube, but where performance is not necessarily the number one priority. Accuracy and completeness of data would be the main consideration. The BSO database is ideal as the

  large parent database where users from many different departments can trigger jobs which will dynamically build ASO reporting cubes on an as needed basis. The typical BSO database is ideally suited for financial analysis applications.

• Question 4:

  A planning unit is the basic unit______.

  A. for preparing, reviewing, and approving data.
  B. for calculating and storing currency plan data.
  C. for assigning security to plan data.
  D. for reporting and analyzing plan data.
  E. made up of Scenario, Entity, and Account.
  A. for preparing, reviewing, and approving data.

  ---

  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

• Question 5:

  Identify the two true statements assuming you are working with a single application with multiple plan types.

  A. A user-defined custom dimension may exist in one plan type but not the other plan types.
  B. A user-defined custom dimension may have members in one plan type but not the remaining plan types.
  C. All members in the entity dimension must exist in all plan types.
  D. All members in the accounts dimension must exist in all plan types.
  E. All periods must exist in all plan types.
  A. A user-defined custom dimension may exist in one plan type but not the other plan types.
  E. All periods must exist in all plan types.

  ---

  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.

• Question 6:

  In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?

  A. Dimension and member changes are pushed to Essbase.
  B. Cell text and supporting detail changes are pushed to Essbase.
  C. Security filters for dimensions and members are pushed to Essbase.
  D. Security filters for shared members are pushed to Essbase.
  E. Data changes are pushed to Essbase.
  A. Dimension and member changes are pushed to Essbase.
  C. Security filters for dimensions and members are pushed to Essbase.
  D. Security filters for shared members are pushed to Essbase.

  ---

  During refresh:

  *

  Essbase security filters are updated (C, D)

  *

  Currency conversion calc scripts are updated

  *

  Accounts or associated properties are propagated from the relational database to the Essbase database

  *

  Custom attributes are added, modified, or deleted in the Essbase database

  *

  Exchange rate values are repopulated in the Essbase outline

  *

  Member formulas for certain accounts are generated or updated

  *

  Additions or changes to alias tables and their association to dimensions or members are updated (A)

  *

  The Essbase database is restructured

  *

  UDAs are added to the Essbase database

  Reference: Oracle Hyperion Planning, Fusion Edition, Creating and Refreshing Application Databases

• Question 7:

  The budget office analyst needs to enter and plan data, use the Planning spreading feature that allow users to spread budget data based on last year's actuals, and modify data forms. What two roles should be provisioned for this user?

  A. Grid Spread
  B. Planner
  C. Interactive User
  D. Mass Allocate
  E. Offline User
  B. Planner
  C. Interactive User

  ---

  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

• Question 8:

  Identify the three differences between Grid Spreader and Mass Allocate.

  A. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
  B. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
  C. Both M-3CG Allocate and Grid Spreader require special roles in Shared Services.
  D. Grid Spreader gives users a "preview" to the spread result before saving whereas Mass Allocate will automatically save results to the server.
  E. Both Mass Allocate and Grid Spreader support relational spread.
  A. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
  B. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
  D. Grid Spreader gives users a "preview" to the spread result before saving whereas Mass Allocate will automatically save results to the server.

  ---

  Grid spread allocates data across the cells on the webform and runs on the client browser.Mass allocate triggers a calc script which can allocate data beyond cells those are available in the form.

  If your administrator has enabled Grid Spread as a data form property, you can specify an amount or percentage by which Planning increases or decreases values across multiple dimensions on the data form, based on the existing values in the target cells. You immediately see the result in the data form and can save the new data or discard it. When calculating the spread data, Planning ignores read-only and locked cells and cells having supporting detail. Data integrity is ensured by spreading values only to cells to which you have access.

  If you have the Mass Allocate role (assigned in Oracle's Hyperion?Shared Services) and an administrator has enabled Mass Allocate as the data form property, you can spread data using the powerful feature, Mass Allocate, which:

• Question 9:

  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
  A. Account
  B. Entity
  C. Version
  D. Years and Periods combined into one dimension
  E. Scenario

  ---

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

  Identify the three true statements about the CapEx Planning module.

  A. Is a prebuilt plan type focused on capital expense related planning
  B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security
  C. Can be initialized within an existing Planning application
  D. Can be created as a stand-alone application
  E. Because planning limits an application to three plan types, Capex Planning must be the third plan type.
  A. Is a prebuilt plan type focused on capital expense related planning
  B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security
  C. Can be initialized within an existing Planning application

  ---

  Capex (Capital Expense Planning Process) is:

  -Planning for new asset purchase

  

  Depreciation/Amortization calculations

  

  Planning for action on existing assets

  

  Planning for driver based/user defined asset related expenses

  

  Capital purchases process management (future release)

  

  Reporting on Asset