Oracle Hyperion Planning 11 Essentials

Question - 22 Maximum mark : - 43

Home
All Exams
Oracle Hyperion Planning 11 Essentials Online Mock Tests
Oracle Hyperion Planning 11 Essentials

Assuming the following dimensions and members: Scenario - Actual, Budget and Year - 2010, 2011, you need to create a data form with two columns. One column should list Actual for 2010 and the second column should list Budget 2011. You do not want to show data for Actual 2011 even though the first three months of the year have been loaded from the GL. What is the best way to only show the 2 columns in the data form?

You cannot build a data form with these two columns, hour columns will display: Actual >2010, Actual >2011, Budget->2010 and Budget >2011 ✘ Use Segments on the data form to create the asymmetric columns. ✘ Use User Variables on the data form to create the asymmetric columns. ✘ Use a composite data form to meet this requirement. ✔ Use data suppression on the data form. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Identify the three true statements about weekly distribution.

For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify. The only valid weekly distribution options are 445, 454, and 544. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, andthe third month as if it has 4 weeks. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods. Weekly distribution determines how data entered into summary periods should spread to its base periods.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What are the three supported methods to create and update a member and its properties (assuming Classic or non-Classic Planning applications)?

Planning Web Client EAS EPMA DRM Outline Load Utility

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Identify the one Planning component that is not accessible over the Web.

Dimension Editor for Planning ✘ Shared Services ✘ Exchange Rates Definition ✘ Planning Utilities ✔ Create and Manage Database Options ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Identify two true statements about the DATAEXPORT calc script command.

Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database. DATAEXPORT only exports level zero data. DATAEXPORT only exports to flat files. DATAEXPORT only exports entire data blocks. DATAEXPORT is faster than Essbase Report.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

Essbase data block size decrease. The member is not available for process management. Retrieval performance could be slower when referencing the parent entity member. Data cannot be input to the parent in target versions.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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)

EPMA Oracle Data Integrator (ODI) Data Integration Management (DIM) Data Relationship Management (DPM) Outline Load Utility

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

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

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns ✘ Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV ✘ Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV ✘ Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns ✔ The layout of sparse and dense dimensions has no impact on form performance; only the number cells on a data form impacts form performance. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

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

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. ✘ 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. ✘ Data may not exist for the combination of dense members so you have to create the block before block loading data to the block. ✘ Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle Hyperion Planning 11 Essentials

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner