Pass the Oracle Planning 1z0-533 Questions and answers with ExamsMirror

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

A: Open the Dimension Library and select File >

New > Dimension. Enter a name and description, then select the Alias type.

C: From planning 9 3 1 you can also create attribute hierarchy in planning.

E: Attribute dimensions have a type setting—text, numeric, Boolean, or date. Text is the default

setting.

A: If the user does not have the launch the Business Rules role, it could prevent the user from seeing the rule.

B: The Validate or launch Privilege enables a users or users you specify to validate and launch the business rule sequence

Incorrect answer:

C: The business rule has already been assigned to the Data Form.

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.

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:

Allocates data to all the source cell's descendants

Allocates across multiple dimensions

Spreads data even to cells not displayed on the data form

Does not require that you have access to the target cells

Cannot be undone after you mass allocate values

Is processed with dynamically-created calc scripts

Executes the calc scripts against the Essbase server, against all dimension combinations

Can use customized spreading patterns, created by an administrator (see the Oracle Hyperion Planning Administrator’s Online Help)

C, E: By assigning access to a data form, you control which users can change its design (for example,

its layout and instructions) and input data. Users can select only members to which they have

read or write access. Users can edit data forms only if they have access to at least one member

of each secured dimension. For example, if users have read-only access to the Europe entity, the

rows and columns on data forms that include the Europe entity are displayed as read-only. Users

can change data only for members to which they have write access.

D: For bottom-up versions, rows and columns with level 0 members allow data entry. Rows or

columns set to a parent member are read-only. The point of view must also be set to the level 0

member to allow data entry on a bottom-up version. Target versions allow data entry in parent

and children members.

If you assign children to bottom-up versions, these versions display as read-only parents on data forms.

Hyperion Planning Utilities can only be used locally.

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.

A: Business Rules can be assigned to data forms.

C: You can manage database locations, and the access privileges of repository objects that are

assigned to them, using the Location Editor. You can use the Location Editor to create, edit, and

copy database locations, assign new access privileges to locations, copy access privileges from

one location to another, and copy business rules from one location to another.

E: When you validate a business rule, Business Rules determines whether the member or members you select exist in the database and whether the syntax of the business rule is correct.

You need to have access privileges to all rules in the sequence before you can launch it.

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.