Q1. Product status is a data element you need to include in your Planning application. Each product will have a product status that can vary over time. You will use product status in calculations and will need to report sales by product status and across products in a cross tab format.
What is the best way to meet all of these requirements?
A. Define Product Status as a Smart List.
B. Define Product Status as a Separate Dimension.
C. Define Product Status as an Attribute.
D. Define Product Status as a Varying Attribute.
E. Define Product Status as an alternate hierarchy in the Product dimension.
Answer: C
Q2. Given the following:
Measures (Dense): 40 stored members, 50 total members
Time (Dense): 17 stored members, 17 total members
Scenario (Dense): 2 stored members, 5 total members
Market (Sparse): 100 stored members, 100 total members
Product (Sparse): 500 stored members, 550 total members
How many potential blocks could be created?
A. Potential Blocks = 40 * 17*2
B. Potential Blocks = 40* 17*2*8
C. Potential Blocks = 100 * 500
D. Potential Blocks = 100 * 500 * 8
E. Potential Blocks = 100 * 550
F. Potential Blocks = 100 * 550 * 8
Answer: C
Q3. Identify the two true statements assuming you are working with a single application with multiple plan types.
A. A user-defined custom dimension may exist in one plan type but not the other plan types.
B. A user-defined custom dimension may have members in one plan type but not the remaining plan types.
C. All members in the entity dimension must exist in all plan types.
D. All members in the accounts dimension must exist in all plan types.
E. All periods must exist in all plan types.
Answer: AE
Q4. What are two user interfaces to Planning data forms?
A. EPM Workspace
B. Excel Add-in
C. Smart View Essbase Provider
D. Smart View Planning Provider
E. Planning ADM Driver for FR
Answer: AD
Q5. 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
Answer: D
Q6. What four functions can Administrators use the Copy Data feature In Planning to do?
A. Copy data values from one dimensional intersection to another dimensional intersection.
B. Copy planning unit annotations.
C. Copy supporting detail.
D. Copy cell text.
E. Copy account annotations.
Answer: ACDE
Q7. Identify two ways that Essbase data load rules cannot manipulate source data files.
A. Select or reject records based on certain criteria.
B. Flip the sign for records with a certain member tagged with a comment.
C. Split or join columns in a source.
D. Find and replace manipulations on source records.
E. Map data based on an external table.
Answer: CE
Q8. As a Planning end user, you need to add additional commentary to your plan, documenting assumptions and other notes. What are the six available options to add this information?
A. Supporting detail
B. Planning unit annotations
C. Cell text
D. Free form text (if defined by your Planning administrator)
E. Smart Lists (if defined by your Planning administrator)
F. Attach a document to a data form from Workspace (if enabled by your Planning administrator)
G. Financial Reporting Annotations in a Financial Reporting document (against the Planning application)
Answer: ABCDFG
Q9. Identify the three true statements about the CapEx Planning module.
A. Is a prebuilt plan type focused on capital expense related planning
B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security
C. Can be initialized within an existing Planning application
D. Can be created as a stand-alone application
E. Because planning limits an application to three plan types, Capex Planning must be the third plan type.
Answer: ABC
Q10. Why is the Create Blocks function in calc scripts and Business Rules important in Planning?
A. Data may not exist for the combination of dense members so you have to create the block before calculating the data value for the block.
B. Data may not exist for the combination of sparse members so you have to create the block before calculating the data value for the block.
C. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block.
D. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block.
Answer: D