1z0-533 Sample Questions Answers

A: If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern.

E:

Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks

in a month. This determines how data in summary time periods spreads within the base time

period. When users enter data into summary time periods, such as quarters, the value is

distributed over base time periods in the summary time period.

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.

Where needed in the calculation script, you can use multiple SET CREATEBLOCKONEQ commands to define the Create Blocks on Equation setting value for the calculations that follow each command.

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.

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.

You can change the status of the Employee through options from a Drop down/Smart List on a data form by running a Business Rule.

Incorrect answer:

Deleting the employee is a bad praxis. It would remove old salary entries.

You do not access the attributes directly on the Employee dimension.

Note: The Workforce Planning Module for Hyperion Planning provides a robust set of calculations and pre-defined web-forms that allows organizations to track and budget down to the benefit-level for each employee.

B:

"If you specify a Dynamic Calc or Dynamic Calc and Store member explicitly in a calculation script, the calculation script fails. You cannot do a calculation script calculation of a Dynamic Calc or Dynamic Calc and Store member. To use a calculation script to calculate a member explicitly, do not tag the member as Dynamic Calc.

E: The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a query).

Incorrect answer:

F: Storing the information is no advantage in this scenario.

First calculate the aggregated saleries.

Then make the custom calculation on the saleries.

Finally use the result of the custom calculation to product the benefits.

Not C: Business Rules are a powerful to automate complex calculations.

However, arule typically runs a specific calculation/allocation on a single Essbase Database.

E: Macros are used to avoid duplicating code.

Incorrect:

not A:ESSCMD is the original command line interface for administration commands.

Not B: Cacl scripts is a powerful to automate calculations.

Not D:MaxL, a "multi-dimensional database access language" which provides both a superset of ESSCMD commands, but with a syntax more akin to SQL, as well as support for MDX queries.

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.

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.

Incorrect answer:

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

A: To develop a calculation script that exports a subset of data, you first specify the SET

DATAEXPORTOPTIONS command to define options for export content, format, and process Use FIX…ENDFIX or EXCLUDE…ENDEXCLUDE calculations to select a slice of the database and use a DATAEXPORTCOND command to select data based on data values.

Note: The DATAEXPORT command enables calculation scripts to export data in binary or text, or directly to a relational database. A set of data-export-related calculation commands qualify what

data to export and provide various output and formatting options.

Compared to using other methods to export data, using a calculation script has the following

advantages and disadvantages:

Advantages:

Enables exporting a subset of data.

* Supports multiple targets: flat files, relational databases, and binary files (not B, C, D)

* Provides many flexible options for type and format or data.

* As part of a calculation script, can be easily deployed in a batch process.

* Can be very fast when the dynamic calculation export option is not used because DATAEXPORT directly accesses Kernel storage blocks in memory. (E)

* Provides, through binary export-import, a faster way to back up and restore data because the

compressed format used by binary export requires less storage for the export files.

* Can be used as a debug tool to trace batch calculation results by using the DATAEXPORT

command before and after other calculation commands to track data changes.

Disadvantages

Contains limited data formatting options compared to Report Writer formatting.

In Business Rules use a global variable.

In Essbase, use a substitution variable.

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.

Incorrect:

not E: Supporting details are stored in Planning Applications RDBMS not in Essbase.

You candynamically build the Entity dimension in the Planning applicationwith the help ofODI, DIM and EPMA.

With Version 11(and later)you can also use the outline loader.

Incorrect:

not A:you can't use essbase load rules, metadata has to be loaded to planning and then pushed to essbase.

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.