Hyperion Planning Intermediate Quiz

Posted on: | By: – Comments Off

Hyperion Planning Quiz

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



1) Which options are specified when creating Essbase Server data load rules? (Choose relevant)

  1. File delimiters,Associated outline,Member names to column fields mappings
  2. Header information
  3. Column fields and replace text strings
  4. All of the above

Answer : D

 
 
2) When using the MemberName function in a row heading, which parameter does NOT support the
Current keyword? <<MemberName(“GridName”, Row, “DimName”)>>
 

  1. DimName
  2. GridName
  3. Row
  4. None of the above

Answer : A

 
 
3) A user sets up a Choices list for the Scenario dimension of the Profit database to limit his user
Point of View selections to Actual and Budget. This limits the user’s member selection to:
 

  1. All reports generated for any database connection
  2. All reports generated for the Profit database connection
  3. Only the currently selected grid that retrieves data from the Profit database connection
  4. Only the currently selected report that retrieves data from the Profit database connection

Answer : B

 
 
4) In EPM architect, you have which option(s) for managing inherited property values?

  1. Clear property values for an individual member, so that it reverts to the value from its nearest ancestor.
  2. Lock property at the ancestor level so that the inherited value cannot be overridden by its descendants.
  3. (You cannot manage dimension property value inheritance in EPM Architect)
  4. A & B

Answer : D

 
 
5) To maintain vertical separation between report objects that change size, use____positioning.
 

  1. Bottom
  2. Center
  3. Relative
  4. Top

Answer : C

 
 
6) What Planning utility can you use to export and import data forms?

  1. ImpExpUtil
  2. FormDefUtil
  3. FormLoadDefUtil
  4. None of the above

Answer : B

 
 
7) You can use which formulas in business rules? (Choose all that apply

  1. Pro Rata
  2. Units-Rates, Variable
  3. Custom
  4. All of the above

Answer : D

 
 
8) Offline Planning enables you to:

  1. Work with Planning data forms in disconnect mode
  2. Use a local data source connection to work with Planning data forms in Excel
  3. Utilize the same robust features that Planning offers
  4. A & B

Answer : D

 
 
9) To automatically format cells based on specified attributes or values, use:

  1. Conditional formatting
  2. Format Painter
  3. Format option
  4. Report Painter

Answer : A

 
 
10) Which of the following statements are true for entity members and plan types?

  1. When you create entity members, you assign plan types.
  2. If you do NOT assign a plan type to an entity, its children do NOT have access to that plan type.
  3. A & B
  4. (None of these statements are true)

Answer : C




 
11) You can use composite data forms to perform the following tasks:

  1. Combine two or more forms in a single page
  2. Perform real-time impact analysis by entering data in one data form and viewing the calculated results in another data form.
  3. Specify the order that data forms are displayed on a page and whether to combine the POV
  4. and page dimensions.
  5. All of the above

Answer : D

 
 
12) SCENARIO: User A just entered information into a data form and is unable to launch a needed business rule. As the administrator, what must you do to solve this issue?

  1. Have User A launch the business rule from Analytic Administration Services
  2. Assign launch privileges to User A
  3. Have User A restart all running services
  4. (None of the above)

Answer : B

 
 
13) There are ___ version dimension types for building your plan.

  1. 2
  2. 3
  3. 4
  4. (None of the above)

Answer : A

 
 
14) The order of dimensions is critical to the structure and performance of Essbase Servers databases. How should dimensions be ordered to maximize performance?

  1. Dense dimensions should be ordered most dense to least dense.
  2. Aggregating sparse dimensions should be ordered smallest to largest.
  3. Non-aggregating sparse dimensions should be ordered smallest to largest.
  4. All of the above

Answer : D

 
 
15) An IncStmt report is created in the Finance folder in the repository. To give Mr.Planuser access to the report, the report designer must assign View permission on the:

  1. IncStmt report
  2. IncStmt report and Finance folder
  3. Incstmt report, Finance folder, and Root folder
  4. None of the above

Answer : B

 
 
16) In Planning, what mode enables you to access all menus, toolbars, and tasks assigned to you by your user role?

  1. Basic
  2. Advanced
  3. Administrator
  4. Shared

Answer : B

 
 
17) In the Select Members dialog box, which of the following functions is NOT available from the Add Relationship button?
 

  1. Ancestors
  2. Current Point of View
  3. Siblings
  4. Parent (Inclusive)

