Hyperion Planning Expert Quiz

Hyperion Planning Quiz

Hyperion Planning Quiz : This Hyperion Planning Expert Quiz contains set of 100 Hyperion Planning Quiz which will help to clear any exam which is designed for Expert.



1) In EPM Architect Application Library, which step(s) is/are required to deploy application views?

  1. Validate Application Views
  2. Compare Application Views
  3. Deploy Application Views to Planning Server
  4. Install Application Views to Planning Server

 

  1. 1 & 2
  2. 1,2,4
  3. 2 & 3
  4. 1,2 & 3

Answer : D

 
 
2) You can load Planning data and metadata into the EPM Architect Dimension Library from:

  1. Interface tables
  2. Flat files
  3. Profiles
  4. A & B

Answer : D

 
 
3) What are the correct predefined types of base time periods that can be established when creating  the calendar in a planning application?

  1. Weekly, Monthly, Quarterly, Custom
  2. Monthly, Quarterly, Custom
  3. Monthly, Quarterly, Weekly
  4. Weekly, Monthly, Quarterly, Yearly, Custom

Answer : B

 
 
4) Identify the two statements about the Planning Import security utility.                                  A. Imports Planning application access for users and group

  1. Imports users and groups into Planning
  2. Requires the source text file to be named PLANSECFILE.txt
  3. Can be scheduled to run nightly using an encrypted password
  4. Clears existing security definitions by default before the import takes place

 

  1. A,B
  2. B,C
  3. A,D
  4. D,E

Answer : C

 
 
5) Identify the two true statements about a sparse Entity dimension In Hyperion Planning.

  1. You cannot build alternate rollups or assign custom attributes.
  2. Base currencies are assigned to entity members.
  3. Exchange rates are assigned to entity members.
  4. Entity along with Scenario and Period make up a planning unit.
  5. Entity along with Scenario and Version make up a planning unit.

 

  1. A,B
  2. B,C
  3. B,E
  4. D,E

Answer : C

 
 
6) In a non-multicurrency Planning application, what three things happen if all options are checked for
Refresh Database?

  1. Dimension and member changes are pushed toEssbase.
  2. Cell text and supporting detail changes are pushed toEssbase.
  3. Security filters for dimensions and members are pushed toEssbase.
  4. Security filters for shared members are pushed toEssbase.
  5. Data changes are pushed toEssbase.

 

  1. A,B,C
  2. B,C,D
  3. A,C,D
  4. A,D,E

Answer : C

 
 
7) You are designing a monthly projection Planning application. A starting point projection file Is
received with the current month data. Data forms. Business Rules, and Essbase data load rules, and
reports should always focus on the current projection month. What is most efficient way to design
the components to reduce maintenance each month?

  1. Manually update the forms each month and use a “CurMth” substitution variable for Business Rules, Essbase data load rules, and reports
  2. Manually update the forms each month; Use “CurMo” Global variable for Business Rules and use a “CurMth” substitution variable for Essbase data load rules, and reports.
  3. Use the Planning data form utility to update data forms and use a “CurMth” substitution variable for Business Rules, Essbase data load rules, and reports.
  4. Use a “CurMth” substitution variable for data forms, Business Rules, Essbase data load rules, and

Answer : D

 
 
8) The budget office analyst needs to enter and plan data, use the Planning spreading feature that
allow* users to spread budget data based on last year’s actuals, and modify data forms. What two
roles should be provisioned for this user?

  1. Grid Spread
  2. Planner
  3. Interactive User
  4. Mass Allocate
  5. Offline User

 

  1. A,B
  2. B,C
  3. C,D
  4. D,E

Answer : C

 
 
9) You are designing the storage properties for your Planning application. What two design principles
should you follow related to the dynamic calc storage property?

  1. Dynamically calculated members should roll up to stored members.
  2. You cannot calculate and store dynamic calculated members in calc scripts and business rules.
  3. Consider dynamic calc members on sparse parents with 100 children.
  4. Tagging upper-level members ofspaise dimensions can reduce block size.
  5. If you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.
  6. Consider Dynamic Calc and Store over Dynamic Calc.

 

  1. A,B
  2. B,C
  3. A,D
  4. B,E

Answer : D

 
 
10) Identify the two true statements with regard to Versions and Scenarios.

  1. Versions control data entry based on time periods set by the administrator.
  2. There is only one Version to one Scenario.
  3. Versions allow several “what-if” Scenarios.
  4. Users must have the same security settings in the Version dimension as they have in the Scenario dimension.
  5. Versions can be top down or bottom up.

 

  1. C,D
  2. B,C
  3. A,D
  4. C,E

