SAP C_EPMBPC_11 SAP Certified Application Associate – SAP Business Planning and Consolidation 10.1 and 11.0 Online Training
SAP C_EPMBPC_11 Online Training
The questions for C_EPMBPC_11 were last updated at Dec 20,2024.
- Exam Code: C_EPMBPC_11
- Exam Name: SAP Certified Application Associate - SAP Business Planning and Consolidation 10.1 and 11.0
- Certification Provider: SAP
- Latest update: Dec 20,2024
You use an account-by-product report and want to drill down on parent accounts for one product at a time as in the attached screenshot .
What do you need to select to achieve this drilldown behavior?
- A . ‘Keep I Exclude on Single Member’
- B . ‘Expand Collapse on Single Member1
- C . ‘Member and Descendants’
- D . ‘Member and Children1
Company D owns 91% of A, 51% of B, and 49% of C .
Which company can use the equity method?
- A . B.
- B . A.
- C . D.
- D . C.
Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for NetWeaver? (1)
- A . Assign a keyword.
- B . Save the Excel workbook locally.
- C . Enable comments in the Application Set parameters.
- D . Enable comments in the Application parameters.
Which properties are required to carry out currency translation for legal consolidation? (2)
- A . RATE_PERIOD
- B . FX_SOURCE_CATEGORY
- C . REPORTING
- D . MD
You EPM Report is enabled to send data and comments. You type in a revenue value and a comment in the EPM report and save the data.
Where is the data stored? (1)
- A . The revenue data in a infocube and the comment in a DataStore Object
- B . Both the revenue value and the comment in a Infocube
- C . The revenue data in a infocube and the comment in another database table
- D . Both the revenue value and the comment in a DataStore Object
What rows are displayed in an EVDRE report for the MemberSet ‘SELF.DEP*? (1)
- A . The member as defined within the PageKeyRange and all its dependants
- B . The member as defined within the CurrentView and all its dependants
- C . The member as defined within the PageKeyRange and all its base members
- D . The member as defined within the CurrentView and all its base members
You insert an input-enabled query as a data source in Analysis for Office. You update values and would like to work with data in the planning buffer without storing data persistently in the database
Which standard Analysis for Office methods can you use to accomplish this?
- A . Select the ‘Smart Copy’ button.
- B . Select the’Recalculate" button.
- C . Use the "SAPSetData" formula.
- D . Switch to ‘Display Mode’.
You select a parent in the detailed section of the control definition .
Which option do you choose to ensure that the control will be executed for each member of the selected parent?
- A . Threshold Level
- B . Control Status
- C . Control Level
- D . Breakdown Dimension
A user has measures containing plan and actual data within the columns of a crosstab.
How can you create a dynamic variance using standard Analysis for Office features? Note: There are 2 correct answers to this question
- A . Use a New Line rule type
- B . Use an MS Excel formula.
- C . Use a VB script
- D . Use the Calculation from the Analysis ribbon.
You use the DESTINATION_APP keyword in your script logic.
If the source model contains fewer dimensions that the target, which operator do you use to derive the missing dimensions? 1
- A . *RENAME_DIM
- B . *XDIM_MEMBERSET
- C . *ADD_DIM
- D . *SKIP_DIM