Answer : B

 
 
18) Select the types of access that you can assign to a task list:

  1. Manage and Assign
  2. Manage
  3. A&B
  4. None of the above

Answer : C

 
 
19) Within each branch of a dimension, which values are calculated first for a Planning outline in Analytic Services?
 

  1. Level 0 values
  2. Level 1 values
  3. Parent value
  4. None of the above

Answer : A

 
 
20) Which function is an auto calculation and a mathematical function?

  1. Average
  2. Difference
  3. Rank
  4. All of the above

Answer : A




 
21) Which statements are correct about Plan Types:

  1. A plan type name can be up to 8 characters
  2. When adding a new account member, you must change the source plan type
  3. When adding a new entity member, you can change the source plan type
  4. All of the above

Answer : D

 
 
22) If the base time period selected is 12 months, how is the default calendar set up?

  1. All 12 months rolling up into a total year parent
  2. Summary time periods must be created through the calendar dimension
  3. Months rolling into four quarter parents, and quarters rolling into a total year parent
  4. Months rolling into quarters, and quarters rolling into half year parents, and half years rolling into a total year parent

Answer : C

 
 
23) To which application elements can access rights for users and groups be assigned?

  1. Scenario dimension members,Entity dimension members,User-defined custom dimension members, Data entry forms,Business Rules
  2. Version dimension members
  3. Account dimension members
  4. All of the above

Answer : D

 
 
24) What is Essbase limit for security filters?

  1. 8 KB
  2. 32 KB
  3. 64 KB
  4. There is no limit

Answer : C

 
 
25) What must be done after creating or updating user and / or group security?

  1. Disconnect and reconnect from Planning web
  2. Connect to the EAS console to refresh the security filters
  3. Refresh the application including the security
  4. Click Administration – Update Security from the Planning Web

Answer : C

 
 
26) Planners can:

  1. Enable e-mail notification for themselves,Use any data access tools for which they are licensed (such as Reports and Analyzer), Execute business rules
  2. Create Planning applications
  3. Input, submit and view data, Submit info and data for approval, Use reports that have been built by others, Use the Planning spreadsheet add-in
  4. A & C

Answer : D

 
 
27) Planning users who wish to change their passwords can do so:

  1. From planning web by selecting Administration – Users and Groups
  2. Directly from Essbase
  3. From the External Authentication Provider
  4. From the Planning Desktop

Answer : C

 
 
28) If a user is assigned to a group and the access rights on the individual user conflict with those of the group:

  1. group access rights will take precedence over user access
  2. user access rights will take precedence over group access
  3. user and group access rights are automatically merged
  4. All of the above

Answer : B

 
 
29) If a user belongs to several groups that have conflicting access rights to a member, then:

  1. Write takes precedence over None and Read access
  2. None takes precedence over Write and Read access
  3. Write takes precedence over Read access
  4. B & C

Answer : D

 
 
30) What step must be taken in order to assign access to user-defined custom dimension members?

  1. The application must be refreshed
  2. The application must be in read-only mode
  3. The “Apply Security” property must be selected when adding the custom dimension
  4. A&C

Answer : D




 
31) Select correct aggregation options:

  1. Balance,Division,Percentage
  2. Division,Percentage
  3. Substraction,Multiplication,Ignore, Addition
  4. B & C

Answer : D

 
 
32) Which statement is true?

  1. Security can be assigned to shared members but not to custom attributes
  2. Security can be assigned to custom attributes but not shared members
  3. Security can be assigned to shared members and custom attributes
  4. None of the above

Answer : A

 
 
33) In Planning web, when you press the refresh button:

  1. The form is saved and the latest values are displayed
  2. The form is refreshed with the last saved values – Any values that have not been saved are discarded
  3. Any changes made during the session are discarded, even if the form was saved
  4. None of the above

Answer : B

 
 
34) A webform can be assigned to how manyPlan Types?

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

Answer : A

 
 
35) After a webform is created:(Choose the Correct one)

  1. The Plan Type cannot be changed
  2. The Plan Type can be changed by administrators and Interactive users with write access to the webform
  3. Only the application owner can change the Plan Type
  4. All of the above

Answer : A

 
 
36) Which statements are true about form folders: (select all correct

  1. You cannot rename a folder
  2. You can assign access rights to a folder
  3. You cannot delete a folder unless it is empty
  4. All of the above

Answer : D

 
 
37) You can select multiple members in a Form in which of these

  1. Page
  2. Rows/Colums
  3. POV
  4. A&B