Answer : D




 
11) Identify two times when a security refresh needs to be performed.

  1. Member access has been assigned to a group.
  2. Member access has been assigned to a user.
  3. New group is created.
  4. Member “East” has OHDESCENDANTSCREAD.access assigned; A new
  5. New business rule is created.

 

  1. A,D
  2. A,B
  3. A,D
  4. C,E

Answer : B

 
 
12) Identify two ways that Essbase data load rules cannot manipulate source data files.

  1. Select or reject records based on certain criteria.
  2. Flip the sign for records with a certain member tagged with a comment.
  3. Split or join columns in a source.
  4. Find and replace manipulations on source records.
  5. Map data based on an external table.

 

  1. A,D
  2. B,E
  3. A,D
  4. C,E

Answer : B

 
 
13) Identify the two true statements assuming you are working with a single application with multiple
plan types.

  1. A user-defined custom dimension may exist in one plan type but not the other plan types.
  2. A user-defined custom dimension may have members in one plan type but not the remaining plan types.
  3. All members in the entity dimension must exist in all plan types.
  4. All members in the accounts dimension must existIn all plan types.
  5. All periods must exist in all plan types.

 

  1. A,B
  2. B,C
  3. A,E
  4. D,E

Answer : C

 
 
14) Of the below list which are the three components can be changed after the creation of the Planning application?

  1. Number of years
  2. Names of plan types
  3. Number of plan types
  4. Initialization of WFP orCapEx Planning modules
  5. Weekly distribution spread
  6. Year Dimension Name
  7. Default Currency

 

  1. A,B,C
  2. C,D,E
  3. A,D,F
  4. E,A,B

Answer : C

 
 
15) You need to create a highly formatted, printable Income statement for each store in your company.
Each report should be emailed to the store manager at the close of each week (each store has a different store manager). What is the best way to deliver this solution?

  1. With Financial Reporting, create a book for each store that contains a P&L for each store and use the book to distribute the reports to store managers via email.
  2. With Financial Reporting, create a store P&L and use batch bursting to distribute the report to store managers via email.
  3. With Web Analysis,create an income statement that store managers can log in and access.
  4. Within Smart View Report Designer, use the Cascade feature to generate and distribute each store income statement via email.
  5. Create a Planning P&L Data form and use email notification to send to store managers.
  1. A,B,C
  2. C,D,E
  3. B,C,D
  4. E,A,B

Answer : A

 
 
16) What read or write security assignments allow end users to be able to view at least some data?

  1. At least one member in the Scenario dimension
  2. At least one member In the Version dimension
  3. At least one member in the Period dimension
  4. At least one member in the Account dimension
  5. At least one member in the Entity- dimension
  6. If security has been assigned for a Custom dimension, at least one member in the user-defined custom dimension
  1. A,B,C,D
  2. A,B,D,E,F
  3. E,F,A,B
  4. E,A,B,C

Answer : B

 
 
17)
Identify the three true statements about attribute dimensions in Planning.

  1. Aliases are supported for attribute members.
  2. Consolidation properties are supported for attribute members.
  3. Hierarchies are supported for attribute dimensions.
  4. Only Text attributes are supported.
  5. Text, Boolean, Numeric, and Date attributes are supported.

 

  1. A,B,C
  2. C,D,B
  3. C,E,A
  4. E,A,B

Answer : C

 
 
18) What four functions can Administrators use the Copy Data feature In Planning to do?

  1. Copy data values from one dimensional intersection to another dimensional intersection.
  2. Copy planning unit annotations.
  3. Copy supporting detail.
  4. Copy cell text.
  5. Copy account annotations.

 

  1. A,B,C,D
  2. C,D,E,A
  3. E,F,A,B
  4. E,A,B,C

Answer : B

 
 
19) In a planning application if you have a measure in your Accounts dimension for “Price”. Price Is Input by users (along with Units). Sales is calculated as Units * Price. Identify the two correct properties that should be assigned to  Price to meet this requirement.

  1. ~
  2. ^
  3. Stored
  4. Dynamic Calc
  5. Dynamic Calc and Store

 

  1. A,B
  2. B,C
  3. A,E
  4. A,C

Answer : D

 
 
20) Identity the true statement about Custom Menus.

  1. Custom menus can provide links to data forms.Business Rules, URLs, and Planning preferences.
  2. Custom menus require Java scripting knowledge to create.
  3. You can assign security to custom menus so that only specific users or groups can see the custom
  4. Custom menus are assigned to data forms only.

