Q1. A Planning Unit has a status of First Pass; what two user types can input data? 

A. Anyone with write access to the planning unit 

B. Anyone with write access to the planning application 

C. Anyone with read or write access to the planning unit 

D. The owner of the planning unit 

E. The administrator 

View Answer

Q2. Identify the two statements about the Planning Import security utility. 

A. Imports Planning application access for users and groups 

B. Imports users and groups into Planning 

C. Requires the source text file to be named PLANSECFILE.txt 

D. Can be scheduled to run nightly using an encrypted password 

E. Clears existing security definitions by default before the import takes place 

View Answer

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

View Answer

Q4. Identify the three true statements about attribute dimensions in Planning. 

A. Aliases are supported for attribute members. 

B. Consolidation properties are supported for attribute members. 

C. Hierarchies are supported for attribute dimensions. 

D. Only Text attributes are supported. 

E. Text, Boolean, Numeric, and Date attributes are supported. 

View Answer

Q5. Identify the three characteristics of the Scenarios dimension. 

A. Security can be assigned to members of the Scenario dimension. 

B. It allows the administrator to assign valid periods for data entry 

C. It allows bottoms up or target planning 

D. Exchange rate tables are tied to the Scenario dimension. 

E. One member in the scenario dimension may be valid for Plan Type. 

View Answer

Q6. Identify the one Planning component that is not accessible over the Web. 

A. Dimension Editor for Planning 

B. Shared Services 

C. Exchange Rates Definition 

D. Planning Utilities 

E. Create and Manage Database Options 

F. Create Data Sources 

View Answer

Q7. Identify two true statements about the DATAEXPORT calc script command. 

A. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database. 

B. DATAEXPORT only exports level zero data. 

C. DATAEXPORT only exports to flat files. 

D. DATAEXPORT only exports entire data blocks. 

E. DATAEXPORT is faster than Essbase Report. 

View Answer

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

View Answer

Q9. What are the correct predefined types of base time periods that can be established when creating the calendar in a planning application? 

A. Weekly, Monthly, Quarterly, Custom 

B. Monthly, Quarterly, Custom 

C. Monthly, Quarterly, Weekly 

D. Weekly, Monthly, Quarterly, Yearly, Custom 

E. Only Custom periods are possible. 

View Answer

Q10. You have the following design requirement: You need to track customer status For a sales planning application. Valid options for customer status include: Active, Inactive, Out of Business. Customer status can change on a month-by-month basis. 

What is the best way to build Customer Status into the Planning application? 

A. Attribute dimension 

B. Varying attribute dimension 

C. Smart List 

D. Free Form Text 

E. Alternate hierarchy 

View Answer