Answer : D

 
 
38) In order to view account annotations, the Show Account Annotations option must be ticked:
 

  1. In the Preferences Page
  2. On the webform itself when entering data
  3. In the Display Options of the form properties
  4. On the Accounts dimension in the Dimensions screen

Answer : C

 
 
39) In order for a user to use account annotations:

  1. The Entities dimension must be in the row , the Accounts dimension must be in the row, page or POV, and the Version and Scenario dimensions must be assigned to either the page or POV
  2. The Accounts dimension must be in the row , the Entities dimension must be in the row, page or POV, and the Version and Scenario dimensions must be assigned to either the page or POV
  3. The Entities dimension must be in the row , the Accounts dimension must be in the row, page or POV, the Years dimension must be in the column and the Version and Scenario dimensions must be assigned to either the page or POV
  4. The Entities dimension must be in the row , the Accounts and Year dimensions must be in the column and the Version and Scenario dimensions must be assigned to either the page or POV

Answer : B

 
 
40) What type of access can be assigned to webforms?

  1. Read – Write – None – Modify
  2. Read – Write – User Defined
  3. Read – Write – None
  4. Read – Write – None – User Defined

Answer : C




 
41) If a user has read-only access to a webform, then:

  1. the user has read-only access to the webform and cannot change the form’s design
  2. the user can see and use the form for data entry and change the form’s design
  3. the user can see and use the form for data entry but cannot change the form’s design
  4. None of the above

Answer : A

 
 
42) The preferences page in Planning web (File – Preferences) allows users to: (Select correct options)

  1. Select Alias tables, Set the User Variable Options
  2. Select the workflow options (such as show Planning Units that are not started), Enable e-mail notifications for themselves
  3. Set the display and printing options
  4. All of the above

Answer : D

 
 
43) Which statement is true about webform cells?

  1. A shaded cell is available for data entry, a black cell is read-only and a green cell contains supporting details
  2. A yellow cell is available for data entry, a green cell is read-only and a shaded cell contains supporting details
  3. A yellow cell is available for data entry, a shaded cell is read-only and a green cell contains supporting details
  4. All are incorrect

Answer : C

 
 
44) Which 2 Business Rules are automatically attached to all webforms when using a multi currency application?

  1. Calculate Form and Calculate Currencies
  2. Curr Calc and HspcrTB
  3. HspcrTB and HspcrTT
  4. Calculate Application and Calculate Currencies

Answer : A

 
 
45) Where would you enable the Run on Save option for a Business Rule?

  1. In EAS: Open a Business Rule and go to the Properties tab
  2. In the HBR Graphical Designer: Edit a Business Rule – Task – Manage Options
  3. In Planning web: Select Edit Weform – Business Rules tab – Select a Business Rule and click Properties
  4. None of the above

Answer : C

 
 
46) SET UPDATECALC turns on intelligent calculation. Which 2 statements are true regarding SET UPDATECALC?

  1. When SET UPDATECACLC is ON, Essbase calculates all data blocks, regardless of whether they have been updated
  2. The default setting is OFF
  3. When SET UPDATECACLC is ON, Essbase calculates only blocks marked as dirty
  4. B & C

Answer : D

 
 
47) Business Rules can be run from: (Select correct options)

  1. A batch file, Planning Web
  2. Smart View, EAS
  3. ESSCMD
  4. All of the above

Answer : D

 
 
48) In order to validate a Business rule against a Planning location, you must log on to the EAS console as:

  1. EAS admin
  2. Essbase admin
  3. Planning admin or Interactive user

Answer : C

 
 
49) In order to optimise calculations:

  1. Dimensions should be ordered from the largest dense to the smallest dense and from the smallest sparse to the largest sparse
  2. The Accounts dimension should be placed first, the Time Period dimension second
  3. The Entities dimension should be placed first, the Time Period dimension second
  4. A & B

Answer : D

 
 
50) Identify the three true statements about attribute dimensions in Planning.
A. Planning
B. EPMA
C. ODI
D. LCM
E. Calculation Manager
F. EAS
G. FR Studio

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

Answer : C




 
51) Planning administrators can access which four administration tools via the EPM Workspace?
A. Planning
B. EPMA
C. ODI
D. LCM
E. Calculation Manager
F. EAS
G. FR Studio

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

Answer : C

 
 
