![MCQs [2024]](https://engineeringinterviewquestions.com/wp-content/uploads/2021/02/Interview-Questions-2.png)
HYPERION Online Test and Answers Pdf Download :-
These are very useful & Most Asked Questions in your certification Exam. Read all Online Mock Test Exam Question Bank for Beginners Freshers & Experienced.
1 . After creating a new Hyerion Planning appLication, what are two steps that must be taken for it to appear as a va[id 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
Answer: B, C
2. Which three options are supported authentication providers for CSS?
A. NTIS
B. Microsoft Active Directory
C. Sun Open Net Environment (Sun ONE)
D. NoveLl NDS
E. REAs LDAP Provider
Answer: 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 SeciJilty 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; 1-lyperion PLanning Web Application suppresses missing data; dispLays Web Form to Client
D. Checks Metadata Security for the User; 1-lyperion Planning Web Application suppresses missing data; sends the query to Hyperion Essbase; displays Web Form to Client
Mis: 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
Mis: A, B, E
5. Which three statements are true about the Cut function in the 1-lyperion 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
Answer: 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 1-lyperion Planning Spreadsheet Add-in
E. Create and update rules in 1-lyperion Business Rules (HBR)
Answer: 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 weekty distribution setting.
D. You can reduce the number of years in the calendar.
Answer: A
8. 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 accountwith Percentage Data Type
E. Saved Assumption accountwith Non-Currency Data Type
Answer: B
9. What is the ideal data block size?
A. Between eight and 1 00 kiLobytes
B. Between 101 and 250 kilobytes
C. Between 251 and 500 kilobytes
D. Greater than 500 kilobytes
Answer: A
10. Which five tasks are performed when setting up a 1-lyperion 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.
Answer: A, B, D, E, F
11. When refreshing the database in a multi-currency application, what can be selected to create a Currency Conversion Caic 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
Answer: A
12. Which two statements about account level annotations are true?
A. Account level annotations can have 1 500 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.
Answer: 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
Answer: 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
Answer: 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
Answer: A
HYPERION Objective type Questions with Answers
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.
Answer: 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. tost of Sales
E. (Total Expenses)
Answer: A, B
18. The Create Blocks componentwithin F-Iyperion Business Rules (HBR) is used for the purposeof
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
Answer: 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
Answer: A, B, C
20. When designing a report in Hyperion Reports, where do you set me txpansion upnon
A. On the Cell Properties
B. On the Row Properties
C. On the Grid Properties
D. On the Report Properties
Answer: 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. 1-lyperion Planning Spreadsheet Add-in
Answer: 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 CaIc and Store, Never Share, Shared, Store
D. Dynamic Calc, Dynamic Cat and Store, Label Only, Never Share, Shared, Store
Answer: 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
Answer: 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
Answer: 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
Answer: A, B, E
26. What are two reasons for creating or re-creating a Currency Conversion cat 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.
Answer: 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.
Answer: 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 alt dimension selections on the Web form
Answer: 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.
Answer: 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 toad into Hyperion Planning Relational Database
D. Use Hyperion Application Link flow diagram utilizing the Hyperion Planning Adapter
Answer: A