Answer : D




 
21) A planner is supposed to be able to submit data within a data form but in the data form all the possible causes for an end user not being able to enter data on a data form?
1-The planning unit is set to first pass.
2-Another user owns the planning unit.
3-The user has read access to the members on the data form.
4-The form contains summary-level members In a bottom up version.
5 The form is set to Read Only.

  1. 1, 4, 5
  2. 1, 2, 3
  3. 2,3,4,5
  4. 1,2,3,5

Answer : C

 
 
22) The Hyperion Planning administrator needs to run several calculations in a specific order against two different databases within the application. Identify the two options that are not valid.

  1. Esscmd
  2. Calc Script
  3. Business Rule Sequence
  4. MaxL
  5. Business Rule Macro

 

  1. A,B
  2. A,C
  3. B,E
  4. C,E

Answer : C

 
 
23) 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?

  1. You cannot build a data form with these two columns, hour columns will display: Actual >2010, Actual >2011, Budget->2010 and Budget >2011
  2. Create an Asymetric form with Multiple Columns
  3. Use User Variables on the data form to create the asymmetric columns.
  4. Use a composite data form to meet this requirement.

Answer : B

 
 
24) Identify the three true statements about weekly distribution.

  1. 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.
  2. The only valid weekly distribution options are 445, 454, and 544.
  3. 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, and the third month as if it has 4 weeks.
  4. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.
  5. Weekly distribution determines how data entered into summary periods should spread to its base periods.
  1. A,C,E
  2. B,C,D
  3. A,B,E
  4. A,D,E

Answer : A

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

  1. Planning Web Client
  2. EAS
  3. EPMA
  4. DRM
  5. Outline Load Utility

 

  1. A,B,C
  2. B,C,D
  3. A,C,E
  4. A,D,E

Answer : C

 
 
26) Identify the one Planning component that Is not accessible over the Web.

  1. Dimension Editor for Planning
  2. Shared Services
  3. Exchange Rates Definition
  4. Planning Utilities

Answer : D

 
 
27) Identify two true statements about the DATAFXPORT calc script command.
Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from anEssbase database.

  1. DATAEXPORT only exports level zero data.
  2. DATAEXPORT only exports to flat files.
  3. DATAEXPORT only exports entire data blocks.
  4. DATAEXPORT is faster thanEssbase Report.

 

  1. A,B
  2. B,C
  3. A,E
  4. D,E

Answer : C

 
 
28) Identify the three true statements about attribute dimensions.

  1. Planning supports hierarchies and aliases for attribute dimensions.
  2. Planning supports all attribute types (for example.Boolean, Date, Text).
  3. Planning supports varying attributes (where an attribute can vary over one or more other

dimensions).

  1. Attribute dimensions can be assigned to dense dimensions.
  2. Attribute dimensions may only be assigned to one base dimension.
  3. A,B,C
  4. B,C,D
  5. A,B,E
  6. A,D,E

Answer : C

 
 
29) You need to build the Entity into your Classic Planning application. You can dynamically build the
Entity dimension in the Planning application via:
1-Essbase load rules
2-Oracle Data Integrator (ODI)
3-Data Integration Management (DIM)
4-Data Relationship Management (DRM)
5-Outline Load Utility
6-EPMA

  1. 2, 3, 6
  2. 2, 3, 5
  3. 1,2,3,5
  4. 1, 2,3,4,5

Answer : C

 
 
30) 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?

  1. FIX (Budget, 0LEVMBRS (Market,0))
  2. “Marketing expense” = “Marketing expense “->Corporate * (“Marketing expense”
  3. Actual / “Marketing expense” -> Actual -> TotalMarket);
  4. ENDFIX

 

  1. FIX (Budget, (3LEVMBRS (Market, 0) ) )
  2. “Marketing expense” = “Marketing expense”->Corporate * (“Marketing
  3. expense”/”Marketing expense” -> TotalMarket) ;
  4. ENDFIX

 

  1. FIX (Budget, (3LEVMBRS (Market, 0) )
  2. — “Marketing expense” = “Marketing expense”->Corporate * (“Marketing expense
  3. Actual ->FY10 / “Marketing expense” -> Actual ->FY10 TotalMarket);
  4. ENDFIX

 

  1. FIX (OLEVMBRS (Market, 0) )
  2. “Marketing expense” = “Marketing expense”~>Corporate * (^Marketing expense
  3. Actual ->FY10 / “Marketing expense” -> Actual ->FY10 TotalMarlket);
  4. ENDFIX

Answer : C




 
31) 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?

  1. Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns
  2. Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV
  3. Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV
  4. Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns

