Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. 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.
Answer: ACE
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
Answer: ABC
Q3. You need to build the Entity into your Classic Planning application. You can dynamically build the Entity dimension in the Planning application via: (Select all that apply)
A. Essbase load rules
B. Oracle Data Integrator (ODI)
C. Data Integration Management (DIM)
D. Data Relationship Management (DRM)
E. Outline Load Utility
F. EPMA
Answer: ABCEF
Q4. A planning end user opens a data form and sees a long list of entities in the drop-down list in the Page section. She would like to shorten this list and use the search functionality instead. How can she change the number of members needed on a form to initiate a page dropdown search?
A. Form Management>>Display tab
B. Form Management>> Options tab
C. Preferences>>Database Settings tab
D. Preferences>> Display Options tab
E. This change can only be made by the Planning Administrator.
Answer: D
Q5. 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
Q6. Identify the two true statements about shared members.
A. You can assign a custom attribute value to a shared member.
B. You can define a member formula for a shared member.
C. You can assign security rights to a shared member.
D. There is no limit to the number of shared members that you can create for the base member.
E. Shared members may be defined for Accounts and Entity dimensions only.
Answer: CD
Q7. Identity the true statement about Custom Menus.
A. Custom menus can provide links to data forms, Business Rules, URLs, and Planning preferences.
B. Custom menus require Java scripting knowledge to create.
C. You can assign security to custom menus so that only specific users or groups can see the custom menu.
D. Custom menus are assigned to data forms only.
E. Custom menus are limited to a single list of tasks; you cannot group them into sub categories.
Answer: A
Q8. You need to create a highly formatted, printable Income statement for each store in your company. Each report should be emailed to the store manager at the close of each week (each store has a different store manager). What is the best way to deliver this solution?
A. With Financial Reporting, create a book for each store that contains a P&L for each store and use the book to distribute the reports to store managers via email.
B. With Financial Reporting, create a store P&L and use batch bursting to distribute the report to store managers via email.
C. With Web Analysis, create an income statement that store managers can log in and access.
D. Within Smart View Report Designer, use the Cascade feature to generate and distribute each store income statement via email.
E. Create a Planning P&L Data form and use email notification to send to store managers.
Answer: D
Q9. You are designing a monthly projection Planning application. A starting point projection file is received with the current month data. Data forms, Business Rules, and Essbase data load rules, and reports should always focus on the current projection month.
What is most efficient way to design the components to reduce maintenance each month?
A. Manually update the forms each month and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
B. Manually update the forms each month; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
C. Use the Planning data form utility to update data forms and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
D. Use a "CurMth" substitution variable for data forms, Business Rules, Essbase data load rules, and reports.
E. Use the Planning data form utility to update data forms; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
Answer: E
Q10. Fragmentation in an underlying Planning Essbase database that is caused by what two actions?
A. Delete member from a sparse dimension.
B. Delete member from a dense dimension.
C. Renaming a member.
D. Renaming an alias.
E. Submitting data / deleting data frequently.
Answer: BE
Q11. Identify the three differences between Grid Spreader and Mass Allocate.
A. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
B. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
C. Both M-3CG Allocate and Grid Spreader require special roles in Shared Services.
D. Grid Spreader gives users a "preview" to the spread result before saving whereas Mass Allocate will automatically save results to the server.
E. Both Mass Allocate and Grid Spreader support relational spread.
Answer: ABD
Q12. What four read or write security assignments allow end users to be able to view at least some data?
A. At least one member in the Scenario dimension
B. At least one member In the Version dimension
C. At least one member in the Period dimension
D. At least one member in the Account dimension
E. At least one member in the Entity- dimension
F. If security has been assigned for a Custom dimension, at least one member in the user-defined custom dimension
Answer: ABEF
Q13. 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
Answer: C
Q14. 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
Q15. 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.
Answer: ABD
Q16. 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
Answer: ABDE
Q17. 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
Answer: DE
Q18. 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.
Answer: AE
Q19. 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
Answer: ADF
Q20. 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