Hyperion Planning Interview Questions & Answers
In a Planning application it is possible to select several currencies per entity member?
FALSE
When creating a multi-currency application, which dimensions are automatically created in Essbase?
Currencies
HSP_Rates
When you convert currencies in a webform, converted values are?
Read-Only
It is possible to select the application’s default currency as a triangulation currency?
False
Exchange rates are set up from?
The Planning Desktop
If you change an exchange rate, you must?
Refresh the application selecting the option “Currency Conversion Calc Script” and run the HspCRtb or HspCRtt script
If you add a new reporting currency, scenario or version to your application, you must?
Refresh the application selecting the option “Currency Conversion Calc Script” and run the HspCRtb or HspCRtt script
How many currencies can you select per Entity member?
1
The HSP_RATES Dimension includes the following members?
HSP_InputValue
HSP_InputCurrency
HSP_Rate_XXX (where XXX is a currency, i.e USD)
What exchange rate types are available in for the Accounts Dimension?
– None
-Average
-Ending
-Historical
What are the 5 options in the Currency Calculation Script section on the Planning Desktop?
Calc Script Name
-Version Type
-Currencies
-Scenarios
-Versions
What are the 2 copy calc scripts called?
HspCRtB
HspCRtT
The copy calc scripts copy exchange rates from top level dimension members to Level0 members?
True
From which dimensions can you import members using the HAL Planning Adapter?
-Accounts
-Entities
-Custom Dimensions
-Alias
What must be done before loading custom dimension members using HAL?
Create the user defined custom dimension in Planning Web
What Hyperion tools can be used to load data?
HAL Essbase adapter
EAS
Essbase Application Manager (for versions prior to 4.x)
When creating a single currency application, which dimensions are automatically created?
Accounts
Currencies
Entities
Scenarios
Time Periods
Versions
Years
Which 2 statements are correct?
Target versions let you enter data for members at any level in the hierarchy
Bottom-Up versions only allow for data entry at Level0
Which statement is correct?
Bottom-Up versions only can be enabled for Process Management (Workflow)
Which statement is correct about copying versions?
You can copy account annotations as well as supporting details
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 13 user-defined custom dimensions
The name for a user-defined custom dimension can be up to 80 characters
It is possible to change the starting year or month after an application has been created?
False
Weekly distribution options (4-4-5, 4-5-4, 5-4-4) are only available with monthly time periods, not for custom or quarterly time periods?
True
At TekSlate, we offer resources that help you in learning various IT courses. We avail both written material and demo video tutorials. To gain in-depth knowledge and be on par with practical experience, then explore Hyperion Training Videos.
Which 2 statements are correct about Plan Types?
A plan type name can be up to 8 characters
When adding a new account member, you must change the source plan type
If the base time period selected is 12 months, how is the default calendar set up?
Months rolling into four quarter parents, and quarters rolling into a total year parent
To which application elements can access rights for users and groups be assigned?
Scenario dimension members
Version dimension members
Account dimension members
Entity dimension members
User-defined custom dimension members
Data entry forms
Business Rules
What is Essbase limit for security filters?
64 KB
What must be done after creating or updating user and / or group security?
Refresh the application including the security from the Planning Desktop
You can specify several application owners per application?
False
Interactive users can:?
Enable e-mail notification for themselves
Create and maintain web-based data entry forms
Create and launch business rules
Create and launch adapter processes via HAL
Submit info and data for approval
Planners can:?
Enable e-mail notification for themselves
Input, submit and view data
Use any data access tools for which they are licensed (such as Reports and Analyzer)
Submit info and data for approval
Use reports that have been built by others
Execute business rules
Use the Planning spreadsheet add-in
When you add a user in Hyperion Planning web, how many users are automatically created in Essbase?
2: the named user and the underscore user
Planning users who wish to change their passwords can do so:?
From the External Authentication Provider
If a user is assigned to a group and the access rights on the individual user conflict with those of the group:?
User access rights will take precedence over group access
If a user belongs to several groups that have conflicting access rights to a member, then:?
None takes precedence over Write and Read access
Write takes precedence over Read access
Rights assigned directly to a member override rights derived from a member relationship (e.g Idescendants):?
True
What step must be taken in order to assign access to user-defined custom dimension members?
The application must be refreshed
Give 5 aggregation options:?
Division
Currency
Substraction
Multiplication
Percentage
Ignore
Addition
Dynamic Calc should not be used for base level members for which users enter data since data values are not saved for Dynamic Calc members
True
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
How many aliases can be assigned per dimension member in Planning?
10
In order to be visible in Planning web, Alias tables should be created in:?
Planning
Which are correct account types from the list below?
Expense, Revenue, Asset, Liability, Equity, Saved Assumption
Target versions allow for data entry in both parent and bottom level members?
True
Attributes can be assigned to:?
Sparse dimensions only
For which dimensions are shared members available?
Accounts
User-Defined dimensions
Entities
Which statement is true?
Security can be assigned to shared members but not to custom attributes
Supporting Details can be added to both bottom-up and target versions?
True
When you type in a value into a bottom level time period, the totals for summary time periods are updated immediately?
True
In Planning web, when you press the refresh button:?
The form is refreshed with the last saved values – Any values that have not been saved are discarded
For indepth understanding of Hyperion Planning click on
Business Rules in Hyperion Planning
Hyperion Planning Architecture
Steps to create a planning application
Data Forms and Example in Hyperion Plannings
Our design of course tutorials and interview questions is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online Hyperion Planning Training.
Can you please add Questions in Essbase and HFM too