Answer : A

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

  1. 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.
  2. 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.
  3. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block.
  4. 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 : B

 
 
33) Name the valid ways to create blocks in an underlying Essbase database.
A-Copy data
B-Load data
C-Create block on Equation
D-Aggregate data

  1. ABC
  2. BCD
  3. ACD
  4. ABCD

Answer : D

 
 
34) 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?

  1. Attribute dimension
  2. Varying attribute dimension
  3. Smart List
  4. Free Form Text

Answer : C

 
 
35) 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.

  1. You must delete members one by one.
  2. You must delete a reference to a member from all data forms before deleting it from the dimension.
  3. 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.
  4. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
  5. A database refresh is required after deleting members from the Entity dimension.
  1. A,B,C
  2. B,C,D
  3. D,B,E
  4. A,D,E

Answer : C

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

  1. You can only add custom attributes to user-defined custom dimensions.
  2. You assign valid plan types for the user-defined custom dimension at the dimension level.
  3. You assign data types for the user-defined custom dimension at the dimension level.
  4. You cannot: assign security for user-defined custom dimensions.

Answer : B

 
 
37) 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?

  1. Reduce the number of rows and columns displayed in the data form.
  2. Upgrade the client machine’s operating system processing speed and RAM.
  3. In the data form definition, remove the option to display alias.
  4. Reduce the number of page dimensions used on the Web form
  5. Tune the index and data caches inEssbase.

 

  1. A,B,C
  2. B,C,D
  3. A,B,E
  4. A,D,E

Answer : C

 
 
38) 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?

  1. Block size = 40 * 17 * 2
  2. Block size = 40 * 17 * 2 * 8
  3. Block size = 50 * 17 * 5 * 8
  4. Block size = 50 * 17 * 5

Answer : B

 
 
39) Identify the three differences between Grid Spreader and Mass Allocate.

  1. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
  2. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
  3. Both Mass Allocate and Grid Spreader require special roles in Shared Services.
  4. Grid Spreader gives users a “preview” to the spread result before saving whereas Mass Allocate will automatically save results to the server. Both Mass Allocate and Grid Spreader support relational spread.
  1. A,B,C
  2. B,C,D
  3. D,B,E
  4. A,D,B

Answer : D

 
 
40) The level of Fragmentation in an underlying Planning Essbase database will be high in which one of the following actions?

  1. Delete member from a sparse dimension.
  2. Delete member from a dense dimension.
  3. Renaming a member.
  4. Renaming an alias.

Answer : B




 
41) Identify the true statements regarding Supporting Detail.
1-Importing Supporting Detail from Excel is supported.
2-Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible
3-Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.
4-Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.
5-Supporting Detail is stored in Essbase.

  1. 1, 2,3,4,5
  2. 1,3,4,5
  3. 1, 4, 5
  4. 2, 3,1,5

Answer : A

 
 
42) 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 membero, 550 total members How many
potential blocks could be created?

  1. Potential Blocks = 40 * 17*2
  2. Potential Blocks = 40* 17*2*8
  3. Potential Blocks = 100 * 500
  4. Potential Blocks = 100 * 500 * 8

Answer : C

 
 
43) What option contributes to making an Business Rule more flexible than a native Essbase Calc
Script?

  1. Run on Save
  2. @CALCMODE function
  3. Run time prompts
  4. Can be run over the web

Answer : C

 
 
44) You are designing a new Planning application. Which requirements dictate multiple plan types in a single Planning application?

  1. Multiple currencies are required.
  2. Currency rates must be kept in a separate database.
  3. Sales are planned by product and channel, and salary expenses are planned by position.
  4. Security is applied to the Entity dimension but can differ for users for accounts “sales” and “expenses”.
  5. You have decided to implement the Capital Expense planning module in addition to PSL budgeting.

 

  1. A,C
  2. B,C
  3. A,D
  4. B,C,E

Answer : D

 
 
45) As a Planning end user, you need to add additional commentary to your plan, documenting  assumptions and other notes. What are the available options to add this information?

  1. Supporting detail
  2. Planning unit annotations.
  3. Cell Text
  4. Free form text (if defined by your Planning administrator)
  5. All of the Above

 

  1. A,b,c
  2. A,c,B
  3. A,C,D
  4. E

Answer : D

 
 
46) Identify the correct set of required dimensions for Planning.
1- Account
2- Entity
3-Version
4-Years and Periods combined into one dimension
5-Scenario
6- Minimum one user-defined dimension

  1. 1, 2,3,4,5
  2. 1,2,3,5
  3. 1, 2,3,5,6
  4. 1, 2, 3,4,5,6