52) SCENARIO: User A just entered information into a data form and is unable to launch a needed
business rule. As the administrator, what must you do to solve this issue?

  1. Have User A launch the business rule from Analytic Administration Services
  2. Assign launch privileges to User A
  3. Have User A restart all running services
  4. (None of the above)

Answer : B

 
 
53) Which options are specified when creating Analytic Services data load rules?

  1. File delimiters, Associated Outline
  2. Interface table mappings, Column fields and replace text strings
  3. Member names to column fields mappings
  4. All of the above

Answer : D

 
 
54) How many user variables can you set up for each dimension?

  1. 0 (none)
  2. 3
  3. Unlimited
  4. 10

Answer : C

 
 
55) In Smart View for Office – before you refresh a worksheet you activate the display option to
suppress #Missing values. When you refresh your worksheet, Analytic Services returns:

  1. Rows with data only and all columns
  2. Rows and columns with data only
  3. Rows with null values only
  4. None of the above

Answer : A

 
 
56) If a dimension is missing in your data source, what does Analytic Services do when you load the
data?

  1. Analytic Services automatically loads data to the top level in the missing dimension.
  2. Analytic Services does not load any data.
  3. Analytic Services loads data only if your rules files specifies the missing dimension.
  4. None of the above

Answer : C

 
 
57) You can use which formulas in business rules?

  1. Pro Rata, Units-Rates, Variable, Custom
  2. Pro Rata, Units-Rates
  3. Custom, Dimension, Conditional
  4. None of the above

Answer : A

 
 
58) Which option to be used to Delete all members of the load dimension before load

  1. /T
  2. /R
  3. /-R
  4. /O

Answer : B

 
 
59) Which option to use for performing Cube Refresh post metadata Built

  1. /R
  2. /T
  3. /C
  4. /O

Answer : C

 
 
60) We can Load Metadata using Outline Load Utility for Account & Scenario in 1 File in single load

  1. Yes
  2. Not allowed
  3. Use /O Option
  4. Use /R Option

Answer : B




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

  1. 0
  2. 5
  3. 5
  4. 25

Answer : A

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

  1. 0
  2. 25
  3. 5
  4. 5

Answer : A

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

  1. Create Users/Groups
  2. Assign Read/Write access

 

  1. Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access

 

  1. Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access
  2. Assign access to web forms and business rules

 

  1. Create Users/Groups 2.Assign Approvals Roles 3.Assign Read/Write access
  2. Assign access to web forms

Answer : B

 
 
64) When using the “Grid Spread” feature in Planning what does “Fill” spread type mean ?

  1. Spreads the value proportionally, based on the existing values in the target cells
  2. Spreads the values evenly among the target cells
  3. Replaces the value in all target cells
  4. Spreads the value proportionally, based on the factor called “Fill”

Answer : C

 
 
65) 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. Weekly, Monthly, Quarterly, Yearly, Custom
  3. Monthly, Quarterly, Custom
  4. Monthly, Quarterly, Weekly

Answer : C

 
 
66) Which property is required to be set to enable an application for Offline Planning ?

  1. ENABLE_FOR_OFFLINE_USAGE
  2. ENABLE_OFFLINE_USAGE
  3. ENABLE_FOR_OFFLINE
  4. ENABLE_OFFLINE_USE

Answer : C

 
 
67) The outline and security structure of a Planning application are stored in _________

  1. Essbase
  2. EPMA Relational Repository
  3. Planning App Relational Repository
  4. EPM Foundations Relational Repository

Answer : C

 
 
68) Hyperion Planning audit trail is logged in __________ table

  1. hsp_audit_records
  2. hsp_object
  3. hsp_pm_states
  4. hsp_uda

Answer : A

 
 
69) Migrate launch access permissions on business rules and their projects from Business Rules to Calculation Manager business rules in Planning using _______________ utility

  1. HBRSecurity
  2. HBRMigrateSecurity
  3. MigrateSecurity
  4. MigrateHBRSecurity

Answer : B

 
 
70) Which property in planning can be used to specify which data type prevails when an intersection has conflicting data types ?

  1. Performance Order
  2. Evaluation Order
  3. Resolve Conflict Order
  4. Evaluate Data Type Order

Answer : B




 
71) Form definitions can be moved between Planning applications from Development to UAT using ______________

  1. FormDefUtil
  2. FormDefUtility
  3. FormDefinitionUtility
  4. FormDefinitionUtil

