Hyperion Planning Beginner Quiz
Hyperion Planning Quiz
Hyperion Planning Quiz : This Hyperion Planning Beginner Quiz contains set of 100 Hyperion Planning Quiz which will help to clear any exam which is designed for Beginner.
1) What are the requirements for creating data forms?
- Member formulas
- Data form properties
- Access rights,Row and column layout,POV definitions,Display options
- B & C
2) Which statement(s) is/are true about task list navigation?
- Basic mode provides you with a wizard to guide you through task list steps.
- Advanced mode enables you to work with task lists and Planning functions that you have access to simultaneously.
- (None of the above)
- All of the above
3) Planning units consist of:
- version, entity, scenario
- scenario, entity, accounts
- entity, version, time periods
- Accounts,time period,year
4) In member selection, the______ function retrieves members at ALL LEVELS BELOW a specified parent.
- Ancestors
- BottomOfHierarchy
- Children
- Descendants
5) After assigning data access rights to data forms, task lists, and process management, you must:
- Run the CalcAll business rule
- Refresh the Analytic Services database
- Refresh Planning Filters
- (None of the above)
6) Which data-entry tasks can you perform in Planning data forms?
- Launch business rules to perform predefined calculations on data that you enter
- Spread data from summary to base periods automatically,Export data to a spreadsheet
- Annotate planning units, accounts, or cells,Type data directly into cells on a data-entry form,Adjust existing data and add supporting details
- All of the above
7) You assign access to dimension members with the following:
- ImportSecurity utility
- Form Management
- EPM Architect Dimension editor
- Shared Services
8) Which statement is true regarding row and column templates?
- Can modify cell text
- Can automatically save changes by saving the report
- Can use inherit formatting
- Can modify formulas
9) Which Planning data form tasks can you perform with Smart View?
- View form instructions,Adjust data
- Manipulate data with ad hoc adjustments,Lock and spread values to base periods
- Enter supporting detail and cell text,Launch business rules
- All of the above
10) How many user variables can you set up for each dimension?
- 5
- 3
- Unlimited
- 10
11) Which process state signifies that a planning unit has been rejected?
- Approved
- Under Review
- Signed Off
- Not Signed Off
12) When you are logged into a Microsoft Office application, you can import reports and snapshots from Workspace through what integration?
- Smart View
- Smart List
- Integration Manager
- Macro
13) In an EAS outline, a Generation: (Choose the Correct ones)
- Describes a member’s location within an outline hierarchy.
- Does NOT have child members.
- Is counted from the top of the dimension down through its descendants.
- A & C
14) Which dimension stores exchange rates for multicurrency applications?
- HSP_Rates
- HSP_Currency
- HSP_Conversion
15) To which application elements can you assign access rights?
- Data forms,Task lists
- Account, Entity, Scenario, and Version dimensions
- User-defined dimension members, if the Apply Security dimension property is selected
- All of the above
16) Which types of tasks can you define in a task list?
- Smart List
- Grant Security
- URL,Data form,Business rule
- None of the above
17) Planning uses which account types?
- Revenue, Expense
- Saved Assumption,Asset, Liability
- equity
- All of the above
18) In Planning, what menu enables you to create, edit, move, delete, and assign access data forms?
- Edit menu
- File menu
- Administration menu
- Tools menu
19) What time balance options can be used with Asset, Liability, and Equity account types?
- Balance
- First
- Average,Weighted Average-Actual_Actual,Weighted Average-Actual_365
- All of the above
20) Planning provides which tools for selecting tasks and documents?
- Planning menus
- Planning toolbar
- View pane
- All of the above
21) How many customizable plan types can you define in a Planning application?
- 2
- 3
- 5
- 4
22) In Workspace, where do you set the current Planning application as the default application?
- View > Settings
- File > Preferences
- Administer > Settings
- Edit > Properties
23) In order to assign access to custom dimension members, you must apply security at what level?
- Dimension
- User
- Parent
- Type
24) Which statements are true when creating folder structures for data forms?
- You cannot delete a folder unless it is empty
- You can rename folders
- You can move folders within the hierarchy
- All of the above
25) Planning stores the application definition in:
- Shared Services
- Analytic Administration Services
- Relational Databases
- Planning Servers
26) Which process state signifies that a planning unit is being reviewed by someone in the organization?
- Under Review
- First Pass
- Signed Off
- Approved
27) When creating a multi-currency application, which dimensions are automatically created in Essbase.
- Currencies
- HSP_Rates
- HSP_InputValue
- A & B
28) When you convert currencies in a webform, converted values are :
- Editable
- Read-Only
- Editable to administrators only
29) How many currencies can you select per Entity member?
- 1
- A maximum of 8
- As many as you like
- You can only select the currency at dimension level
30) The HSP_RATES Dimension includes the following members :
- HSP_Currencies
- HSP_InputValue, HSP_Rate_XXX (where XXX is a currency, i.e USD)
- HSP_InputCurrency
- B & C
31) What exchange rate types are available in for the Accounts Dimension?
- None
- Average, Historical
- Ending
- All of the above
32) What are the 2 copy calc scripts called?
- CurrCalc
- HspCRtB
- HspCRtT
- B & C
33) The copy calc scripts copy exchange rates from top level dimension members to Level0 members:
- Lev 0 members
- Top Level Members
- All Level members
- None of the above
34) When creating a single currency application, which dimensions are automatically created?
- HSP_ Rates, Accounts, Scenarios, Time Periods, Entities,Versions, Years
- Accounts, Scenarios, Time Periods, Entities,Versions, Years
- Currencies, Accounts, Scenarios, Time Periods,Entities,Versions, Years
- Entities,Versions, Years,Entities,Versions, Years, Hsp_rates
35) Which statements are correct?
- Target versions let you enter data for members at any level in the hierarchy
- Bottom-Up versions let you enter data for members at any level in the hierarchy
- Bottom-Up versions only allow for data entry at Level0
- A & C
36) Which statement is correct?
- Bottom-Up versions only can be enabled for Process Management (Workflow)
- Target versions only can be enabled for Process Management
- Bottom-Up versions as well as Target version can be enabled for Process Management
37) Which statement is correct about copying versions?
- You cannot copy account annotations or supporting details
- You can only copy account annotations
- You can only copy supporting Details
- You can copy account annotations as well as supporting details
38) Which statements are correct about user-defined custom dimensions?
- You assign valid plan types at dimension level only and not at member level
- You can create up to 14 user-defined custom dimensions for single currency application
- The name for a user-defined custom dimension can be up to 80 characters
- All of the above
39) Which statements are true about using Dynamic Calc and Store?
- The data value is calculated and stored upon retrieval
- Using Dynamic Calc and Store increase retrieval and calculation times
- Dynamic Calc and Store should be used when calculating members of a dense dimension
- All of the above
40) How many aliases can be assigned per dimension member in Planning?
- 1
- 3
- 10
- 32
41) In order to be visible in Planning web, Alias tables should be created in:
- Essbase
- Planning
- the relational database
- EAS
42) Which are correct account types from the list below?
- Expense, Revenue, Asset, Liability, Equity, Saved Assumption
- Flow, First, Balance, Average
- Expense, Non-Expense
- None, Average, Ending, Historical
43) Attributes can be assigned to:
- Dense dimensions only
- Sparse dimensions only
- Both dense and sparse dimensions
44) For which dimensions are shared members available?
- Accounts
- User-Defined dimensions
- Entities
- All of the above
45) Where are Planning Units stored?
- In Essbase
- In the relational database
- Planning Units are not stored
- None of the above
46) Which statements are true regarding Process Management:
- When you promote or reject a parent, its children are automatically promoted or rejected, unless they are in Approved state
- When you approve a parent, its children are automatically approved
- After all of the children of a parent are signed-off, the parent status automatically changes to Signed-Off
- All of the above
47) What happens if an Administrator puts a Planning Unit back to Not Started?
- All process management workflow history and annotations are saved in the relational database
- All process management workflow history and annotations are automatically deleted
- The Administrator is prompted whether he would like to save all process management workflow history and annotations
- None of the above
48) Hyperion Essbase is a:
- Relational database where the Planning data is stored
- Multidemensional database where the Planning data is stored
- Unidimensional database where the Planning data is stored
- None of the above
49) Hyperion Essbase Administration Services (EAS) is: (select correct options)
- An interface that provides a single point of access console to multiple analytic servers
- A repository which stores users created in Planning
- An interface that allows for the design, development, maintenance and management of applications and databases
- A & C
50) Which Statements are true about dimensions? (select correct options)
- Dimensions are the structural elements of an application that describe and hold data
- Examples of dimensions are Accounts, Entities and Time Periods, Dimension members are arranged in hierarchies
- The elements that make up a dimension are called dimension members
- All of the above
51) Which statements are true about dimensions:
- A sparse dimension is a dimension that contains a high percentage of occupied data values in each combination of dimensions that occurs
- A sparse dimension is a dimension that contains a low percentage of occupied data values in each combination of dimensions that occurs
- You can check whether a dimension is sparse or dense by clicking Administration – Dimensions – Performance Settings in Planning web
- B & C
52) Which statements are correct about member formulas? (Select correct options
- Member formulas are an alternative method of calculation, Formulas must end with a semi-colon
- Member formulas are part of Calc Scripts
- Members formulas can be added from Essbase
- A & C
53) Which statements are true about the HSP_UDF UDA?
- You need to add the HSP_UDF UDA to any member for which you have created a member formula
- By adding the HSP_UDF UDA to a member, you prevent the member formula from being overwritten during a refresh
- The HSP_UDF UDA is added from Essbase
- All of the above
54) Planning supports ASO databases in version
- 1.1.3
- 1.2.3
- 1.2.1
- Not Supported
55) An XREF retrieves data from:
- An Essbase database other than the current one
- The same database as the current one
- The relational database
- None of the above
56) When exporting data from Essbase, you can choose to export:
- Top level members only
- All data
- Level0 data blocks, Input level data blocks
- B & C
57) Hyperion Planning: (choose correct ones)
- Allows tracking of the planning process throughout the cycle, Is a web-based budgeting and planning solution
- Offers the ability to enhance decision making with reports and analysis
- Allows for web-based data entry
- All of the above
58) In Hyperion Business Rules , rules with the following locations set will be available to Hyperion Planning: (Choose all that apply)
- Essbase
- Planning
- Both
59) If you have a webform with Time Period@Idescendant in the columns and you modify the value for March, then:
- Year Total only is update
- Q1 and Year Total are automatically updated
- Only the new value entered for March is saved
- Jan, Feb, Q1 and Year Total are automatically updated
60) Which is the default RMI port?
- 11666
- 11333
- 8300
- 58080
61) Which Planning data form tasks you cannot perform with Smart View?
- View form instructions
- Enter supporting detail and cell text
- Launch business rules
- Modify data in display-only cells
62) What Planning utility can you use to export and import data forms?
- ImpExpUtil
- FormDefUtil
- FormLoadDefUtil
- None of the above
63) You can use composite data forms to perform the following tasks:
- Combine two or more forms on a single page.
- Perform real-time impact analysis by entering data in one data form and viewing the calculated results in another data form.
- Specify the order that data forms are displayed on a page and whether to combine the POV and page dimensions.
- All of the above
64) Who can access Planning application, when Application is in Maintenance Mode
- Planners
- Administrator
- All Users
- None of the above
65) Which types of tasks you cannot define in a task list?
- Workflow
- Business Rule
- Menu Item
- Descriptive
66) In Planning, what mode enables you to access all menus, toolbars, and tasks assigned to you by
your user role?
- Basic
- Advanced
- Administrator
- Shared
67) Select the types of access that you can assign to a task list:
- None
- Manage and Assign
- Manage
- All of the above
68) You can create Users/Groups for Planning Application from which interface
- Planning
- EAS
- Shared Services
- Workspace
69) You want to allow user access to Submit data in a form, what all access required to be given
- Planner
- Interactive User
- Planner, Form Access, Member read access
- Form Access, Member Input access, Planner
70) When we export Data from an App, exported file is created on ___
- Local system of the user
- Oracle RDBMS table
- Essbase Server App dir
- Planning Server app dir
71) Account A1 is tagged as “First” on Time Balance Property and “Skip Option” is None. Values in Jan,Feb and Mar are 0,25 and 105.50 respectively. What would be the value that A1 should show on Q1?
- 0
- 5
- 5
- 25
72) Account A1 is tagged as “First” on Time Balance Property and “Skip Option” is #missing. Values in Jan,Feb and Mar are 0,25 and 105.50 respectively. What would be the value that A1 should show on Q1?
- 0
- 25
- 5
- 5
73) Choose the correct order of the high level steps to be followed during setting up planning security in context to Shared Services and Planning artefacts?
- Create Users/Groups
- Assign Read/Write access
- Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access
- Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access
- Assign access to web forms and business rules
- Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access
- Assign access to web forms
74) When using the “Grid Spread” feature in Planning what does “Fill” spread type mean ?
- Spreads the value proportionally, based on the existing values in the target cells
- Spreads the values evenly among the target cells
- Replaces the value in all target cells
- Spreads the value proportionally, based on the factor called “Fill”
75) What are the correct predefined types of base time periods that can be established when creating the calendar in a planning application?
- Weekly, Monthly, Quarterly, Custom
- Weekly, Monthly, Quarterly, Yearly, Custom
- Monthly, Quarterly, Custom
- Monthly, Quarterly, Weekly
76) Which property is required to be set to enable an application for Offline Planning ?
- ENABLE_FOR_OFFLINE_USAGE
- ENABLE_OFFLINE_USAGE
- ENABLE_FOR_OFFLINE
- ENABLE_OFFLINE_USE
77) The outline and security structure of a Planning application are stored in _________
- Essbase
- EPMA Relational Repository
- Planning App Relational Repository
- EPM Foundations Relational Repository
78) Hyperion Planning audit trail is logged in __________ table
- hsp_audit_records
- hsp_object
- hsp_pm_states
- hsp_uda
79) Migrate launch access permissions on business rules and their projects from Business Rules to Calculation Manager business rules in Planning using _______________ utility
- HBRSecurity
- HBRMigrateSecurity
- MigrateSecurity
- MigrateHBRSecurity
80) Which property in planning can be used to specify which data type prevails when an intersection has conflicting data types ?
- Performance Order
- Evaluation Order
- Resolve Conflict Order
- Evaluate Data Type Order
81) Form definitions can be moved between Planning applications from Development to UAT using ______________
- FormDefUtil
- FormDefUtility
- FormDefinitionUtility
- FormDefinitionUtil
82) A Business Rule is launched from a data form. What will Planning utilize to provide a valid list of members for a run-time prompt?
- Members defined on the data form
- Business Rules security access privileges
- Essbase security filters
- Business Rules Basic User Role
83) What are valid data types for the Accounts dimension? Select all that apply.
- Currency
- Non-currency
- Percentage
- Currency
- Non-currency
- Percentage
- Saved Assumption
- Text
- Smart List
- Date
- Currency
- Non-currency
- Percentage
- Saved Assumption
- Smart List
- Date
- Text
- Smart List
- Date
- Currency
84) Using Copy Data feature planning administrators can copy ___________
- Account annotations and planning unit annotations
- Planning unit annotations
- Data values from one source to target intersections,account annotations,supporting details and cell text
- Account annotations, Cell text and planning unit annotations
85) Which UDA is used to prevent the @XREF function from being called on all plan types that are not the source plan type selected for that member ?
- HSP_UDF
- HSP_NOLINK
- HSP_NOCALLXREF
- HSP_NOLINKTOXREF
86) A planning application administrator wants to send information about system availability to the users currently logged in to the application. How would he do so ?
- Send email to all users
- Check with server team to find logged in users having ongoing sessions and send them email
- Use broadcast messaging feature
- Use broadcast alert feature
87) Select the incorrect event that do not happen during refreshing a planning application
- Security filters are updated
- Planning application is restructured
- UDAs are not added to the planning application
- Additions or changes to alias tables and their associations to dimensions or members are
88) What does “Validate Limits” mean while refreshing security filters in planning?
- Validate that the size of security filters does not exceed the Essbase limit of 128 KB per row
- Validate that the size of security filters does not exceed the Essbase limit of 64 KB per row
- Validate that the size of security filters does not exceed the Essbase limit of 32 KB per row
- Validate that the size of security filters does not exceed the Essbase limit of 16 KB per row
89) If you load a parent member that is enabled for dynamic children and its child members
during the same import __________________________________
- the child members are loaded as normal members as the database must be refreshed to create the placeholders in Essbase
- the child members are loaded as dynamic members
- the child members are not loaded as the database must be refreshed to create the placeholders in Essbase
- an error is encountered
90) Account A1 is tagged as “Weighted Average Actual_Actual” on Time Balance Property. Values in Jan,Feb and Mar are 10,20 and 30 respectively. What would be the value that A1 should show on Q1 if Feb has 29 days?
- 20
- 21
- 26
- 60
91) Account A1 is tagged as “Weighted Average Actual_365” on Time Balance Property. Values in Jan,Feb and Mar are 10,20 and 30 respectively. What would be the value that A1 should show on Q1 if Feb has 29 days?
- 25
- 22
- 27
- 50
92) Account A1 is tagged as Expense type. How would the variance reporting work for this ?
- The actual value is subtracted from the budgeted value to determine the variance
- The actual value is added to the budgeted value to determine the variance
- The budgeted value is subtracted from the actual value to determine the variance
- The budgeted value is added to the actual value to determine the variance
93) Statistical accounts defined in Planning should be ideally tagged as __________ account type
- Revenue
- Expense
- Saved Assumption
- Assets
94) Which dimensions are considered to set which plan types the members’ children has access?
- Entity and Account
- Entity and Period
- Account and Period
- Account and Year
95) The accounts tree coming from the Chart of Accounts of your ERP system has been plugged into your planning application, but it doesn’t conform with the Budgetary reporting requirements in terms of higher nodes. What would you do to solve this?
- Ask the ERP COA to align with Budgetary reporting requirements in terms of higher nodes.
- Build an alternate hierarchy conforming with budgetary reporting standards.
- Not possible in planning.
- Build a separate ASO reporting application
96) Select the correct event that happen during refreshing a non-currency planning application
- Dimension and member changes are pushed to Essbase
- Cell text and supporting detail changes are pushed to Essbase
- Data changes are pushed to Essbase
- Security filters for dimensions and members are recreated
97) While trying to save data against a member in a data form , Paul faced an issue that data is not getting saved. Choose the most probable answer as what the issue is ?
- The member Paul is trying to save the data against is the first child member of a label-only parent and the label-only parent is placed before their first child member
- The member Paul is trying to save the data against is the first child member of a label-only parent and the label-only parent follow their first child member
- The member Paul is trying to save the data against is the second child member of a label-only parent and the label-only parent follow their first child member
- The member Paul is trying to save the data against is the second child member of a label-only parent and the label-only parent is placed before their first child member
98) The Hyperion Planning administrator needs to run several calculations in a specific order against two different databases within the application. Identify the option that is not valid
- Maxl
- Calc Script
- HBR
- HBR Sequence
99) Smart List information for a Planning application is stored in ___________
- Essbase
- HSP_ENUMERATION table in Planning repository
- HSP_ENUMERATION and HSP_ENUMERATION_ENTRY table in Planning repository
- HSP_OBJECT and HSP_ENUMERATION table in Planning repository
100) What happens when you exclude a planning unit from planning budget approval process ?
a ) All associated annotations and history are discarded
b) Planning unit status is returned to Not Started state
a ) All associated annotations and history are discarded
b) Planning unit status is returned to Not Started state
c) Owner is set to No Owner
d) Data values are retained
a ) All associated annotations and history are discarded
b) Planning unit status is returned to Not Started state
c) Data values are retained
a ) All associated annotations and history are discarded
b) Planning unit status is returned to Not Started state
c) Owner is set to No Owner
101) When Workforce Planning module is enabled which dimensions are available with the package ?
- Account, Entity, Employee, Scenario, and Version
- Account, Entity, Employee, Scenario, Version, Period
- Account, HR Org, Employee, Scenario, Version, Period
- Entity, Employee, Scenario, Version, Period
102) A planning application was restored from backup but it is not available to be selected from EPM workspace. Why ?
- Restoration was not correctly done
- Backup was corrupt
- Foundation Services not working correctly
- The coupling between planning and Shared Services is lost. There is a need to register the application with Shared Services from within Planning.
103) A user has abnormally exited the planning application – How does the Planning Admin unlock the app ?
- Using HspUnlockApp Utility
- Restarting the Planning Services
- Restarting the Application Server
- Using HspUnlockPlnApp Utility
104) Company ABC with 150000 employees wants to implement employee level planning using WFP module. A an EPM consultant what would be your take ?
- No problems we can do it.
- Well, I’ve doubts on the model you are trying to implement- but lets start off and we will take care.
- Its not practical to use WFP for your organization and that too on employee based mode – sorry.
- Its not practical to use WFP for your organization and that too on employee based mode – lets discuss further on a position based planning method which would not depend on individual employees – but their grades.
105) Users are entering Supporting details from planning web form but they are not getting saved. Which planning property is required to be checked here?
- JDCB_MAX_CONNECTIONS
- JDCB_MIN_CONNECTIONS
- SUBST_VAR_CACHE_LIFETIME
- SUPPORTING_DETAIL_CACHE_SIZE
106) Period dimension of a planning application has been customized to weekly. Planning admin tries to tag account A1 to “Weighted Average – Actual_Actual” but fails – why?
- Admin tagged the account but didn’t refresh the database
- Admin should try “Weighted Average – Actual_365” as the period dimension has been customized
- This can be done with standard monthly calendar that rolls up to four quarters
- Period dimension should be customized to “daily” in order for this to take effect.
107) In a Planning implementation involving Workforce Planning and Base Planning module – XYZ Co. has 2 plan types under the same application. One in PnL cube and the other is the default cube for Workforce Planning. Which area on the PnL Cube ideally should t
- Expense
- Revenue
- Assets
- Expense and Assets
108) Hyperion Developer John from ABC Co. wants to create an actual data load process to his planning cubes which the budget admin would run from EPM workspace. Choose the correct sequence of steps he should follow to do it. Assume that his application and dat
- Create a Maxl script to load data.
- Create a EPM workspace job to call the Maxl script and pass the parameters.
- Import the executable .sh file as job and configure the front end jsp to run for this job.
- Provide necessary access to the budget adm
- Create a Maxl script to load data.
- Create a shell script to call the Maxl script with required parameters.
- Create a EPM workspace job to call the shell script and pass the parameters.
- Import the executable .sh file as job and configure the fro
- Create a shell script with required parameters.
- Create a EPM workspace job to call the shell script and pass the parameters.
- Import the executable .sh file as job and configure the front end jsp to run for this job.
- Provide necessary access to the budget admin.
- Create a Maxl script to load data and call it from EPM workspace via an EPM workspace job.
- Provide necessary access to the budget admin.
109) Choose the most correct set of events that may trigger a different promotional path to be followed in planning workflow
- a)Exceeding or missing certain expense boundaries b)Current owner returns the budget to the previous owner for additional information c)Current owner requests help from an authorized user who is not part of the promotional path
- a)Current owner returns the budget to the previous owner for additional information b)Current owner requests help from an authorized user who is not part of the promotional path
- Exceeding or missing certain expense boundaries
- Current owner requests help from an authorized user who is not part of the promotional path
110) In the Workforce Planning module, an employee is terminated. What two activities do you perform in WFP, so that total salary numbers are correctly calculated?
- Run a business rule to change the employee’s status.
- Change the employee’s status on a data form using the Smart List drop down.
- Run a business rule to change the employee’s status.
- Change the employee’s status on a data form using the free form text measure.
- Run a business rule to change the employee’s status.
- Change the employee status attribute association in the Employee dimension.
- Run a business rule to change the employee’s status.
- Delete the employee from Workforce Planning.