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

View Answer

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

View Answer

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

View Answer

Q4. 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) 

View Answer

Q5. Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel? 

A. Open a data form and submit data. 

B. enter supporting detail and cell text. 

C. Run business rules. 

D. enter planning unit annotations. 

E. Perform workflow tasks. 

View Answer

Q6. You are designing a new Planning application. Which two requirements dictate multiple plan types in a single Planning application? 

A. Multiple currencies are required. 

B. Currency rates must be kept in a separate database. 

C. Sales are planned by product and channel, and salary expenses are planned by position. 

D. Security is applied to the Entity dimension but can differ for users for accounts "sales" and "expenses". 

E. You have decided to implement the Capital Expense planning module in addition to PSL budgeting. 

F. Data cannot be shared across the Organization dimension. 

View Answer

Q7. What are valid data types for the Accounts dimension? Select all that apply. 

A. Currency 

B. Non-currency 

C. Percentage 

D. Saved Assumption 

E. Text 

F. Smart List G. Date 

View Answer

Q8. Identify the correct set of required dimensions for Planning. 

A. Account 

B. Entity 

C. Version 

D. Years and Periods combined into one dimension 

E. Scenario 

F. Minimum one user-defined dimension 

View Answer

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

View Answer

Q10. Based on the following design: 

Plan type 1: Summary Plan type with all Accounts by Entity 

Plan type 2: Sales Plan type with Sales by Product by Entity 

Plan type 3: Salary Plan type with Salary Expense by Employee by Entity 

You need to get Sales data to the Summary plan type. Identify the two true statements about sharing revenue data between the sales plan type and the summary plan type. 

A. Planning will build in @XREF calculations in a calc script by default to share data between plan types. 

B. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type. 

C. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated. 

D. A calc export script on the source database with the DATAEXPORT command could be used to export data out of the revenue plan type and calc import script on the target database with the DATAIMPORT command could be used to import the data file to the summary plan type. 

E. To disable the building of @XREF, update the HSPProperties file for the application before you click Create during the application creation process. 

View Answer