Oracle Oracle Certifications 1Z0-533 Questions & Answers

• Question 31:

  A planning end user opens a data form and sees a long list of entities in the drop-down list in the Page section. She would like to shorten this list and use the search functionality instead.

  How can she change the number of members needed on a form to initiate a page dropdown search?

  A. Form Management>>Display tab

  B. Form Management>> Options tab

  C. Preferences>>Database Settings tab

  D. Preferences>> Display Options tab

  E. This change can only be made by the Planning Administrator.

  Correct Answer: D

  All users can set personal preferences in the current application.

  To set personal preferences:

  1 Select File, then Preferences.

  2 Click Planning, then perform an action:

  *

  Select Application Settings to set e-mail options, select an alias table, and set options for member selection and workflow.

  *

  Select Display Options to set options for number formatting, page selection, warnings for large data forms, and the number of dimensions to show on a page.

• Question 32:

  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.

  Correct Answer: ABC

  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

  

• Question 33:

  Why is the Create Blocks function in calc scripts and Business Rules important in Planning?

  A. Data may not exist for the combination of dense members so you have to create the block before calculating the data value for the block.

  B. Data may not exist for the combination of sparse members so you have to create the block before calculating the data value for the block.

  C. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block.

  D. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block.

  Correct Answer: D

  You can use the Create Blocks action to make sure that blocks are created in the database for sparse member combinations in a specified slice of data. Since there is a potential for a large increase in the database size when creating blocks,

  be careful when adding this action to your business rule. To help you get an idea of the size, the system displays a calculation of the block size and maximum possible blocks that would exist for the specified data slice after the business rule

  is launched. Since some blocks may exist in the database, this calculation does not represent the exact amount of the increase.

  Note: You can choose from four possible actions to include in a graphical business rule:

  Aggregate

  Data, Copy Data, Clear Data, and Create Blocks.

  *

  Create Blocks--Use to specify a data slice to ensure that blocks are created for all sparse member combinations in that slice.

  *

  Aggregate Data--Use to calculate your database by specifying which dimensions to calculate and what calculation options you want to use during the aggregation.

  *

  Copy Data--Use to copy data from one part of your database to another. You select the source data to copy and specify the target or destination value.

  *

  Clear Data--Use to define a subset of data that will be cleared from the database before a new value is added. You can choose to clear cells or to clear blocks of data.

  Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1, Adding a Create Blocks Actio

• Question 34:

  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?

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

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

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

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

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

  Correct Answer: A

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

  You need to create an allocation Business Rule that allocates marketing expense from corporate down to each region based on FY10 actuals for the Budget scenario.

  What is the correct formula assuming this syntax is used in an enhanced calc script?

  A. FIX (Budget, @LEVMBRS (Market,0)) "Marketing expense" = "Marketing expense "->Corporate * ("Marketing expense" Actual / "Marketing expense" -> Actual --> TotalMarket); ENDFIX

  B. FIX (Budget, (@LEVMBRS (Market, 0) ) ) "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing expense" --> TotalMarket) ; ENDFIX

  C. FIX (Budget, (@LEVMBRS (Market, 0) ) --- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense" Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX

  D. FIX (@LEVMBRS (Market, 0) ) "Marketing expense" = "Marketing expense"~>Corporate * ("Marketing expense" Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket); ENDFIX

  Correct Answer: B

• Question 36:

  You need to build the Entity into your Classic Planning application. You can dynamically build the Entity dimension in the Planning application via: (Select all that apply)

  A. Essbase load rules

  B. Oracle Data Integrator (ODI)

  C. Data Integration Management (DIM)

  D. Data Relationship Management (DRM)

  E. Outline Load Utility

  F. EPMA

  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.

• Question 37:

  What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?

  A. Essbase data block size decrease.

  B. The member is not available for process management.

  C. Retrieval performance could be slower when referencing the parent entity member.

  D. Data cannot be input to the parent in target versions.

  Correct Answer: AC

  Dynamic Calc members in a block storage outline that Essbase calculates only at retrieval time. Essbase discards calculated values after completing the retrieval request.

• Question 38:

  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.

  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

• Question 39:

  Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel?

  A. Open a data form and submit data.

  B. enter supporting detail and cell text.

  C. Run business rules.

  D. enter planning unit annotations.

  E. Perform workflow tasks.

  Correct Answer: ABC

  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.

• Question 40:

  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

  Correct Answer: A

  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.