Answer : A

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

  1. Members defined on the data form
  2. Business Rules security access privileges
  3. Essbase security filters
  4. Business Rules Basic User Role

Answer : A

 
 
73) What are valid data types for the Accounts dimension? Select all that apply.

  1. Currency
  2. Non-currency
  3. Percentage

 

  1. Currency
  2. Non-currency
  3. Percentage
  4. Saved Assumption
  5. Text
  6. Smart List
  7. Date

 

  1. Currency
  2. Non-currency
  3. Percentage
  4. Saved Assumption
  5. Smart List
  6. Date

 

  1. Text
  2. Smart List
  3. Date
  4. Currency

Answer : C

 
 
74) Using Copy Data feature planning administrators can copy ___________

  1. Account annotations and planning unit annotations
  2. Planning unit annotations
  3. Data values from one source to target intersections,account annotations,supporting details and cell text
  4. Account annotations, Cell text and planning unit annotations

Answer : C

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

  1. HSP_UDF
  2. HSP_NOLINK
  3. HSP_NOCALLXREF
  4. HSP_NOLINKTOXREF

Answer : B

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

  1. Send email to all users
  2. Check with server team to find logged in users having ongoing sessions and send them email
  3. Use broadcast messaging feature
  4. Use broadcast alert feature

Answer : C

 
 
77) Select the incorrect event that do not happen during refreshing a planning application

  1. Security filters are updated
  2. Planning application is restructured
  3. UDAs are not added to the planning application
  4. Additions or changes to alias tables and their associations to dimensions or members are

Answer : C

 
 
78) What does “Validate Limits” mean while refreshing security filters in planning?

  1. Validate that the size of security filters does not exceed the Essbase limit of 128 KB per row
  2. Validate that the size of security filters does not exceed the Essbase limit of 64 KB per row
  3. Validate that the size of security filters does not exceed the Essbase limit of 32 KB per row
  4. Validate that the size of security filters does not exceed the Essbase limit of 16 KB per row

Answer : B

 
 
79) If you load a parent member that is enabled for dynamic children and its child members
during the same import __________________________________

  1. the child members are loaded as normal members as the database must be refreshed to create the placeholders in Essbase
  2. the child members are loaded as dynamic members
  3. the child members are not loaded as the database must be refreshed to create the placeholders in Essbase
  4. an error is encountered

Answer : A

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

  1. 20
  2. 21
  3. 26
  4. 60

Answer : A




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

  1. 25
  2. 22
  3. 27
  4. 50

Answer : B

 
 
82) Account A1 is tagged as Expense type. How would the variance reporting work for this ?

  1. The actual value is subtracted from the budgeted value to determine the variance
  2. The actual value is added to the budgeted value to determine the variance
  3. The budgeted value is subtracted from the actual value to determine the variance
  4. The budgeted value is added to the actual value to determine the variance

Answer : A

 
 
83) Statistical accounts defined in Planning should be ideally tagged as __________ account type

  1. Revenue
  2. Expense
  3. Saved Assumption
  4. Assets

Answer : C

 
 
84) Which dimensions are considered to set which plan types the members’ children has access?

  1. Entity and Account
  2. Entity and Period
  3. Account and Period
  4. Account and Year

Answer : A

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

  1. Ask the ERP COA to align with Budgetary reporting requirements in terms of higher nodes.
  2. Build an alternate hierarchy conforming with budgetary reporting standards.
  3. Not possible in planning.
  4. Build a separate ASO reporting application

Answer : B

 
 
86) Select the correct event that  happen during refreshing a non-currency planning application

  1. Dimension and member changes are pushed to Essbase
  2. Cell text and supporting detail changes are pushed to Essbase
  3. Data changes are pushed to Essbase
  4. Security filters for dimensions and members are recreated

Answer : A

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

  1. 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
  2. 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
  3. 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
  4. 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

Answer : B

 
 
88) 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

  1. Maxl
  2. Calc Script
  3. HBR
  4. HBR Sequence

Answer : A

 
 
89) Smart List information for a Planning application is stored in ___________

  1. Essbase
  2. HSP_ENUMERATION table in Planning repository
  3. HSP_ENUMERATION and HSP_ENUMERATION_ENTRY table in Planning repository
  4. HSP_OBJECT and HSP_ENUMERATION table in Planning repository

Answer : C

 
 