Answer : B

 
 
47) Assuming you have a Period dimension with calendar months rolling to quarters to total years. If you
assign the property Time Balance Last to the “Headcount” account member, what will user see for
Q1?

  1. January’s value
  2. March’s value
  3. The total ofJanuary+February +March
  4. The average of January + February + March

Answer : B

 
 
48) Based on the following design:
Plan type 1: Summary Plan type with all Accounts by Entity
Plan type 2: Sales Plan type with Sales by Product by Entity
Plan type 3: Salary Plan type with Salary Expense by Employee by Entity
You need to get Sales data to the Summary plan type. Identify the two true statements about sharing revenue data between the sales plan type and the summary plan type.

  1. Planning will build in @XREF calculations in a calc script by default to share data between plan
  2. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type.
  3. A calc export script on the source database with the DATAEXPORT command could be used to export data out of the revenue plan type and calc import script on the target database with the DATAIMPORT command could be used to import the data file to the summ
  4. Both A & C

Answer : D

 
 
49) You need to calculate benefit expense in your Planning application using the following logic:
Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to
each cost center.
Given the following components, what is the correct order of calculation:
1-Custom calculation (Total Salary * Factor)
2-Aggregate benefits
3-Aggregate salaries

  1. 1, 2, 3
  2. 3, 2, 1
  3. 2, 3, 1
  4. 3, 1, 2

Answer : D

 
 
50) Assuming EAS Business rules, a user cannot see a business rule on a data Form. What are three possible causes?

  1. The business rule has not been assigned to the data form.
  2. The business rule was created for another plan type
  3. The valid locations have not been defined for the business rule.
  4. The valid locations have not been defined for the data form
  5. The Validate and Launch privileges have not been granted for the data form.

 

  1. A,B,C
  2. A,C,D
  3. A,B,E
  4. A,C,E

Answer : D




 
51) What are valid data types for the Accounts dimension?
1 -Currency
2-Non-currency
3-Percentage
4-Saved Assumption
5-Text
6- Smart List
7-Date

  1. 1, 2, 3, 4, 5, 6, 7
  2. 1, 2, 3, 5, 6, 7
  3. 1, 2, 3, 6
  4. 1, 2, 3, 4, 6, 7

Answer : B

 
 
52) A Planning Unit has a status of First Pass; what two user types can input data?

  1. Anyone with write access to the planning unit
  2. Anyone with write access to the planning application
  3. Anyone with read or write access to the planning unit
  4. The owner of the planning unit
  5. The administrator

 

  1. 1,2
  2. 3,4
  3. 1,3
  4. 1,4

Answer : D

 
 
53) 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?

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

 

  1. A,B
  2. A,C
  3. C,D
  4. B,C

Answer : B

 
 
54) We have a customer requirement to Build a Form, keeping a list of Entities in Rows (100 Entities from 500 total). What are the most Optimal ways to design the form ?

  1. Use Member selection and drag each member as per List and create form
  2. Tag UDA to list of 100 members & give reference to UDA values while defining Form rows
  3. Create an Alternate Hierarchy of Entities with 100 shared members as per the list. Reference Descandants of Alt Hier in the form
  4. Tag Attribute to list of 100 members & give reference to Attribute value while defining the Form rows

 

  1. A,B
  2. C,D
  3. A,D
  4. A,C

Answer : B

 
 
55) What all objects can be Exported via LCM for Hyperion Planning ?

  1. Forms, HBR
  2. Forms, HBR, Essbase objects, Planning Metadata, Data
  3. Forms, Essbase objects, Metadata of Planning, Security, Data
  4. Forms, Essbase objects, Metadata of Planning

Answer : C

 
 
56) While Using LCM for Importing Users/Group mapping, which Migration option should be chosen for appending users to an existing group. Multiple loads on same group should add to existing users and not keep the last loaded users only

  1. Update
  2. Create or Update
  3. Create
  4. Delete

Answer : C

 
 
57) You are designing a database with the following requirements:
– Calculate the complete history of product sales from product introduction to the present.
– Calculate 12-month rolling averages
– Present both calendar year and fiscal year hierarchies in reports.
Which time design will simplify your calculations and best enable the report presentation you
require?

  1. Fiscal year crossover time design
  2. Generic time design
  3. Scenario-based time design
  4. Manufacturing Time Design

Answer : A

 
 
58) Attribute dimensions can have an adverse effect on:

  1. Database size
  2. Data load performance
  3. Batch calculation performance
  4. Retrieval performance

Answer : D

 
 
