Q1. Identify the three true statements about attribute dimensions. 

A. Planning supports hierarchies and aliases for attribute dimensions. 

B. Planning supports all attribute types (for example. Boolean, Date, Text). 

C. Planning supports varying attributes (where an attribute can vary over one or more other dimensions). 

D. Attribute dimensions can be assigned to dense dimensions. 

E. Attribute dimensions may only be assigned to one base dimension. 

View Answer

Q2. Name the valid ways to create blocks in an underlying Essbase database. Select all that apply 

A. Copy data 

B. Load data 

C. Create block on Equation 

D. Aggregate data 

View Answer

Q3. You are designing a form for fast retrieval speed. Assuming a plan type with two dense dimensions and four sparse dimensions, what is the optimal layout? 

A. Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns 

B. Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV 

C. Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV 

D. Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns 

E. The layout of sparse and dense dimensions has no impact on form performance; only the number cells on a data form impacts form performance. 

View Answer

Q4. Identify the two true statements about Enterprise performance Management Architect. 

A. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications. 

B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in 

11.1.1.3. 

C. You can create Planning, TM, Essbase, and FDM applications in EPMA. 

D. Data can be shared from a Planning application to an FM application within EPMA. 

E. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases. 

F. In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet) 

View Answer

Q5. 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. 

View Answer

Q6. 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 

View Answer

Q7. Identify three key benefits of the Planning solution. 

A. Standardized data forms for plan data entry available both for the Web and in Excel 

B. One tool to budget and forecast as well as provide reporting for very detailed Actuals Information 

C. Central repository of business rules that can be run by end users to calculate plan data 

D. Detailed security down to the cell level 

E. Flexible solution customizable for almost any kind of budgeting and forecasting process 

View Answer

Q8. Which three components can be changed after the creation of the Planning application? 

A. Number of years 

B. Names of plan types 

C. Number of plan types 

D. Initialization of WFP or CapEx Planning modules 

E. Weekly distribution spread 

F. Year Dimension Name 

G. Default Currency 

View Answer

Q9. You've created an EAS business rule and assigned it to the data form but an end user can't see it. What are two valid reasons? 

A. The user doesn't have the Launch Business Rules role in Shared Services. 

B. The user hasn't been assigned Validate or Launch Privileges in EAS. 

C. The location for the Business Rule hasn't been defined. 

D. The user hasn't been assigned access to the Business Rule in the Planning Web client. 

View Answer

Q10. You have a new Planning administrator to manage the Capital Expenditure application. He will assign security for the application as well as maintain dimensions in EPMA, Business Rules in Calculation Manager, and load data via Essbase rules files. He will not need access to other applications. Choose the two valid roles that will address part or this entire requirement. 

A. Administrator for the CapEx application 

B. Administrator for the Planning Server 

C. Provisioning Manager for the CapEx application 

D. Planning Calculation Manager for the CapEx application 

E. Dimension Editor for the CapEx dimensions 

F. Application Manager in Essbase for the CapEx dimensions 

View Answer