90) What happens when you exclude a planning unit from planning budget approval process ?

  1. a ) All associated annotations and history are discarded
  2. b) Planning unit status is returned to Not Started state

 

  1. a ) All associated annotations and history are discarded
  2. b) Planning unit status is returned to Not Started state
  3. c) Owner is set to No Owner
  4. d) Data values are retained

 

  1. a ) All associated annotations and history are discarded
  2. b) Planning unit status is returned to Not Started state
  3. c) Data values are retained

 

  1. a ) All associated annotations and history are discarded
  2. b) Planning unit status is returned to Not Started state
  3. c) Owner is set to No Owner

Answer : B




 
91) When Workforce Planning module is enabled which dimensions are available with the package ?

  1. Account, Entity, Employee, Scenario, and Version
  2. Account, Entity, Employee, Scenario, Version, Period
  3. Account, HR Org, Employee, Scenario, Version, Period
  4. Entity, Employee, Scenario, Version, Period

Answer : A

 
 
92) A planning application was restored from backup but it is not available to be selected from EPM workspace. Why ?

  1. Restoration was not correctly done
  2. Backup was corrupt
  3. Foundation Services not working correctly
  4. The coupling between planning and Shared Services is lost. There is a need to register the application with Shared Services from within Planning.

Answer : D

 
 
93) A user has abnormally exited the planning application – How does the Planning Admin unlock the app ?

  1. Using HspUnlockApp Utility
  2. Restarting the Planning Services
  3. Restarting the Application Server
  4. Using HspUnlockPlnApp Utility

Answer : A

 
 
94) Company ABC  with 150000 employees wants to implement employee level planning using WFP module. A an EPM consultant what would be your take ?

  1. No problems we can do it.
  2. Well, I’ve doubts on the model you are trying to implement- but lets start off and we will take care.
  3. Its not practical to use WFP for your organization and that too on employee based mode – sorry.
  4. 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.

Answer : D

 
 
95) Users are entering Supporting details from planning web form but they are not getting saved. Which planning property is required to be checked here?

  1. JDCB_MAX_CONNECTIONS
  2. JDCB_MIN_CONNECTIONS
  3. SUBST_VAR_CACHE_LIFETIME
  4. SUPPORTING_DETAIL_CACHE_SIZE

Answer : D

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

  1. Admin tagged the account but didn’t refresh the database
  2. Admin should try “Weighted Average – Actual_365” as the period dimension has been customized
  3. This can be done with standard monthly calendar that rolls up to four quarters
  4. Period dimension should be customized to “daily” in order for this to take effect.

Answer : C

 
 
97) 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

  1. Expense
  2. Revenue
  3. Assets
  4. Expense and Assets

Answer : A

 
 
98) 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

  1. Create a Maxl script to load data.
  2. Create a EPM workspace job to call the Maxl script and pass the parameters.
  3. Import the executable .sh file as job and configure the front end jsp to run for this job.
  4. Provide necessary access to the budget admin

 

  1. Create a Maxl script to load data.
  2. Create a shell script to call the Maxl script with required parameters.
  3. Create a EPM workspace job to call the shell script and pass the parameters.
  4. Import the executable .sh file as job and configure the fro

 

  1. Create a shell script with required parameters.
  2. Create a EPM workspace job to call the shell script and pass the parameters.
  3. Import the executable .sh file as job and configure the front end jsp to run for this job.
  4. Provide necessary access to the budget admin.

 

  1. Create a Maxl script to load data and call it from EPM workspace via an EPM workspace job.
  2. Provide necessary access to the budget admin.

Answer : B

 
 
99) Choose the most correct set of events that may trigger a different promotional path to be followed in planning workflow

  1. a)Exceeding or missing certain expense boundaries b)Current owner returns the budget to the previous owner for additional informationc)Current owner requests help from an authorized user who is not part of the promotional path
  2. 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
  3. Exceeding or missing certain expense boundaries
  4. Current owner requests help from an authorized user who is not part of the promotional path

Answer : A

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

  1. Run a business rule to change the employee’s status.
  2. Change the employee’s status on a data form using the Smart List drop down.

 

  1. Run a business rule to change the employee’s status.
  2. Change the employee’s status on a data form using the free form text measure.

 

  1. Run a business rule to change the employee’s status.
  2. Change the employee status attribute association in the Employee dimension.

 

  1. Run a business rule to change the employee’s status.
  2. Delete the employee from Workforce Planning.

Answer : A




 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz