Q1. Assuming you have a Period dimension with calendar months rolling to quarters to total years. If you assign the property Time Balance Last to the "Headcount" account member, what will user see for Q1?
A. January's value
B. March's value
C. The total of January+February +March
D. The average of January + February + March
Answer: B
Q2. You are designing the storage properties for your Planning application. What two design principles should you follow related to the dynamic calc storage property?
A. Dynamically calculated members should roll up to stored members.
B. You cannot calculate and store dynamic calculated members in calc scripts and business rules.
C. Consider dynamic calc members on sparse parents with 100 t children.
D. Tagging upper-level members of sparse dimensions can reduce block size.
E. If you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.
F. Consider Dynamic Calc and Store over Dynamic Calc.
Answer: BE
Q3. Assuming EAS Business rules, a user cannot see a business rule on a data Form. What are three possible causes?
A. The business rule has not been assigned to the data form.
B. The business rule was created for another plan type.
C. The valid locations have not been defined for the business rule.
D. The valid locations have not been defined for the data form.
E. The Validate and Launch privileges have not been granted for the business rule.
F. The Validate and Launch privileges have not been granted for the data form.
Answer: ACE
Q4. 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?
A. Members defined on the data form
B. Planning Metadata security
C. Business Rules security access privileges
D. Essbase security filters
E. Business Rules Basic User Role
Answer: A
Q5. What option contributes to making an Enhanced Calc Script more flexible than a native Essbase Calc Script?
A. Run on Save
B. @CALCMODE function
C. Run time prompts
D. Can be run over the web
E. Substitution Variables
F. Custom Defined Functions
Answer: C
Q6. Identify the true statements regarding Supporting Detail. Select all that apply.
A. Importing Supporting Detail from Excel is supported.
B. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible
C. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy.
D. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider.
E. Supporting Detail is stored in Essbase.
Answer: ACDE
Q7. Identify the two true statements with regard to Versions and Scenarios.
A. Versions control data entry based on time periods set by the administrator.
B. There is only one Version to one Scenario.
C. Versions allow several "what-if" Scenarios.
D. Users must have the same security settings in the Version dimension as they have in the Scenario dimension.
E. Versions can be top down or bottom up.
Answer: CD
Q8. 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?
A. Run a business rule to change the employee's status.
B. Change the employee's status on a data form using the Smart List drop down.
C. Change the employee's status on a data form using the free form text measure.
D. Change the employee status attribute association in the Employee dimension.
E. Delete the employee from Workforce Planning.
Answer: AB
Q9. Identify the three true statements about weekly distribution.
A. For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify.
B. The only valid weekly distribution options are 445, 454, and 544.
C. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks.
D. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.
E. Weekly distribution determines how data entered into summary periods should spread to its base periods.
Answer: ACE
Q10. Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension. Identify the three true statements about deleting members from a Planning application.
A. You must delete members one by one.
B. You must delete a reference to a member from all data forms before deleting it from the dimension.
C. In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.
D. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
E. A database refresh is required after deleting members from the Entity dimension.
Answer: BDE