Oracle Oracle Certifications 1Z0-533 Questions & Answers

• Question 21:

  What are two user interfaces to Planning data forms?

  A. EPM Workspace

  B. Excel Add-in

  C. Smart View Essbase Provider

  D. Smart View Planning Provider

  E. Planning ADM Driver for FR

  Correct Answer: AD

  Planning data forms can be accessed from within the EPM Workspace and from Smart View Planning Provider.

  Note: Smart View provides a common Microsoft Office interface for Oracle Essbase, Oracle Hyperion Financial Management, Fusion Edition, Oracle Hyperion Planning, Fusion Edition, Oracle Enterprise Performance Management Workspace, Fusion Edition, Oracle Business Intelligence Enterprise Edition, and Oracle's Hyperion?Enterprise?data. Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint interfaces.

• Question 22:

  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.

  Correct Answer: ABD

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

  Planning administrators can access which four administration tools via the EPM Workspace?

  A. Planning

  B. EPMA

  C. ODI

  D. LCM

  E. Calculation Manager

  F. EAS

  G. FR Studio

  Correct Answer: ABDE

  A: Planning is available within Oracle Enterprise Performance Management Workspace

  B: Oracle Enterprise Performance Management Architect (EPMA) is accessible from the EPM Workspace.

  D: The Shared Services Web application and the LCM utility communicate over TCP/IP to the EPM Workspace Core Service.

  Note: One of the smartest tools Oracle/Hyperion ever integrated into its product suite was the migration utility. Overtime this has evolved to the LifeCycle Managment utility or LCM for short. Actually Oracle/Hyperion has taken it even one step

  further by calling its fully integrated migration tool the BI+ Artifact LifeCycle Management utility even though they have retained the same acronym, LCM.

  E: Calculation Manager was introduced in EPM workspace common Foundation Services in release 11.

  Single interface for both Hyperion

  Planning and Financial Management

  Graphical flow provides better understanding of calculation process

  Re-usable rules to share among applications

• Question 24:

  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

  What is the block size in bytes?

  A. Block size = 40 * 17 * 2

  B. Block size = 40 * 17 * 2 * 8

  C. Block size = 50 * 17 * 5 * 8

  D. Block size = 50 * 17 * 5

  E. Block size = 100 * 500 * 8

  F. Block size = 100 * 500

  Correct Answer: B

  We need to multiple the stored (not the total) members of the dense dimensions (here Measures: 40, Time:17, and Dense:2) with 8 to calculate the block size.

  Note: Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions. Note: Optimal range is 8 to 100 kb

• Question 25:

  When opening a data form, the user experiences slow performance.

  What three steps could you do to improve the time it takes to open the data form?

  A. Reduce the number of rows and columns displayed in the data form.

  B. Upgrade the client machine's operating system processing speed and RAM.

  C. In the data form definition, remove the option to display alias.

  D. Reduce the number of page dimensions used on the Web form

  E. Tune the index and data caches in Essbase.

  Correct Answer: ABE

  A: Reducing the amount of rows and columns that need to be accessed would increase performance.

  B: The client machine could also be a bottleneck.

  E: Indexing and caching would help when loading data into a form.

• Question 26:

  What differentiates a user-defined custom dimension from the Entity and Account dimensions?

  A. You can only add custom attributes to user-defined custom dimensions.

  B. You assign valid plan types for the user-defined custom dimension at the dimension level.

  C. You assign data types for the user-defined custom dimension at the dimension level.

  D. You cannot: assign security for user-defined custom dimensions.

  E. You can easily delete a user-defined custom dimension in Planning but you cannot delete an Entity dimension.

  Correct Answer: B

  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.

• Question 27:

  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?

  A. Attribute dimension

  B. Varying attribute dimension

  C. Smart List

  D. Free Form Text

  E. Alternate hierarchy

  Correct Answer: C

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

  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.

  A. You must delete members one by one.

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

  C. 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 "IT" in this data form.

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

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

  Correct Answer: BDE

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

  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?

  A. Attribute dimension

  B. Varying attribute dimension

  C. Smart List

  D. Free Form Text

  E. Alternate hierarchy

  Correct Answer: C

  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.

• Question 30:

  Name the valid ways to create blocks in an underlying Essbase database. Select all that apply

  A. Copy data

  B. Load data

  C. Create block on Equation D. Aggregate data

  Correct Answer: ABC

  Ways to create data blocks:

  1.

  Data Load, (B)

  2.

  DataCopy Command, (A)

  3.

  Sparse Dimension Consolidation,

  4.

  Member Formulas:

  4a. Assiging a constant value to a sparse member,

  4b. Turning Create Block on Equation setting on and assiging a non constant value (C)

  4c. Create non missing blocks

  B: The moment we load data to essbase, It creates block for those combinations automatically.

  C: Controls, within a calculation script, whether or not new blocks are created when a calculation formula assigns anything other than a constant to a member of a sparse dimension. SET

  CREATEBLOCKONEQ overrides the Create Block on Equation setting for the database.

  If calculations result in a value for a sparse dimension member for which no block exists, Analytic Services creates a new block. Sometimes, the new blocks are not desired; for example, when they contain no other values. In large databases,

  creation and processing of unneeded blocks can increase processing time as well as the storage requirement for a database.

  For the situation when new blocks would be created as a result of assigning something other than a constant to a member of a sparse dimension, Analytic Services provides the Create Blocks on Equation setting. For example, when the

  Create Blocks on Equation setting is ON and West is assigned a value where it did not have a value before, new blocks are created. When this setting is OFF, new blocks are not created.

  Incorrect answer:

  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.

  D: Aggregate data. There is no such specific command or utility. It is just a general concept in the Hyperion context.