Hyperion Multiple Choice Questions and Answers
1. After creating a new Hyperion Planning application, what are two steps that must be taken for it to appear as a valid Web application at the Web LogOn page?
A. Restart the Essbase server
B. Run the HspSetupSupport utility
C. Restart the Web application server
D. Within Hyperion Planning, select Enable Web LogOn
Ans: B, C
2. Which three options are supported authentication providers for CSS?
A. NTLM
B. Microsoft Active Directory
C. Sun Open Net Environment (Sun ONE)
D. Novell NDS
E. BEA's LDAP Provider
Ans: A, B, C
3. What is the correct order Hyperion Planning will follow to generate a Web Form with Suppress Missing data enabled?
A. Hyperion Planning Web Application suppresses missing data;sends the query to Hyperion Essbase;checks Metadata security for the user; displays Web Form to Client
B. Checks Metadata Security for the User; sends the query to Hyperion Essbase; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
C. Sends the query to Hyperion Essbase; checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
D. Checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; sends the query to Hyperion Essbase; displays Web Form to Client
Ans: B
4. What three properties can be defined for User-defined custom dimensions?
A. Name
B. Security
C. Data type
D. Source plan type
E. Custom attributes
Ans: A, B, E
5 Which three statements are true about the Cut function in the Hyperion Planning Dimension Editor?
A. It is not available for root dimension members.
B. It remembers a cut member if the administrator expands, collapses, sorts, searches, or changes pages in a dimension hierarchy.
C. It remembers a cut member if the administrator adds a child or sibling member, edits or deletes a member, assigns access to a member or clicks the View link.
D. It remembers a cut member if the administrator adds or edits a dimension, navigates to a page other than the Dimensions tab, deletes a member, or logs off Hyperion Planning.
E. It allows for mulitple cut selections at the same level.
Ans: A, B, C
6 Which three tasks can be performed by a Planner?
A. Modify Web forms
B. Input, submit, and view data
C. View data through Hyperion Reports
D. Use Hyperion Planning Spreadsheet Add-in
E. Create and update rules in Hyperion Business Rules (HBR)
Ans: B, C, D
7 After the calendar is created through the application setup, which statement is true?
A. You can change the rollup structure.
B. You can change the base time periods.
C. You can change the weekly distribution setting.
D. You can reduce the number of years in the calendar.
Ans: A
8 In a multi-currency application, a calc script was created using Hyperion Planning Desktop. The following selections were made: "USD", "CAD", Budget, "1st Draft" and"Bottom-Up." What will be converted after the Currency Conversion Calc Script is run?
A. Parent members
B. Level zero members
C. Forecast Scenario for the USD Currency
D. Saved Assumption account with Percentage Data Type
E. Saved Assumption account with Non-Currency Data Type
Ans: B
9 What is the ideal data block size?
A. Between eight and 100 kilobytes
B. Between 101 and 250 kilobytes
C. Between 251 and 500 kilobytes
D. Greater than 500 kilobytes
Ans: A
10 Which five tasks are performed when setting up a Hyperion Planning application? (Choose five.)
A. Setting up plan types
B. Creating the calendar
C. Setting up exchange rates
D. Defining the calendar range
E. Setting up multiple currencies
F. Defining base time period and weekly distribution.
Ans: A, B, D, E, F
11 When refreshing the database in a multi-currency application, what can be selected to create a Currency Conversion Calc Script?
A. Currencies, Scenarios, Version Type, and Versions
B. Currencies, Scenarios, Years, and Exchange Rate Type
C. Currencies, Scenarios, Years, Version Type, and Versions
D. Currencies, Scenarios, Years, Exchange Rate Type, and Versions
Ans: A
12 Which two statements about account level annotations are true?
A. Account level annotations can have 1500 characters.
B. Only parent level members can have account level annotations.
C. To enable the account level annotations, the Web form design does not matter.
D. A specific option must be selected in the display options page to enable the account level annotations.
Ans: A, D
13 Which three are valid properties of Scenarios with the Hyperion Planning Web Dimension Editor?
A. Access Rights
B. Time Periods
C. Data Storage
D. Exchange Rate Table
Ans: A, B, D
14 Which two Hyperion Application Link Adapters can be used together to load data?
A. Essbase Adapter
B. Flat File Adapter
C. Web Form Adapter
D. Hyperion Planning Adapter
Ans: A, B
15 When using the Hyperion Planning ADM driver within Hyperion Reports, which function is used to select Attribute members?
A. Property
B. Member
C. Relative Member
D. Range
Ans: A
16 Supporting Detail can have which two properties?
A. Detail cannot be deleted once created.
B. Data can be filled across a series of columns.
C. Detail can be retrieved in the Spreadsheet Add-in.
D. It can only be text information, no data can be input.
E. Data can be in hierarchical form and include aggregation of values.
Ans: B, E
17 Which two are valid Account member names that can be used in Hyperion Planning?
A. 4200
B. Net-Profit
C. _Gross Sales
D. 'Cost of Sales'
E. (Total Expenses)
Ans: A, B
18 The Create Blocks component within Hyperion Business Rules (HBR) is used for the purpose of _____.
A. Creating blocks for dense member combinations
B. Creating blocks for sparse member combinations
C. Creating blocks for attribute member combinations
D. Creating blocks for dynamically calculated and stored member combinations
Ans: B
19 What are three valid variables to consider about Hyperion Planning application Web performance?
A. Network bandwidth
B. Design of existing web forms
C. Server hardware specifications
D. Number of users that exist within the application
Ans: A, B, C
20 When designing a report in Hyperion Reports, where do you set the Expansion Option?
A. On the Cell Properties
B. On the Row Properties
C. On the Grid Properties
D. On the Report Properties
Ans: B
21 Hyperion Planning connects to Essbase using the non-underscore username to establish a connection for which two products?
A. Hyperion Reports
B. Essbase Spreadsheet Add-in
C. Hyperion Planning Web Application
D. Hyperion Planning Spreadsheet Add-in
Ans: A, B
22 Which list of data storage settings represents all of the available settings for the Entities dimension in the Hyperion Planning Dimension Editor?
A. Dynamic Calc, Never Share, Shared, Store
B. Dynamic Calc, Label Only, Never Share, Store
C. Dynamic Calc, Dynamic Calc and Store, Never Share, Shared, Store
D. Dynamic Calc, Dynamic Calc and Store, Label Only, Never Share, Shared, Store
Ans: D
23 In a multi-currency application using a Target Version, what calculation options should be used with the Aggregate Data component?
A. Aggregate Data up to Local Currency, Aggregate Missing Values, and Use Calculator Cache
B. Aggregate Missing Values, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
C. Aggregate Data up to Local Currency, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
D. Aggregate Missing Values, Aggregate Data up to Local Currency, and Optimize the Calculation of Formulas on Sparse Dimensions
Ans: C
24 Which three predefined types of base time periods can be established when creating the calendar?
A. Weekly
B. Monthly
C. Quarterly
D. Yearly
E. Custom
Ans: B, C, E
25 Which three options are Maintain User tasks in Hyperion Reports?
A. Assign user to a Role
B. Import Essbase Users
C. Import Windows NT users
D. Import LDAP Users
E. Import Users from a text file
Ans: A, B, E
26 What are two reasons for creating or re-creating a Currency Conversion calc script?
A. A currency is no longer a reporting currency.
B. Data in the Essbase database were modified.
C. Another year has been added to the application.
D. A new entity member was added to the application.
E. A foreign currency exchange rate value was modified.
Ans: A, C
27 A user receives "You do not have access to view this form" when trying to open a Web form. What causes this message?
A. The user does not have Write access to the form.
B. The user does not have Read access to the form.
C. The user does not have access to every member in the form.
D. The user does not have access to at least one member in every dimension in the form.
Ans: D
28 When would account annotations be available?
A. when the option is turned on in the application setup
B. Only when the Web form is designed by an administrator
C. When the Web form is designed to using the proper layout
D. When the user has write access to all dimension selections on the Web form
Ans: C
29 In a multiple plan type application, which statement is true?
A. Security Refreshing can be limited to a Plan Type.
B. A descendant member within the Custom dimension can be made valid for a Plan Type.
C. The Accounts dimension can be dense for one Plan Type and sparse for another Plan Type.
D. After the application has been set up but the Create has not been run, the Plan Type names can be changed.
Ans: C
30 The client wants to load actual data from the general ledger but the file generated requires fields to be ignored and the order of the fields to be changed. What is a possible method for completing this task?
A. Use an Essbase data load rule
B. Use the Web Form import utility
C. Use SQL statement to load into Hyperion Planning Relational Database
D. Use Hyperion Application Link flow diagram utilizing the Hyperion Planning Adapter
Ans: A
31. Items opened in Explore display as these at the bottom of Workspace.
A. Buttons
B. Tabs
C. Icons
D. Pages
Ans: B
32. Data is typically entered into which member of a dimension hierarchy?
A. Descendants
B. Parents
C. Children
D. Base-level members
Ans: D
33. The EPM Workspace is accessed through which of the following?
A. My Computer
B. Excel
C. Internet Explorer
D. My Documents
Ans: C
34. Hyperion Financial Reporting is used for which of the following?
A. On-demand, highly formatted financial & operational reports
B. Interactive Ad-hoc analysis
C. Importing financial data
D. All of the above
Ans: A
35. What is the centralized administration environment in Hyperion called?
A. Workplace
B. Workspace
C. Workforce
D. Workplan
Ans: B
1. After creating a new Hyperion Planning application, what are two steps that must be taken for it to appear as a valid Web application at the Web LogOn page?
A. Restart the Essbase server
B. Run the HspSetupSupport utility
C. Restart the Web application server
D. Within Hyperion Planning, select Enable Web LogOn
Ans: B, C
2. Which three options are supported authentication providers for CSS?
A. NTLM
B. Microsoft Active Directory
C. Sun Open Net Environment (Sun ONE)
D. Novell NDS
E. BEA's LDAP Provider
Ans: A, B, C
3. What is the correct order Hyperion Planning will follow to generate a Web Form with Suppress Missing data enabled?
A. Hyperion Planning Web Application suppresses missing data;sends the query to Hyperion Essbase;checks Metadata security for the user; displays Web Form to Client
B. Checks Metadata Security for the User; sends the query to Hyperion Essbase; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
C. Sends the query to Hyperion Essbase; checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; displays Web Form to Client
D. Checks Metadata Security for the User; Hyperion Planning Web Application suppresses missing data; sends the query to Hyperion Essbase; displays Web Form to Client
Ans: B
4. What three properties can be defined for User-defined custom dimensions?
A. Name
B. Security
C. Data type
D. Source plan type
E. Custom attributes
Ans: A, B, E
5 Which three statements are true about the Cut function in the Hyperion Planning Dimension Editor?
A. It is not available for root dimension members.
B. It remembers a cut member if the administrator expands, collapses, sorts, searches, or changes pages in a dimension hierarchy.
C. It remembers a cut member if the administrator adds a child or sibling member, edits or deletes a member, assigns access to a member or clicks the View link.
D. It remembers a cut member if the administrator adds or edits a dimension, navigates to a page other than the Dimensions tab, deletes a member, or logs off Hyperion Planning.
E. It allows for mulitple cut selections at the same level.
Ans: A, B, C
6 Which three tasks can be performed by a Planner?
A. Modify Web forms
B. Input, submit, and view data
C. View data through Hyperion Reports
D. Use Hyperion Planning Spreadsheet Add-in
E. Create and update rules in Hyperion Business Rules (HBR)
Ans: B, C, D
7 After the calendar is created through the application setup, which statement is true?
A. You can change the rollup structure.
B. You can change the base time periods.
C. You can change the weekly distribution setting.
D. You can reduce the number of years in the calendar.
Ans: A
8 In a multi-currency application, a calc script was created using Hyperion Planning Desktop. The following selections were made: "USD", "CAD", Budget, "1st Draft" and"Bottom-Up." What will be converted after the Currency Conversion Calc Script is run?
A. Parent members
B. Level zero members
C. Forecast Scenario for the USD Currency
D. Saved Assumption account with Percentage Data Type
E. Saved Assumption account with Non-Currency Data Type
Ans: B
9 What is the ideal data block size?
A. Between eight and 100 kilobytes
B. Between 101 and 250 kilobytes
C. Between 251 and 500 kilobytes
D. Greater than 500 kilobytes
Ans: A
10 Which five tasks are performed when setting up a Hyperion Planning application? (Choose five.)
A. Setting up plan types
B. Creating the calendar
C. Setting up exchange rates
D. Defining the calendar range
E. Setting up multiple currencies
F. Defining base time period and weekly distribution.
Ans: A, B, D, E, F
11 When refreshing the database in a multi-currency application, what can be selected to create a Currency Conversion Calc Script?
A. Currencies, Scenarios, Version Type, and Versions
B. Currencies, Scenarios, Years, and Exchange Rate Type
C. Currencies, Scenarios, Years, Version Type, and Versions
D. Currencies, Scenarios, Years, Exchange Rate Type, and Versions
Ans: A
12 Which two statements about account level annotations are true?
A. Account level annotations can have 1500 characters.
B. Only parent level members can have account level annotations.
C. To enable the account level annotations, the Web form design does not matter.
D. A specific option must be selected in the display options page to enable the account level annotations.
Ans: A, D
13 Which three are valid properties of Scenarios with the Hyperion Planning Web Dimension Editor?
A. Access Rights
B. Time Periods
C. Data Storage
D. Exchange Rate Table
Ans: A, B, D
14 Which two Hyperion Application Link Adapters can be used together to load data?
A. Essbase Adapter
B. Flat File Adapter
C. Web Form Adapter
D. Hyperion Planning Adapter
Ans: A, B
15 When using the Hyperion Planning ADM driver within Hyperion Reports, which function is used to select Attribute members?
A. Property
B. Member
C. Relative Member
D. Range
Ans: A
16 Supporting Detail can have which two properties?
A. Detail cannot be deleted once created.
B. Data can be filled across a series of columns.
C. Detail can be retrieved in the Spreadsheet Add-in.
D. It can only be text information, no data can be input.
E. Data can be in hierarchical form and include aggregation of values.
Ans: B, E
17 Which two are valid Account member names that can be used in Hyperion Planning?
A. 4200
B. Net-Profit
C. _Gross Sales
D. 'Cost of Sales'
E. (Total Expenses)
Ans: A, B
18 The Create Blocks component within Hyperion Business Rules (HBR) is used for the purpose of _____.
A. Creating blocks for dense member combinations
B. Creating blocks for sparse member combinations
C. Creating blocks for attribute member combinations
D. Creating blocks for dynamically calculated and stored member combinations
Ans: B
19 What are three valid variables to consider about Hyperion Planning application Web performance?
A. Network bandwidth
B. Design of existing web forms
C. Server hardware specifications
D. Number of users that exist within the application
Ans: A, B, C
20 When designing a report in Hyperion Reports, where do you set the Expansion Option?
A. On the Cell Properties
B. On the Row Properties
C. On the Grid Properties
D. On the Report Properties
Ans: B
21 Hyperion Planning connects to Essbase using the non-underscore username to establish a connection for which two products?
A. Hyperion Reports
B. Essbase Spreadsheet Add-in
C. Hyperion Planning Web Application
D. Hyperion Planning Spreadsheet Add-in
Ans: A, B
22 Which list of data storage settings represents all of the available settings for the Entities dimension in the Hyperion Planning Dimension Editor?
A. Dynamic Calc, Never Share, Shared, Store
B. Dynamic Calc, Label Only, Never Share, Store
C. Dynamic Calc, Dynamic Calc and Store, Never Share, Shared, Store
D. Dynamic Calc, Dynamic Calc and Store, Label Only, Never Share, Shared, Store
Ans: D
23 In a multi-currency application using a Target Version, what calculation options should be used with the Aggregate Data component?
A. Aggregate Data up to Local Currency, Aggregate Missing Values, and Use Calculator Cache
B. Aggregate Missing Values, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
C. Aggregate Data up to Local Currency, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
D. Aggregate Missing Values, Aggregate Data up to Local Currency, and Optimize the Calculation of Formulas on Sparse Dimensions
Ans: C
24 Which three predefined types of base time periods can be established when creating the calendar?
A. Weekly
B. Monthly
C. Quarterly
D. Yearly
E. Custom
Ans: B, C, E
25 Which three options are Maintain User tasks in Hyperion Reports?
A. Assign user to a Role
B. Import Essbase Users
C. Import Windows NT users
D. Import LDAP Users
E. Import Users from a text file
Ans: A, B, E
26 What are two reasons for creating or re-creating a Currency Conversion calc script?
A. A currency is no longer a reporting currency.
B. Data in the Essbase database were modified.
C. Another year has been added to the application.
D. A new entity member was added to the application.
E. A foreign currency exchange rate value was modified.
Ans: A, C
27 A user receives "You do not have access to view this form" when trying to open a Web form. What causes this message?
A. The user does not have Write access to the form.
B. The user does not have Read access to the form.
C. The user does not have access to every member in the form.
D. The user does not have access to at least one member in every dimension in the form.
Ans: D
28 When would account annotations be available?
A. when the option is turned on in the application setup
B. Only when the Web form is designed by an administrator
C. When the Web form is designed to using the proper layout
D. When the user has write access to all dimension selections on the Web form
Ans: C
29 In a multiple plan type application, which statement is true?
A. Security Refreshing can be limited to a Plan Type.
B. A descendant member within the Custom dimension can be made valid for a Plan Type.
C. The Accounts dimension can be dense for one Plan Type and sparse for another Plan Type.
D. After the application has been set up but the Create has not been run, the Plan Type names can be changed.
Ans: C
30 The client wants to load actual data from the general ledger but the file generated requires fields to be ignored and the order of the fields to be changed. What is a possible method for completing this task?
A. Use an Essbase data load rule
B. Use the Web Form import utility
C. Use SQL statement to load into Hyperion Planning Relational Database
D. Use Hyperion Application Link flow diagram utilizing the Hyperion Planning Adapter
Ans: A
31. Items opened in Explore display as these at the bottom of Workspace.
A. Buttons
B. Tabs
C. Icons
D. Pages
Ans: B
32. Data is typically entered into which member of a dimension hierarchy?
A. Descendants
B. Parents
C. Children
D. Base-level members
Ans: D
33. The EPM Workspace is accessed through which of the following?
A. My Computer
B. Excel
C. Internet Explorer
D. My Documents
Ans: C
34. Hyperion Financial Reporting is used for which of the following?
A. On-demand, highly formatted financial & operational reports
B. Interactive Ad-hoc analysis
C. Importing financial data
D. All of the above
Ans: A
35. What is the centralized administration environment in Hyperion called?
A. Workplace
B. Workspace
C. Workforce
D. Workplan
Ans: B