59) In a database where both the Scenario and Customer dimensions are sparse, what is the effect
of the following calculation script? CLEARDATA “Current Year”->”O-IBM”;

  1. Data blocks with index entries containing both “Current Year” and “O-IBM” are removed from the database.
  2. Data is cleared from all the cells in data blocks with index entries containing both “Current Year” and “O-IBM”
  3. It is impossible to predict without knowing what other dimensions exist in the database
  4. It depends on FIX Statement and dimensions involved therein to answer this.

Answer : B

 
 
60) In order to optimise performance, what is the recommended value for Index Cache, if Index file size is 400 Mb

  1. 100Kb
  2. 500Mb
  3. 400Mb
  4. 100Mb

Answer : C




 
61) Which of the following spread type is not available in grid spread feature of Hyperion planning

  1. Fill
  2. Propotional Spread
  3. Evenly Split
  4. Relational Spread

Answer : D

 
 
62) What is the fundamental difference between Grid Spread and Mass Allocate

  1. Grid Spread is Client Side Feature
  2. Mass Allocate is Client Side Feature
  3. Grid Spread will always evenly split the data if no spread type is selected
  4. Mass Allocate will spread the data based on webform intersections only

Answer : A

 
 
63) What are the different mapping available when planning application is created with reporting application integration

  1. Dimension to Dimension
  2. Attribute Dimension to Smartlist
  3. Smartlist to Dimension
  4. Smartlist Source to Smartlist Target

 

  1. 1&2
  2. 2&3
  3. 1&4
  4. 3&4

Answer : C

 
 
64) What are unsupported features with Mapping Applications to Reporting Applications in Hyperion Planning

  1. Substitution Variables
  2. User Variables
  3. ASO Database with Duplicate Members Allowed as Unchecked
  4. Standard Dimensions of BSO Database

Answer : B

 
 
65) There is a form named Test_Old/Existing Employee #No. This form opens fine with Hyperion Planning Web Client but not by Smartview. Why ?

  1. Smartview doesn’t accept # as valid character
  2. There are spaces in form name. This is not acceptable while opening form via Smart View
  3. _ Should not be used in Form name.
  4. / Should not be used if you open form via Smart View. Planning Web client can read ‘/’ but not Smartview

Answer : D

 
 
66) Let’s take a scenario, as a last minute requirement your client needs cross tab reporting, your solution architect has decided to use Attributes instead of UDAs, as  repercussions you need to delete all the UDAs, change all the calcs etc. Select the best possible approach based on Oracle Best Practices

  1. Delete member by member from Planning Outline all the UDAs. Refresh the Outline
  2. Delete UDAS from Essbase Directly
  3. Go to relational database and do some unsupported background changes,
  4. Delete by using LCM

Answer : D

 
 
67) What are the actions that can be audited using Hyperion Planning Web Client

  1. Menus
  2. Smartlists
  3. Launch Business Rules
  4. Data Form Definition
  5. Security
  6. Data

 

  1. All Except 6
  2. 1,2,3, & 6
  3. 2,3,4, 5
  4. 1,2,4,5

Answer : C

 
 
68) Which tables holds the information regarding audit trail in Hyperion Planning

  1. HSP_OBJECTS_AUDIT
  2. HSP_AUDIT_DATA
  3. HSP_AUDIT_TRAIL
  4. HSP_AUDIT_RECORDS

Answer : D

 
 
69) What does the delegate option does to the Planning Unit during process management ?

  1. Passes the ownership back to the promoter
  2. Passes the ownership to administrator
  3. Passes the ownership to a user in Promotional Path
  4. Passes the ownership to a user not in Promotional Path

Answer : D

 
 
70) In Hyperion Planning, If your Technical Architect tells you to introduce one more process management state called as “Draft Review”, How would you achieve this

  1. You will say it is not possible to do in Hyperion Planning
  2. You will go to rename promote to review
  3. You will add entry to HSP_PM_STATES table to add new PM State.
  4. You will call this as customization and would suggest Java Scripting approach for the same

Answer : C




 
71) Which of the following are the types of local variables that Hyperion Planning provides ?

  1. Saved Assumption
  2. Use by Value
  3. Run time Prompt
  4. Saved Selection
  5. Use by Smartlist

 

  1. 1,2,3
  2. 2,4,5
  3. 2,3,4
  4. 1,3,5

Answer : C

 
 
72) For Data validation rules in Hyperion Planning, Operator available for Variance Reporting Type is

  1. Contains
  2. Is
  3. Equals
  4. Start With

Answer : B

 
 
