1Z0-533 Online Practice Questions and Answers

Correct Answer: BE

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

Note:

Essbase maximizes performance by dividing the Essbase - Standard dimensions of an application into two types:

dense dimensions

sparse dimensions.

Sparse and dense are a property of the values of an attribute.

Sparse

Data is normally stored in sparse form. If no value exists for a given combination of dimension values, no row exists in the fact table. For example, if not every product is sold in every market. In this case, Market and Product are sparse

dimensions.

It's why in the reporting tool Obiee for instance, by default, data are considered sparse.

Dense

Most multidimensional databases may also contain dense dimensions. A fact table is considered to have dense data if it has (of a high probability to have) one row for every combination of its associated dimension levels.

Correct Answer: CD

C: You use the Scenario and Version dimensions to create individual plans to be reviewed and approved. Each scenario/version combination contains its own set of data for the accounts and other dimensions of each entity. After users complete data entry for an entity for a specific scenario and version, they can submit or promote the data for the entity to another user for review and approval. The intersection of entity, scenario, and version is referred to as a planning unit. Planning tracks the status of each planning unit as it moves through the review process.

D: Seems likely.

Correct Answer: ABDE

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

Aggregate

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

Note:

*

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 then 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 either to clear cells or to clear blocks of data.

*

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

Reference: Hyperion Business Rules, Administrative Guide, About Adding Actions to Graphical Business Rules

Correct Answer: B

To set up the calendar:

1.In the Classic Application Wizard, click Calendar.

2 Select a Base Period option to set how calendars roll up:

*12 Months: Four quarters per year; months roll up into parent quarters and quarters into years.

*Quarters: Quarters roll up into years.

* Custom: A custom time period, such as weeks or days. Etc.

Note: The calendar establishes the application's base time periods, starting fiscal year and month, and total number of years. Select the base time period and monthly distribution pattern based on the number of fiscal weeks in a month. The base time period options are the bottom-level time periods in the application. You can create a custom base time period, such as weeks or days. Use monthly distribution patterns to determine how data entered into a summary time period is distributed or spread among the base time period you select. During data entry, users can enter data into summary time periods, such as years or quarters. Planning distributes these values over the base time periods that constitute the summary time period.

Reference: Oracle Hyperion Planning, Fusion Edition, Setting up the Calendar

Correct Answer: ACDE

Administrators can use Copy Data to copy plans from one dimensional intersection to another (A), including relational data and supporting detail (C).

You can copy account annotations (E), supporting detail, and cell text (D). You cannot copy planning unit annotations.

Reference: Oracle Hyperion Planning, Fusion Edition, Copying Data

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.

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.

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.

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.

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.

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.

Correct Answer: C

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

Correct Answer: BC

B: Replicated Partition:

A portion of a database, defined through Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.

C:

Transparent partition:

A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made

to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users

Note: @XREF

Enables a database calculation to incorporate values from another Essbase database.

The following terminology is used to describe the @XREF function:

Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).

Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).

Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).

The @XREF function retrieves values from a data source to be used in a calculation on a data target. @XREF does not impose member and dimension mapping restrictions, which means that the data source and data target outlines can be

different.

Note #2:

Hyperion planning's Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan types in Hyperion Planning or equivalent databases in underlying

Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to

multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

Correct Answer: ABCEFG

Data types:

How values are stored and displayed:

*Currency (A)

*Non-Currency (B)

*Percentage (C)

*Smart List (F)

*Date (G)

*Text (E)

*Unspecified

F

or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate Type to None.

Note:

The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.All members in the accounts dimension inherit the accounts property. You can create an outline that does not have an accounts dimension.

Correct Answer: CD

C: Access cannot be assigned directly to a shared member. You assign access rights to shared members in one of two ways:

*

From the security assigned directly to the base member

*

From the security assigned at the parent or ancestor of the shared member

D: You can create multiple shared members for the base member. A base member must exist before you can create a shared member, but there is no limit to the number of shared members you can create for the base member.

E: Shared members are available for Entity, Account, and user-defined custom dimensions. " Shared members contain read-only values and are only available in the Entity dimension. "