Based on the following design: Plan type 1: Summary Plan type with all Accounts by Entity Plan type 2: Sales Plan type with Gales 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 I 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 HSP Properties file for the application before you click Create during the application creation process.
Answer:
A,D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
0/ 1000
Question 2
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
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
None
Discussions
0/ 1000
Question 3
Identify the correct set of required dimensions for Planning. 1- Account 2- Entity 3-Version 4-Years and Periods combined into one dimension 5-Scenario 6- Minimum one user-defined dimension
A.
1, 2,3,4,5
B.
1,2,3,5
C.
1, 2,3,5,6
D.
1, 2, 3,4,5,6
Answer:
A
User Votes:
A
50%
B
50%
C
50%
D
50%
None
Discussions
0/ 1000
Question 4
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:
A,B,C,D,E,F
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
None
Discussions
0/ 1000
Question 5
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 FPMA, 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:
D,E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 6
Identify the two true statements about Enterprise performance Management Architect.
A.
If you decide to implement EPMA, all Planning applications must be f PMA-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 FPMA.
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),
Answer:
C,D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 7
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.
Answer:
A,E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 8
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
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 9
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 member o, 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:
F
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 10
Identify the true statements regarding Supporting Detail. 1-Importing Supporting Detail from Excel is supported. 2-Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible 3-Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy. 4-Supporting Detail can be viewed using the Smart View Add-in Essbase Provider. 5-Supporting Detail is stored in Essbase.
A.
1, 2,3,4,5
B.
1,3,4,5
C.
1, 4, 5
D.
2, 3
E.
3
F.
2
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 11
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:
E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
0/ 1000
Question 12
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:
B,D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
0/ 1000
Question 13
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:
A,B,D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
0/ 1000
Question 14
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:
A,B,E,F
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
G
50%
None
Discussions
0/ 1000
Question 15
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 What is the block size in bytes?