73) What are the conditions supported by Rule Builder for Data Validation in Hyperion Planning

  1. Case Values
  2. IF Condition values
  3. Then Condition Values
  4. Range Condition Values
  5. Loop Condition Values

 

  1. 1,4,5
  2. 2,3,4
  3. 1,3,5
  4. 1,2,3

Answer : B

 
 
74) What is the order of evaluation and execution of Data validation rules assuming default priority levels and multiple rules exist in same same location.

  1. Cell Level Rules followed by Column Level Rules followed by Row Level Rules and finally Grid Level Rules
  2. Grid Level Rules followed by Row Level Rules followed by Column Level Rules and finally Cell Level Rules
  3. Grid Level Rules followed by Column Level Rules followed by Row Level Rules and finally Cell Level Rules
  4. Cell Level Rules followed by Grid Level Rules followed by Row Level Rules and finally Column Level Rules

Answer : A

 
 
75) For exporting Task List there is a utility called as TaskListDefUtil.cmd (Assuming Windows Environment). What is the utility for importing the task list ?

  1. cmd
  2. cmd
  3. cmd
  4. cmd

Answer : D

 
 
76) Using Copy Data feature in Hyperion Planning, What cannot be copied ?

  1. Planning Unit Annotations
  2. Account Annotations
  3. Supporting Details
  4. Cell Text

Answer : A

 
 
77) For Copy Data to be successful, atleast one member must be selected for the dimensions except

  1. Scenario
  2. Period
  3. Year
  4. Version

Answer : C

 
 
78) Which Item type in Menu will allow you to open a pdf document from Workspace ?

  1. Menu Header
  2. Form
  3. URL
  4. Manage Approvals

Answer : C

 
 
79) For Currency Conversion in Hyperion Planning, What is the difference between HspCrtB.csc and HspCrtT.csc ?

  1. They are exactly the same. No difference at all
  2. They are Scenario dependent scripts
  3. csc does block creation at the beginning of the script, while HspCrtT.csc doesn’t require block creation
  4. They are differentiated by Versions

Answer : D

 
 
80) Prinicipal benefit of using Calculation Manager Vs. Hyperion Planning

  1. It provides GUI for quick development of Business Rules
  2. It is newly enhanced version of Business Rules and Provides facility for Rulesets
  3. Calculation Manager provides single interface to only administer rules and rulesets across planning and HFM applications
  4. Calculation Manager allows for creation and administration of rules for Essbase BSO, ASO, Planning and HFM Applications

Answer : D




 
81) If Budget data is entered at the leaf level of the organization, and ownership starts at the top level of the organization, it is called as ?

  1. Bottom Up budgeting
  2. Distributed Budgeting
  3. Free Form Budgeting
  4. Closed Loop Budgeting

Answer : B

 
 
82) What is the primary function of the feature Grid Diagnostics in Hyperion Planning ?

  1. It Diagnoses grid to verify any errors on the web forms
  2. It runs a utility in backend to determine the look and feel of the web forms for ad-hoc analysis
  3. It allows to view the time taken to open ad-hoc grids and web forms
  4. It allows to view who opened the webform and when in a tabular format

Answer : C

 
 
83) What does the Hyperion Planning DIRECT_DATA_LOAD Property does ?

  1. It loads metadata to planning and data to Essbase
  2. It loads directly data to Hyperion Planning. Upon Refresh, the same is reflected to Essbase
  3. It loads the data directly to Essbase
  4. This property is set to false by default, but when sets to true will load data to Essbase

Answer : C

 
 
84) Outline Load utility data import does not import #missing values. To ensure the correct Essbase
cells will contain #missing values, clear the block (which sets all cells in the block to #missing)
to be loaded with the /XYZ command on all data imports. What is XYZ here ?

  1. ICB
  2. IRA
  3. RIQ
  4. SDM

Answer : A

 
 
85) How can custom spread pattern be incorporated in Hyperion Planning ?

  1. By modifying entry in table HSP_GRID_SPREAD
  2. By modifying entry in table HSP_GRID_PATTERN
  3. By modifying entry in table HSP_MASSALLOCATE
  4. By modifying entry in table HSP_SPREAD_PATTERN

Answer : D

 
 
86) Which among the following are valid approval roles in Hyperion Planning

  1. Approvals Administrator
  2. Approvals Ownership Assigner
  3. Approvals Process Designer
  4. Approvals Budget Administrator
  5. Approvals Manager
  6. Approvals Supervisor

 

  1. 1,2,3,5
  2. 1,2,3,4
  3. 1,2,3,6
  4. 2,3,5,6

Answer : C

 
 
87) Which Dimension is the primary dimension while creating Planning Unit Hierarchies

  1. Scenario
  2. Version
  3. Entity
  4. Accounts

Answer : C

 
 
88) What are the different possible labels for the Synchronized column in Planning Unit Hierarchy ?

  1. Synchronized
  2. Not Synchronized
  3. Dependents Unsynchronized
  4. Locked By User
  5. Dependents Not Synchronized

 

  1. 1,2,3
  2. 1,2,3,5
  3. 1,2,4,5
  4. 1,2,5

Answer : C

 
 
89) When you receive Error 500 after opening Planning data form, What should be possible options to remove this error ?

  1. Oracle recommends reducing the number of cross-product dimension combinations on the page as much as possible.
  1. By default, Java is allocated 128 MB of memory, but if your server has more memory available, you should increase the amount that Java can use.
  1. As a general rule, if the server is dedicated to Planning, allocate 75% of the server’s RAM to Java; if the server is not dedicated, allocate 25% to 50% of the RAM to Java. The minimum memory setting should be 128 MB.
  1. As a general rule, if the server is dedicated to Planning, allocate 50% of the server’s RAM to Java; if the server is not dedicated, allocate 25% to 40% of the RAM to Java. The minimum memory setting should be 256 MB.
  1. 1,2,3
  2. 2,3,4
  3. 1,3,4
  4. 1 & 2 only

Answer : A

 
 
90) In order to improve performance, default memory allocation for supporting detail cache can be increased. Which property in Hyperion Planning would need to change for the same ?

  1. SUPPORTING_DETAIL_CACHE
  2. SUPPORTING_DETAIL_CACHE_SIZE
  3. SUPPORTINGDETAIL_CACHE_SIZE_ULIMIT
  4. SUPPORTINGDETAIL_CACHE_SIZE_LLIMIT

Answer : B




 
91) What does analytic services write access mean in context of Hyperion Planning ?

  1. It allows user to write back to hyperion planning application only
  2. It allows user to modify data in Essbase directly without going via Planning web client
  3. It allows user to modify data in Essbase directly without going via Hyperion Smart View
  4. Enables users having write access to change Planning data directly in Essbase using another product such as Financial Reporting or a third-party tool.

Answer : D

 
 
92) Which Utility helps to bring Planning application in maintenance mode ?

  1. cmd
  2. cmd
  3. cmd
  4. cmd

Answer : A

 
 
93) If the Planning application has Smart List to dimension mappings, then default members
should be

  1. Any Level Members
  2. Level 1 And Above
  3. Level0
  4. Generation 1

Answer : C

 
 
94) Mathematical functions in data validation accept which of the following argument types

  1. String
  2. Numeric
  3. Boolean
  4. Property
  5. Row Reference
  6. Embedded Functions

 

  1. 1,2,3
  2. 3,4,5,6
  3. 1,4,5,6
  4. 2,4,5,6

Answer : D

 
 
95) If a grid has 4 rows with the values 10, 20, 30, and, #ERROR. What does AverageA([1:4]) returns in 5th row

  1. 20
  2. 15
  3. Results in Error
  4. There is no such function as AverageA

Answer : B

 
 
96) Rolling Forecast set up feature of Hyperion planning requires following parameters to set up a rolling ofrecast form

  1. End Year
  2. End Period
  3. Start Period
  4. Start Year
  5. Number of Periods
  6. Prefix
  7. Suffix
  8. Resuse exisiting Subvars

 

  1. 1,4,5,7
  2. 2,3,5,6,8
  3. 1,2,3,4,7,8
  4. 3,4,5,6,8

Answer : D

 
 
97) To enable users to work in more than one form at one time, you can update the
_________ property, which specifies the number of data grids cached per user
for an application.

  1. DATA_GRID_CACHE_SIZE
  2. DATA_GRID_BUFFER_SIZE
  3. DATA_GRID_SIZE
  4. DATA_FORM_CACHE_SIZE

Answer : A

 
 
98) What is the difference between the following two grid properties while designing planning form

  1. Suppress Missing Data
  2. Suppress Missing Blocks

 

  1. They both are same
  2. Both cannot be used at same time. It degrades the performance
  3. Suppress missing block can improve the performance of Suppress missing data setting.
  4. Supress missing data setting improves the performance of Suppress missing block setting

Answer : C

 
 
99) Use __________ for custom behaviour when focus comes into a cell, after the default
Planning logic runs.

  1. customCellEnterPost
  2. customCellEnterPre
  3. customCellValidatePre
  4. customCellValidatePost

Answer : A

 
 
100) Utility functions are included in

  1. js
  2. js
  3. js
  4. js

Answer : A