Home      Blogs      Blogs        

C_EPMBPC_11- SAP Certified Application Associate- SAP Business Planning & Consolidation 10.1 & 11.0 Interview Questions & Answers

Category: Posted:Jun 01, 2022 By: Serena Josh

Zarantech give outstanding C EPMBPC 11 test dumps to ensure your SAP certification success. So let’s get satrted-

Question #:1 You are working in a BPC Standard System. The users are complaining about a message that the system is offline. What might be the issue?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. The system is saving a new member to a dimension.
  2. TheInfoProvider is set to ‘Load mode’.
  3. The workbook is offline.
  4. A BPC transport is in process.

Answer: C

Question #:2 To run a script logic file in a data manager package, where do you assign it?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. In the REPLACEPARAM property
  2. B. In the TASK MODIFYSCRIPT setting
  3. C. In the SELECTION property
  4. D. In the START_ROUTINE parameter

Answer: C

Question #:3 You imported a transaction data file into an empty model using a data manager package. An hour later, a finance team member brings a new data file that needs to be imported. As you can see in the graphic, the new file has exactly the same records, with two exceptions:

  1. The value of the Benefit Account has increased from 1500 to 1600.
  2. There is a new record for the Direct Labor Account with a value of 160.

Which options can you use to update the data so that the latest flat file and the model have the same data?

Note: There are 2 correct answers to this question. 

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. 

  1. Replace and Clear
  2. Replace
  3. Append
  4. Merge

Answer: A, C 

Question #:4 What are the two modes of transport supported?

There are 2 correct answers to this question Operations

  1. Deletion mode
  2. Normal mode
  3. Inactive mode
  4. Active mode

Answer: A B

Question #:5 When validating the ‘FXTrans.LGF’ file, you get a validation error stating that the currency dimension is missing a property. What property is missing?

Please choose the correct answer.

  1. PARENT_GROUP
  2. B. STORE_GROUP_CURR
  3. C. GROUP_CURRENCY
  4. D. CURRENCY_TYPE 

Answer: D

Question #:6 What is the maximum length of a dimension member ID in the SAP Business Object Planning and Consolidation version for NetWeaver?

Please choose the correct answer. More leverage from IT investments

  1. 32 characters
  2. 20 characters
  3. 500 characters
  4. 255 characters 

Answer:  A 

Question #:7 What all are the benefits related to the member formula

choose the correct answer 

  1. Currency
  2. Digits
  3. Accounts
  4. Consistency 

Answer: D

Question #:8 You want to format your account members dynamically in an EVDRE report. In which column do you have to enter the value ‘NUMBERFORMAT=ACCOUNT.FORMAT’?

Please choose the correct answer. 

  1. USE
  2. PARAMETERS
  3. FORMAT
  4. CRITERIA 

Answer: A 

Question #:9 Which of the following methods does the Shared Query Engine (SQE)use to retrieve data from the database?

There are 2 correct answers to this question. 

  1. Cell query
  2. MDX query
  3. axis query
  4. RSDRI query 

Answer: B, D

Question #:10 How to set The Environment Status

Choose the correct answer. 

  1. Indirect selection
  2. Direct selection 
  3. Log on/ off 
  4. In the Navigation Pane, select your environment.

Answer: D

Question #:11 For which users does the system prevent saving templates to the company folder? (Choose two)

There are 2 correct answers to this question. 

  1. For a team leader with the Manage Template task
  2. For a team leader without the Manage Template task
  3. For a non-admin user without the Manage Template task
  4. For a user with the Primary Admin default function task
  5. For a non admin user with the Manage Template task

Answer:  C E

Question #:12 You are working in a BPC Standard system. Which are the unique settings of the ownership model?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Contribute: Please send the correct answers with reference text/link to [email protected] to get up to 50% cashback. 

  1. Parent-child property
  2. Use as source data
  3. Non-Interco Member
  4. Enable comments

Answer: A, C 

Question #:13 What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rules?

Please choose the correct answer. 

  1. The intercompany AR account
  2. The intercompany AP account
  3. The offset account
  4. The same value as in the destination minority account 

Answer: C

Question #:14 Which of the following dimension type can be used as reference dimensions?

There are 2 correct answers to this question. 

  1. T-Time
  2. D-Audit
  3. S-Subtables
  4. E-Entity
  5. G-Group 

Answer: A E

Question #:15 Which dimensions can you use to configure the “carry-forward business rule”?

There are 3 correct answers to this question. 

  1. Account
  2. Entity
  3. Time
  4. Data Source
  5. Flow 

Answer: A D E 

Question #:16 Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application?

  1. Organize the package list.
  2. Run the data management package.
  3. Download the data file.
  4. Maintain data management.

Answer: B  

Question #:17 Select the correct word for- Where the system writes the result of spread.

Choose the correct answer 

  1. Cell
  2. Row
  3. Column
  4. Destination

Answer: D

Question #:18 Identify the following business rules and functions that are delivered with planning and Consolidation.

There are 2 correct answers to this question

  1. Manual adjustments
  2. Time management
  3. Currency conversion
  4. Account transformation
  5. Retention

Answer: C D

Question #:19 Which data source types are processed by the balance Carry Forward rule?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.

  1. Level
  2. Input
  3. Automatic
  4. Manual

Answer: B, C

Question #:20 What is the best business practice to execute multiple iterations of a budgeting process in BPC?

Please choose the correct answer. 

  1. Create a separate property.
  2. Create a separate dimension member.
  3. Create a separate dimension.
  4. Create a separate application.

Answer: B 

Question #:21 Process for importing flat file data. Select from the following

Choose the correct answer 

  1. Execute planning
  2. Upload the file to the server and preview the data.
  3. Storing files.
  4. Data manager

Answer: B

Question #:22 You have two models: one for Expenses, and another for Sales. Both models have the same Profit center dimension. You would like users to perform reporting on both models as follows: 

In column A: Expense values Blueprint structure

In column B: Profitcenters 

In column C: Sales values 

Which methods can you use to accomplish this requirement? 

Note: There are 2 correct answers to this question. 

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. 

  1. ‘EPMRetrieveData’formulas.
  2. ‘Shared axis’ reporting
  3. The’outerdimension’option.
  4. The repeat row headers property.

Answer: A B 

Question #:23 What is a restriction for BPC validation rules in BPC for NetWeaver?

Please choose the correct answer. 

  1. A BPC validation rule cannot use a BAdI implementation.
  2. Multiple BPC validation rules cannot refer to the same dimension member.
  3. Multiple BPC validation rules cannot be applied to multiple dimension members of a dimension.
  4. A BPC validation rule cannot refer to multiple driver dimensions. 

Answer: D

Question #:24 Which are the following elements responsible for Business Performance Optimization?

There are 2 correct answers to this question

  1. Employee Management
  2. Business Intelligence
  3. Customer Relationship Management
  4. Enterprise Performance Management

Answer: B, D

Question #:25 Business warehouse, Planning, and consolidation Leads to…….?

Please choose the correct answer 

    1. None of the above
    2. Research Development
    3. Enterprise Performance Management
    4. Organizational Development

Answer: C

Question #:26 You are working in a BPC Standard system. Your customer has the following requirements:

.Report with key dates

.Enable comments at the account level

.Track data updates by account

.Calculate KPIs on the fly

What do you configure in your account dimension?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Enable comments
  2. Enable time-dependent hierarchies
  3. Enable dimension member formulas
  4. Enable data audit

Answer:  B 

Question #:27 For which of the following models do you have to create at least two “drivers and rates” type models? Please choose the correct answer 

  1. Ownership 
  2. Standard 
  3. Financial 
  4. Consolidation

Answer: D

Question #:28 What object in SAP BW is an equivalent to an Application in SAP BPC for NetWeaver?

Please choose the correct answer. 

  1. A DataStore Object that contains transactional data
  2. A basic InfoCube that contains transactional data
  3. A MultiProvider that creates a join of different data tables
  4. A real-time InfoCube that contains transactional data

Answer: D

Question #:29 Which dimension type is optional for an Application?

Please choose the correct answer. 

  1. Time type
  2. Account type
  3. Data source type
  4. Category type 

Answer: C  

Question #:30 You are working in a BPC Embedded system.Which objects are needed to run a calculation based on custom HANA SQL?

Note: There are 2 correct answer to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Native HANA table
  2. Function type
  3. Method class
  4. Data foundation

Answer: A B

Question #:31 Which of the following conventions apply to dimension property Ids?

There are 2 correct answers to this question. 

  1. they must contain less than 33 characters
  2. they must contain less than 21 characters
  3. they must begin with a character
  4. they must begin with a number 

Answer: B C 

Question #:32 You are using BPC 11.0 for SAP BW/4HANA.From which object can you create an aggregation level?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. CompositeProviders
  2. InfoCubes
  3. LocalProviders
  4. MultiProviders
  5. AdvancedDataStore Objects

Answer: A B C

Question #:33 Which of the following steps do you need to follow to configure data audit?

Please choose the correct answer. 

  1. activate the collection of data by model
  2. add a parameter to Data Manager packages
  3. add a global parameter in customizing (SPRO)
  4. activate the collection of data by environment 

Answer: A  

Question #:34 Which transaction allows you to access the system_constant.lgf and MDXlib.Igf files in SAP Business Object Business Planning and Consolidation version for NetWeaver?

Please choose the correct answerGo Live Support.

  1. transports(UJBPCTR)
  2. write back runtime parameters (UJRO)
  3. script logic tester(UJKT)
  4. file service(UJFS) 

Answer:  D

Question #:35 Which of the following is possible in the data loading process in BPC for NetWeaver?

Please choose the correct answer. 

  1. Using Visual Basic Script in the Data Manager
  2. Using the download function to move files from the local hard drive to the data file folder
  3. Using a transformation file without a conversion file
  4. Using multiple conversion files for a single dimension without additional coding

Answer: C 

Question #:36 Which of the following dimension types are mandatory for the Financial model type?

Note: There are 3 correct answers to this question. 

  1. Audit
  2. Currency
  3. Intercompany
  4. Category
  5. Time

Answer: B, D, E 

Question #:37 Which function do you use to display a dimension name?

Please choose the correct answer. 

  1. EPMDimensionList
  2. EPMDimensionType
  3. EPMDimensionOverride
  4. EPMDimensionProperty 

Answer: B 

Question #:38 What all are the elements involved in making Analysis Levels

There are 3 correct answers 

  1. Attitude
  2. Tactical
  3. Behavioral
  4. Strategic
  5. Operational

Answer: B D E

Question #:39 For which calculation do you have to use a different implementation method than Business Rules?

Please choose the correct answer. 

  1. Account transformation 
  2. Allocation
  3. Currency conversion
  4. Automatic adjustment

Answer: B 

Question #:40 Which property of the currency dimension is required for currency translation?

Please choose the correct answer. 

  1. GROUP CURRENCY
  2. PARENT GROUP
  3. STORE GROUP CURR
  4. CURRENCY TYPE 

Answer: D 

Question #:41 Find out the options uses to optimize your model for improvement in system performance

There are 2 correct answers to this question 

  1. Charts and tables
  2. Full Optimize
  3. Info graphics
  4. Lite Optimize
  5. Pie charts

Answer: BD

Question #:42 What is the consequence in BPC for NetWeaver when updating the web admin parameters without entering the required parameters?

Please choose the correct answer. 

  1. Nothing
  2. Warnings 
  3. Crashes
  4. Errors

Answer: A

Question #:43 What activities are possible while running a data management package in BPC for NetWeaver?

There are 3 correct answers to this question. 

  1. Importing master data attributes
  2. Importing master data hierarchies
  3. Importing master data descriptions
  4. Importing transaction data
  5. Loading data from InfoProviders

Answer: C, D, E

Question #:44 Running control could include the following steps. Identify them. There are 2 correct answers to this question 

  1. Dimensions
  2. Contents
  3. Review Control data
  4. Hyper links
  5. Run Control 

Answer: C E 

Question #:45 You are testing script logic to perform a loop over months,You save budget data for month 2018.01 to 2018.06.

*XDIM_MEMBERSET CATEGORY=BUDGET

*XIDM_MEMBERSET TIME=%TIME_SET%

*XIDM_MEMBERSET P COSTELEMENT=LABOR

*WHEN P COSTELEMENT

*IS LABOR 

*FOR %COUNTERS%=1,2,3,4,5,6,7,8,9,10,11,12

*REC(EXPRESSION=%VALUE%/12*2,TIME=TMVL(%COUNTER%,%TIME_SET%),CATEGORY=FORECAST)

*NEXT

*ENDWHEN

When this script logic executed. What months receive data?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. 2019.01 to 2019.12
  2. 2018.07 to 2019.06
  3. 2019.01 to 2019.06
  4. 2018.07 to 2018.12

Answer: A 

Question #:46 You want to hardcode a query to run only for the country value’Germany’.Where in the BW Query do you specify’Germany’ as a “Fixed Value”?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Dependencies
  2. Filter
  3. Free characteristics
  4. Conditions

Answer: D

Question #:47 What rows are displayed in an EVDRE report for the MemberSet ‘SELF,DEP’? 

  1. The member as defined within the PageKeyRange and all its base members
  2. The member as defined within the CurrentView and all its base members
  3. The member as defined within the PageKeyRange and all its dependants
  4. The member as defined within the CurrentView and all its dependants

Answer: C 

Question #:48 Which of the following model-specific business rules requires the environment-specific business rules?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

    1. Currency translation
    2. Account-Based Calculations
    3. Eliminations and adjustments
    4. US Eliminations

 Answer: D

Question #:49 Your customer needs a blank input template that allows users to enter product groups as needed and plan revenue for them. The BW Query has product group in the columns, and product in the free characteristics.

When the BW Query is inserted into Analysis for Office, all data rows are blank. How is the BW Query configured?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

    1. Revenue is set to “Disaggregate Difference to Entered Value”.
    2. The query has “New Lines on Every Level” selected.
    3. Product group is set to display based on “Characteristic Relationships”.
    4. The query is set to “Disaggregate to All Valid Combinations”

Answer: A 

Question #:50   What dimension types are mandatory for the Application type Financial? 

(Choose two) There are 2 correct answers to this question.

  1. T–Time
  2. B. D–Audit
  3. C. C–Category
  4. D. I–Intercompany
  5. E. S–Subtable

Answer: A C 

Question #:51 What are the components of Process Template Components?

there are 3 correct answers to this question

  1. Process Monitors
  2. Instance Dimensions
  3. Costs
  4. Flat file control

Answer: A B D

 Question #:52 You are working in a BPC Embedded System.What Options do you have when maintaining members and properties of local dimensions?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Update property values for global members.
  2. Delete global members.
  3. Enable time dependent properties.
  4. Add a member that does NOT exist in a global dimension.

Answer: A D

Question #:53 Which steps are required to use data acccess profiles in BPC Embedded?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Assign authorizations to the user
  2. Set a characteristic to be authorization relevant
  3. Assign authorizations to the environment
  4. Set the model dimensions to be authorization relevant

Answer: A D

Question #:54 Which default function task type always includes Appset maintenanc

Please choose the correct answer. 

  1. System
  2. Administration
  3. Primary
  4. Secondary 

Answer: A

Question #:55 You have automated ownership eliminations by using the BPC business rules and ownership data. Your requirement is to use the same rule for both purchase and equity subsidiaries. The ownership in one of the subsidiaries went from 45 to 55 percent.

What changes should you make in the ownership manager for this subsidiary?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Method is changed to New
  2. PCON is changed to 55
  3. PCON is changed to 100
  4. Method is changed to ‘Holding’

Answer: D

Question #:56 To what destination members is the script logic in the attached figure writing the records?

Please choose the correct answer.

  1. SquareFootage account for all entities
  2. SquareFootage account for all base level entities
  3. LeaseCost account for all base level entities
  4. GlobalOps account for all entities

Answer: C

Question #:57 Which components does BPC Embedded Consolidation use in a Replicated Scenario?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

    1. Exchange Rate InfoProvider
    2. Exchange Rate TCURR tables
    3. VirtualProvider as the Consolidation InfoProvider
    4. CompositeProvider as the Consolidation InfoProvider

Answer: A D

Question #:58 What settings do you need for Source Account to calculate the liability account ‘annual net income’ (ANI)?

  1. Expense, Destination Account = Revenue and ANI, do not reverse sign
  2. B. Revenue and Cost, Destination Account = ANI, reverse sign
  3. C. Revenue and Cost, Destination Account = ANI, do not reverse sign
  4. D. Expense, Destination Account = Revenue and ANI, reverse sign 

Answer: C

Question #:59 Each Work Book contains to work sheets, Identify them

There are 2 correct answers to this question

  1. Info graphics
  2. Report contents
  3. One sheet contains the template
  4. One sheet contains the dynamic formatting
  5. Analysis 

Answer: C D 

Question #:60 You are building an EPM report and would like to leverage local members.What can you use to maintain local members?

Note:There are 3 correct answers to this question.

Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Report editor.
  2. Row axis
  3. Dimension member formulas
  4. Excelformulas.

Answer: A B D

Question #:61 User1 is the parent owner and user2 is the child owner. What happens when user2 sets a work status?

There are 3 correct answers to this question.

  1. If it is set to “Manager”, user1 can post a journal.
  2. If it is set to “Both”, user1 and user2 can post a journal
  3. If it is set to “Manager”, user2 can post a journal.
  4. If it is set to “All”, only user1 and user2 can post a journal
  5. If it is set to “Locked”, neither can post a journal.

Answer: A B E

Question #:62 Which settings do you need to make for the Source Account to calculate the annual net income (ANI) for the liability account?

Please choose the correct answer. 

  1. Revenue and Cost, Destination Account = ANI, do not reverse sign
  2. Expense, Destination Account = Revenue and ANI, reverse sign
  3. Expense, Destination Account = Revenue and ANI, do not reverse sign
  4. Revenue and Cost, Destination Account = ANI, reverse sign

Answer: A 

Question #:63 Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for NetWeaver?

Please choose the correct answer. 

  1. Enable comments in the Application Set parameters.
  2. Assign a keyword.
  3. Save the Excel workbook locally.
  4. Enable comments in the Application parameters

Answer: D

Question #:64 What can you use to prevent the insertion of records into the DataBase in SAP BusinessObject Planning and Consolidation?

Please choose the correct answer. 

  1. work status
  2. data audit
  3. book publication
  4. controls 

Answer: A

Question #:65 What are valid MDX expansion options?

There are 3 correct answers to this question.

  1. SELF
  2. ANY
  3. LEAVES
  4. AFTER
  5. BEFORE

Answer: C D E

Question #:66 Which package groups are delivered by SAP in SAP Business Objects Planning and Consolidation for Netweaver?

There are 2 correct answers to this question.

  1. Financial process
  2. Reporting management
  3. Other function
  4. Data management 

Answer: A D

Question #:67 What all are the options to prevent Data Entry in General.

There are 2 correct answers to this question

  1. Work status
  2. Layouts
  3. References
  4. Read only
  5. Data access profiles

Answer: A E

Question #:68  You have created an EPM report containing ‘Time’ in the columns and ‘Product’ in the rows. You would like to leverage a function to display the hierarchy level for a given product in the rows.

Which EPM functions are used for this purpose?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. EPMMemberProperty
  2. EPMDimensionPropertyValues
  3. EPMLocalMember
  4. EPMDimensionProperty 

Answer: B D

Question #:69 Which business rules are used in the consolidation monitor?

(Choose three) 

  1. Currency translation
  2. US eliminations
  3. Eliminations and adjustments
  4. Global definitions
  5. Account-based calculations

Answer: A C D

Question #:70 You have a business requirement to caluculate 3 bonus amounts based on revenue.

Bonus account 1:10% of revenue

Bonus account 2:5% of revenue

Bonus account 3:2% of revenue

How do you proceed using script logic?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Use a scoping statement for the three bonus accounts.
  2. Use a REC statement for each bonus account.
  3. Use one WHEN ststement and separate the bonus accounts with commas.
  4. Use a WHEN ststementfor each bonus account.

Answer: A  

Question #:71 Which model types are required to consolidate investments?

There are 3 correct answers to this question.

    1. Standard
    2. Financial
    3. Consolidation
    4. Ownership
    5. Exchanges Rates 

Answer: C D E

Question #:72 What currency type dimension is required for consolidation of investment?

Please choose the correct answer. 

  1. transactioncurrency
  2. groups
  3. inputcurrency
  4. rptcurrency 

Answer: B 

Question #:73 Which of the following tasks can you perform using a data manager package delivered by SAP?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.

  1. Export master data to SAP ECC.
  2. Load transaction data from a BW InfoProvider
  3. Load master data and texts from a BW InfoObject.
  4. Execute a BadI.
  5. Export transaction data to a flat file.

Answer: A B D

Question #:74 For the budgeting process, you need to extrapolate a base amount across 12 months with a growth factor of 3%. What modeling function do you use?

  1. SPREAD
  2. WEIGHT
  3. TREND
  4. FORECAST 

Answer: C

Question #:75 You are using BPC 11.0.From which of the following objects can you import data using the “Load Transaction Data from BW InfoProvider” data manager package? 

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. InfoCube
  2. AdavancedDataStore Object
  3. InfoObject
  4. MultiProvider

Answer: C 

Question #:76 You have developed an EPM input form and would like to ensure a validation of cells message box pops up after a user saves data.How can you accomplish this?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Use data validation in the formatting sheet.
  2. Use the dialog option when saving data.
  3. Use ‘Sheet protection’.
  4. Use a custom VBA macro.

Answer: B C

Question #:77 A user tries to connect to a model using the excel interface of the EPM Add-in. However, the model is not available. What could be the issue?

Please choose the correct answer. 

  1. The data access profile is assigned to the user’s team
  2. The task profile is not assigned to the user’s team
  3. The data access profile is not assigned to the user’s team
  4. The task profile is assigned to the user’s team  

Answer: C

Question #:78 The new users interface of the dimension enables to manage a Dimension through distinct pages

There are 3 correct answers to this question 

  1. Environmental approach
  2. Data security
  3. Members maintenance page
  4. The structure dimension
  5. Hierarchical view of the member

Answer: C D E

Question #:79 The Consolidation Monitor displays a blank screen for the current period although the previous period has been displayed properly. What is missing?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Ownership data
  2. Trial balance date
  3. Master data
  4. Exchange rate data

Answer: C 

Question #:80 Your customer wants to load certain accounts with both local and reporting currencies without doing a currency translation.

Which expression in the formula of the business rule for currency conversion can you use to achieve this?

Please choose the correct answer. 

  1. 1
  2. [AS_IS]
  3. [COPYLC]
  4. [NOTRANS]

Answer: B

Question #:81 Where do you change a BPC report to an input schedule?

Please choose the correct answer. 

  1. In the PageKeyRange
  2. In the EVDRE report
  3. In the Web Admin Dashboard
  4. In the workbook options

Answer: D

Question #:82 Which rule type is required if you want to perform consolidation of investment?

Please choose the correct answer. 

  1. Intercompany bookings
  2. Account-based calculation
  3. Elimination and adjustment
  4. US Eliminations 

Answer: C

Question #:83 What solution for uploading master data into BPC for NetWeaver requires customer- specific process types? 

  1. Loading data via a flat file using SAP BW
  2. Loading data via a flat file using BPC Data Manager
  3. Loading data from a SAP BW InfoObject into a BPC dimension using BPC Data Manager
  4. Loading data directly into the dimension member sheet

Answer: C

Question #:84 What is best business practice to execute multiple iterations of a budgeting process in BPC?

Please choose the correct answer. 

  1. Create a separate dimension.
  2. Create a separate application.
  3. Create a separate dimension member.
  4. Create a separate property

Answer: C

Question #:85 Which tasks can you perform using the Consolidation Monitor in BPC embedded?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Run reclassification
  2. Run ownership calculation
  3. Run controls
  4. Run planning function
  5. Run US Elimination

Answer: B C E

Question #:86 Which steps are mandatory if you want to implement the work status?

There are 3 correct answers to this question.

  1. enable data locking in the model 
  2. define the reviewer property in the owner dimension
  3. define at least one hierarchy in the owner dimension
  4. enable data audit for the model
  5. define the owner property in the owner dimension 

Answer: A C E

Question #:87 Which of the following calculations uses only logic script?

Please choose the correct answer.  

  1. Ownership calculation
  2. Reclassification
  3. currency translation
  4. Allocation 

Answer: D

Question #:88 Which function do you use to display a dimension name?

Please choose the correct answer. 

  1. EPMDimensionOverride
  2. EPMDimensionType
  3. EPMDimensionProperty
  4. EPMDimensionList

Answer: B

Question #:89 You are configuring work status in BPC Embedded environment with a Sales InfoProvider.The requirement is to determine the owners via a characteristic that is NOT contained in the InfoProvider.

How can the work status “Locking Dimensions”be determined?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. By using a customer implementation
  2. By using a property
  3. By using a reference dimension
  4. By using an external dimension

Answer: C

  1. Question #:90 You are using BPC 11.0.From which of the following objects can you import data using the “Load Transaction Data from BW InfoProvider” data manager package?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. MultiProvider
  2. InfoCube
  3. InfoObject
  4. AdavancedDataStore Object

Answer: C

Question #:91 How do hierarchies in BPC for Microsoft differ from those in BPC for NetWeaver?

Please choose the correct answer.  

  1. They are time dependent.
  2. They are kept as separate dimensions in the database.
  3. They must be balanced.
  4. They are limited to a total of 12 per dimension.

Answer: B

Question #:92 You use the DESTINATION APP keyword in your script logic. If the source model contains fewer dimensions than the target, which operator do you use to derive the missing dimensions?

Please choose the correct answer. 

  1. *XDIM MEMBERSET
  2. *ADD DIM
  3. *SKIP DIM
  4. *RENAME DIM

Answer: C

Question #:93 Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for NetWeaver?

Please choose the correct answer. 

  1. Enable comments in the Application parameters.
  2. Assign a keyword.
  3. Enable comments in the Application Set parameters.
  4. Save the Excel workbook locally

Answer: A

Question #:94 To run a script logic file in a data manager package, where do you assign it?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. In the START_ROUTINE parameter
  2. In the REPLACEPARAM property
  3. In the TASK MODIFYSCRIPT setting
  4. In the SELECTION property

Answer: D

Question #:95 There are three types of versions available in Business Process Flow Templates: identify

There are 3 correct answers to this question 

  1. Draft
  2. Deployed
  3. Pro-active
  4. BOPC
  5. Inactive

Answer: A B E

Question #:96 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?

Regular Chips Jan

Feb

Mar

Qtr1

Qtr2

Qtr3

Qtr4

Full Year

Sun Style Qtr1

Qtr2

Qtr3

Qtr4

Full Year

Chips Qtr1

Qtr2

Qtr3

Qtr4

Full Year

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Member and Children
  2. Member and Descendants
  3. Expand/ Collapse on Single Member
  4. Keep/Exclude on Single Member.

Answer: D

Question #:97 Which transaction allows you to access the system_constant.lgf and MDXlib.Igf files in SAP Business Object Business Planning and Consolidation version for NetWeaver?

Please choose the correct answer. 

  1. script logic tester(UJKT)
  2. transports(UJBPCTR)
  3. write back runtime parameters (UJRO)
  4. file service(UJFS) 

Answer: D

Question #:98 What are the two deployment scenarios

There are 2 correct answers to this question 

  1. Services only
  2. Development to production
  3. Dispatch only
  4. Only Production
  5. Targets only

Answer: B D

Question #:99 The consolidation monitor displays a blank screen for the current period although the previous period has been displayed properly. What could be the reason for this?

Please choose the correct answer. 

  1. No trial balance exist
  2. No master data exist
  3. No exchange rate records exist
  4. No ownership records exist 

Answer: C

Question #:100 If the FOX formula is:

{Key figure1,#(unit),USD(currency),variable for material group}=

{Key figure2,PC(unit),#(currency),variable for material group}*

{Key figure3,#(unit),USD(currency),variable for material group}.

How is the planning function configured?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Key figure is a field to change.
  2. Material group is a data declaration.
  3. Key figure is a data declaration.
  4. Material group is a field to change.

Answer: C D

Question #:101 Which implementation step is mandatory to set up an on-the-fly KPI calculation?

Please choose the correct answer. 

  1. Add the library file “mdxlib.lgl” to the options sheet of the account member.
  2. Add the “Formula” property to the account member.
  3. Execute a data management package.
  4. Update the “system_constants” file.

Answer: B

Question #:102 Find out the components of Planning and Consolidation

There are 2 correct answers to this question 

  1. Infrastructure layer
  2. Navigation pane
  3. Action pane
  4. Business layer

Answer: A D

Question #:103 Your customer needs a blank input template that allows users to enter product groups as needed and plan revenue for them. The BW Query has product group in the columns, and product in the free characteristics.

When the BW Query is inserted into Analysis for Office, all data rows are blank. How is the BW Query configured?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.

  1. Revenue is set to “Disaggregate Difference to Entered Value”.
  2. Product group is set to display based on “Characteristic Relationships”.
  3. The query has “New Lines on Every Level” selected.
  4. The query is set to “Disaggregate to All Valid Combinations”

Answer: A 

Question #:104 Which function do you use to calculate variances?

Please choose the correct answer. 

  1. EPMComparison
  2. EPMMemberOffset
  3. EPMExecuteAPl
  4. EPMMemberProperty

Answer: A 

Question #:105 When you create a new model from an existing model,which items can be copied?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Transaction data
  2. Journal templates
  3. Control definitions
  4. Data Manager packages

Answer: C D 

Question #:106 Which is not a part of Developmental Process? Identify from the following

Choose the correct answer 

  1. Manage a Drill
  2. Business Content
  3. Naming conventions
  4. Data Flow 

Answer: A 

Question #:107 Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application? 

  1. Download the data file.
  2. Organize the package list.
  3. Maintain data management.
  4. Run the data management package.

Answer: D 

Question #:108 Which dimension type is optional for an Application?

Please choose the correct answer. 

  1. Data source type
  2. Account type
  3. Category type
  4. Time type

Answer: A 

Question #:109 A customer wants to use special exchange rates for only 2 out of 160 entities when doing currency translation.

What dimension and what property do you use for that? 

  1. Account dimension – RATETYPE property
  2. Currency dimension – CURRENCY TYPE property
  3. Entity dimension – FX_TYPE property
  4. Account dimension – ACCTYPE property

Answer: C

Question #:110 What needs to run before ownership elimination?

Please choose the correct answer. 

  1. Currency translation
  2. Account transformation
  3. Intercompany booking
  4. Carry forward

Answer: A 

Question #:111 Identify the factors involved in Business Process Flow

there are 2 correct answers to this question 

  1. Items
  2. Levels
  3. Codes
  4. Costs
  5. Benefits

Answer: D E 

Question #:112 You need characteristics for Real Time Consolidation. Which characteristics are ‘Persistent’?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Audit
  2. Group
  3. Category
  4. Account

Answer: B D 

Question #:113 What is missing in the script logic on the screenshot in BPC for NetWeaver?

Please choose the correct answer. 

  1. Logic for currency type dimension
  2. Logic for entity type dimension
  3. Logic for account type dimension
  4. Keyword %CURRENCY_SET%

Answer: A 

Question #:114 Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for NetWeaver?

Please choose the correct answer. 

  1. System Administrative
  2. Financial Processes
  3. Reporting Management
  4. Data Management 

Answer: C 

Question #:115 You want to create a PD book that contains PDF files by cost center for the current year based on an EPM report , and publish it in the library.

Which of the following steps are required when you create the publication template?

There are 2 correct answers to this question. System Administrative

  1. assign the cost center to the variable members of the publication template
  2. include the cost center dimension in the page axis in the publication template
  3. include the cost center dimension in the fixed keys in the publication template
  4. assign the EPM report to the publication template
  5. assign a time variable to the publication template 

Answer: B C 

Question #:116 Select the correct word for- Where the system writes the result of spread.

choose the correct answer 

  1. Column
  2. Cell
  3. Row
  4. Destination

Answer: D 

Question #:117 Which of the following methods does the Shared Query Engine(SQE)use to retrieve data from database?

There are 2 correct answers to this question. 

  1. MDX query
  2. Axis query
  3. RSDRI query
  4. Cell query 

Answer: A C 

Question #:118 How to reset the consolidation status?

choose the correct answer

  1. All over changes
  2. Changes in master data
  3. Set up changes
  4. Dim list changes

Answer: B 

Question #:119 When you create a new model from an existing model, which items are copied?

Please choose the correct answer. 

  1. transaction data
  2. control definitions
  3. Data Manager Packages
  4. Journal templates 

Answer: C 

Question #:120 Which infoProvider can access data from ACDOCA?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. /ERP/SFIN_R01
  2. /ERP/SFIN_V01
  3. /ERP/SFIN_V20
  4. /ERP/SFIN_M01

Answer: B D 

Question #:121 Find out Step which is not taking part in The Information Gathering Process

Choose the correct answer  

  1. Presentations
  2. Preparations
  3. Enabling EMP
  4. Matching

Answer: C 

Question #:122 For which scenario is it impossible to use the work status?

Please choose the correct answer. 

  1. To track the progress of a planning process
  2. To lock a step in a Business Process Flow
  3. To allow or disallow a user to modify data
  4. To lock a region of data in an Application

Answer: B 

Question #:123 Which calculation uses script logic exclusively? 

  1. Currency Translation
  2. Elimination
  3. Allocation
  4. Reclassification

Answer: C 

Question #:124 You need to calculate ownership using these values.Company D owns 70% of company A and 10% of company B.Company A owns 50% of company B.

Using the group share method,what percentage ownership does company D have of company B?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. 10%
  2. 45%
  3. 60%
  4. 35%

Answer: A 

Question #:125 What implementation step is required to add a new hierarchy for a dimension member?

Please choose the correct answer. 

  1. Insert the hierarchy name into the ‘APPROVALORG’ web application parameter.
  2. Insert the hierarchy name to the ‘TOPDOWN’ web application parameter.
  3. Insert ‘PARENTH2’ into the dimension property list. 
  4. Insert ‘PARENTH2’ column after ‘PARENTH1’ within the dimension member sheet.

Answer: D 

Question #:126 What dimension and value does the Method Based Multiplier determine?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Source flow
  2. Debit flow
  3. Source account
  4. Debit account

Answer: A 

Question #:127 Which of the following values can you use in the destination flow to configure the currency translation business rule?

There are 2 correct answers to this question. 

  1. base level members
  2. blanck
  3. descendents
  4. property values 

Answer: A B 

Question #:128 You execute the following Script Logic Logic1.lgf by running a data manager package, without transferring any further parameters and without using default logic.

*WHEN ACCOUNT

*IS ACCOUNT1

*REC (FACTOR=1.5, ACCOUNT=ACCOUNT2)

*ENDWHEN 

*COMMIT

What is the scope of the calculation?

Please choose the correct answer. 

  1. Only current view
  2. ACCOUNT1 and ACCOUNT2
  3. All data within the database
  4. Only input schedule 

Answer: C 

Question #:129 To add custom dimensions automatically to BPC Optimized structures,what do you use?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Model Extension Tool
  2. BW Modeling Tool.
  3. RTC Modeling Tool.
  4. Planning Application Kit

Answer: B 

Question #:130 You want existing records to be deleted first before writing new records. What option do you choose while running a data management package?

Please choose the correct answer. 

  1. Replace and Clear
  2. Clear and Append
  3. Merge
  4. Clear

Answer: A 

Question #:131 Identify the different dimension types

There are 2 correct answers to this question 

  1. Category
  2. BOSC
  3. Library
  4. Account
  5. Hyperlinks

Answer: A D

Question #:132 In Analysis for Office you have an input-ready query with accounts in the rows and all periods(month)of2019 as well as the totaal for 2019 in the columns. You have a value of ‘1200’ for ‘100’ for JAN to DEC.

You lock the cells for JAN AND FEB and enter’1500’for2019.When you recalculate the data, what happens?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. The total will be changed to 1700
  2. The non-locked cells will update to 150.
  3. The total remains as 1500.
  4. The non-locked cells will update to 130.

Answer: A D

Question #:133 You need to develop a BW query for SAP BPC 11.0. What should you use?

Please choose the correct answer. 

  1. Model Extension Tool 
  2. BW Modeling Tool
  3. BEx Query Designer
  4. RTC Modeling Tool

Answer: B

Question #:134 Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for NetWeaver?

Please choose the correct answer.  

  1. Roles
  2. MultiProviders
  3. Journal Templates
  4. Business Rules

Answer: A

Question #:135 You are using SAP BPC Optimized for SAP S/4HANA.Which InfoProvider stores the comment entered Input-ready query?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Real-Time Info Cube
  2. Datastore Object
  3. Virtual Provider
  4. Composite Provider

Answer: D

Question #:136 What are the steps required to configure controls?

There 3 correct answers to this question 

  1. Enable work status for the model
  2. Work status
  3. Assign security task for control
  4. Managerial drill
  5. Create control sets

Answer: A C E

Question #:137 What information is needed when you configure the interface between EPM office Add-In Exceland Bex query to enable the BW drill through?

There are 3 correct answers to this question Enable work status for the model

  1. The filter IOBJNM VALUE parameters
  2. The technical names of the InfObject
  3. The OKCODE parameter
  4. The technical field names of the Dimensions
  5. The URL of the BEx query 

Answer: A C E

Question #:138 What steps are required to save new members from the member sheet to the database of the admin console?

There are 2 correct answers to this question 

  1. Maintain dimension property.
  2. B. Maintain dimension members.
  3. C. Save to server.
  4. D. Process dimension.
  5. E. Change the flag ‘Take system off-line

Answer: C D

Question #:139 What transaction code allows you to access the ‘system_constants.lgf’ and ‘MDXlib.lgf’ files in BPC for NetWeaver? 

  1. UJ00
  2. UJKT
  3. UJR0
  4. UJFS

Answer: D

Question #:140 How to use a consolidation monitor?

There are 3 correct answers to this question

  1. Consolidation status
  2. Business contents
  3. Administration
  4. Control status
  5. Work status

Answer: A D E

Question #:141 Which of the following interfaces can you use when you define actions using the business process flow templates.

There are 3 correct answers to this question 

  1. Journals
  2. BW Application server
  3. EMP Office Add-in Excel
  4. EPM Office Add-in word
  5. Planning and consolidation administration

Answer: C D E

Question #:142 Which of the following tasks can you perform using the Consolidation Monitor?

There are 2 correct answers to this question. 

  1. run consolidation
  2. run controls
  3. run Data Manager packages
  4. run currency translation
  5. run ownership calculation 

Answer: A D 

Question #:143 What dimensions are used to configure the carry forward business rule?

There are 3 correct answers to this question.

  1. Entity dimension
  2. Account dimension
  3. Time dimension
  4. DataSource dimension
  5. Flow dimension

Answer: B D E

Question #:144 Which properties are required to carry out currency translation for legal consolidation?

There are 2 correct answers to this question. 

  1. STORE_GROUP_CUR in the currency type dimension
  2. RATETYPE in the account type dimension
  3. FX_DIFFERENCE_ONLY in the category type dimension
  4. DIMLIST in the account type dimension
  5. CURRENCY in the entity type dimension

Answer: B E 

Question #:145 You are the administrator on a BPC 11.0 for SAP BW/4HANA system. You need to optimize an Advanced DataStore Object by activating the data. What happens when you do this?

Note: There are 2 correct answers to this question. 

  1. Transaction sequence numbers are closed.
  2. Delta merge is triggered.
  3. Redundant records are aggregated.
  4. Dimensions are optimized.

Answer: B C 

Question #:146 What is displayed in an EVDRE report when ‘Account1, Account2’ is in the PageKeyRange, with entity in the rows and time in columns?

Please choose the correct answer. 

  1. Aggregated data for Account1 and Account2
  2. Account1 and Account2 in separate columns
  3. All Accounts other than Account1 and Account2
  4. Account1 and Account2 in separate rows

Answer: A 

Question #:147 What step is required when setting up Finance or Consolidation Application compared to other Applications? 

  1. Modify Application
  2. Select copy options
  3. Select source Application
  4. Select Application options

Answer: D 

Question #:148 What does a Dynamic Filter do?

choose the correct answer 

  1. ADD-IN
  2. Use members in a referenced cell as filter values.
  3. Just a process
  4. None

Answer: B 

Question #:149 Three types of parameters are used in BO PC, identify them

There are 3 correct answers to this question 

  1. Conceptual parameters
  2. Configuration parameters
  3. Analytical parameters
  4. System Parameters
  5. Functional parameters

Answer: B D E

Question #:150 For which dimension type can you activate a data audit trail for a model?

Please choose the correct answer. 

  1. Account
  2. Category
  3. Time
  4. Entity

Answer: B  

Question #:151 Which object in BW is equivalent to a model in SAP business Object Planning and Consolidation for NetWeaver?

Please choose the correct answer. 

  1. real-time infocube
  2. multiProvider
  3. VirtualProvider
  4. standard infocube 

Answer: A  

Question #:152 You are using BPC E mbedded.In the BPC web client,a user can Access Evironment #1 but not Environment #2.What change is required for the user to access Environment #2?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Add the user to the BPC team.
  2. Add the user to the ‘RSBPC_ID’ authorization object.
  3. Assign a data access profile to the user.
  4. Assign an Analysis Authorization to the Environment.

Answer: A

Question #:153 When using US eliminations, which dimensions must you include in the model?

There are 2 correct answers to this question. 

  1. Entity
  2. Flow
  3. Group
  4. Time 

Answer: A D  

Question #:154 What actions are possible with work status?

There are 2 correct answers to this question. 

  1. Launching it from the content library
  2. Linking it to multiple hierarchies for an Application
  3. Using it only with entity and time type dimensions
  4. Bypassing it while executing a data management package

Answer: A D  

Question #:155 A transformation file has the option CONVERT_INTERNAL = NO. The records pertaining to account ACCPAY should not be loaded through your data management package.

How do you configure the conversion file? 

  1. Enter ACCPAY in the internal column and %EXTERNAL% in the external column.
  2. Enter ACCPAY in the external column and *SKIP in the internal column.
  3. Enter ACCPAY in the internal column and *SKIP in the external column.
  4. Enter ACCPAY in the external column and %EXTERNAL% in the internal column

Answer: B  

Question #:156 How can an Aggregation Level be used?

Note:There are 3 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. To determine the level of granularity.
  2. To store summary data.
  3. As an InfoProvider for characteristic relationships
  4. As an InfoProvider for consolidation models
  5. As an InfoProvider for planning queries

Answer: B D E

Question #:157 You need to run a planning sequence while data is being saved. Which object do you attach the planning sequence to?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Composite Provider
  2. Planning query
  3. Advanced DataStore Object
  4. Process chain 

Answer: B 

Question #:158 You want to set up a consolidation model. Which of the following dimensions should be the same for consolidation, rate and ownership models?

There are 2 correct answers to this question. 

  1. Account
  2. Entity
  3. Category
  4. Data source
  5. Time 

Answer: C E 

Question #:159 What limitations exist for dimension properties in BPC 10.0 for NetWeaver?

Please choose the correct answer. 

  1. Properties cannot be deleted once they are created.
  2. Property size can only be increased, not decreased.
  3. Properties with more than 60 characters cannot be used for dimension member formulas.
  4. No more than 20 properties can be created for a given member 

Answer: B 

Question #:160 The exchange rate is defined as 1 EUR = 1.4 USD. In the Finance Application, the values are incorrectly calculated based on the inverse ratio.

What dimension will you look at to fix the problem?

Please choose the correct answer. 

  1. InputCurrency
  2. Account
  3. Groups
  4. RptCurrency

Answer: A 

Question #:161 You are formatting an EPM Report.Which of the following features are configured in the EPM formatting sheet?

Note: There are 2 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Indent children.
  2. Data validation
  3. Hierarchy levels
  4. Repeat row headers.

Answer: B D 

Question #:162 How to create a model?

Choose a correct answer 

  1. GOTO Model- New
  2. GOTO – Model- Admin
  3. Model-New
  4. GOTO Administration- Model- New

Answer: D 

Question #:163 Which of the following dimensions is automatically selected when you create a business process flow template?

Please choose the correct answer. 

  1. Time
  2. Account
  3. Category
  4. Entity  

Answer: A 

Question #:164 SAP guidelines recommend that you make what changes directly in SAP BW on BPC- generated objects?

Please choose the correct answer. 

  1. Switch case sensitivity off.
  2. Switch hierarchies to time dependent.
  3. Change the data lengths of characteristics.
  4. Change no objects at all. 

Answer: D 

Question #:165  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?

Please choose the correct answer.

  1. The revenue data in a infocube and the comment in a DataStore Object
  2. The revenue data in a infocube and the comment in another database table
  3. Both the revenue value and the comment in a Infocube
  4. Both the revenue value and the comment in a DataStore Object  

Answer: B 

Question #:166   Which of the following steps are mandatory if you want to perform a transport from the development system to the production system(administration)?

There are 2 correct answers to this question. 

  1. take the environment offline
  2. run a full optimization
  3. run the transport-create request (UJBPCTR) transaction
  4. select planning and consolidation objects in the BW transport collector

Answer: A C 

Question #:167   What can be used as a data source in Analysis for Office?

Note:There are 3 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Web Intelligence
  2. Universe
  3. BW Query
  4. Crystal Report
  5. HANA Calculation View

Answer: B C D 

Question #:168   Which if the following dimension types are required?

There are 4 correct answers to this question. 

  1. Entity
  2. Time
  3. Currency
  4. Account
  5. Category
  6. Intercompany

Answer: A B D E 

Question #:169   You are working in BPC Embedded. Data audit is enabled for a local provide. Whatfileds are added to the local provider database table?

Note: There are 3 correct answer to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Time stamp
  2. Source of data
  3. Audit trail
  4. Request ID
  5. Audit mode 

Answer: B C E 

Question #:170   Which parameters are mandatory for a EVDRE function?

There are 2 correct answers to this question. 

  1. Application 
  2. ExpandRange
  3. FormatRange
  4. KeyRange
  5. OptionRange

Answer: A D 

Question #:171   You are using BPC Standard 11.0.Which of the following do you define in the US Elimination Business Rule?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Architecture
  2. source audit
  3. Multiplers
  4. Entity dimension
  5. Source accounts

Answer: C D E 

Question #:172   What value is assigned to the ACCOUNT3 with the following Script Logic?

*WHEN ACCOUNT

*IS ACCOUNT1, ACCOUNT2

*REC (FACTOR=1, ACCOUNT=ACCOUNT3)

*ENDWHEN

*COMMIT

Please choose the correct answer. 

  1. Quotient of ACCOUNT1 and ACCOUNT2
  2. Difference of ACCOUNT1 and ACCOUNT2
  3. Sum of ACCOUNT1 and ACCOUNT2
  4. Product of ACCOUNT1 and ACCOUNT2 

Answer: C 

Question #:173   You are working in BPC Standard and you need to use a BAdI to perform a calculation. Which object is used to link the code to the script logic file?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. BAdI Definition
  2. Filter Value
  3. BAdI Implementation
  4. Enhancement Implementation

Answer: B 

Question #:174   Which EV expansion option is used to return the current member and its dependents?

Please choose the correct answer. 

  1. EVDPS
  2. EVDEP
  3. EVBSS
  4. EVBAS

Answer: A 

Question #:175   You need to calculate ownership using these values.Company D owns 70% of company A and 10% of company B.Company A owns 50% of company B.

Using the group share method,what percentage ownership does company D have of company B?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. 45%
  2. 35%
  3. 10%
  4. 60%

Answer: C 

Question #:176   Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement?

Please choose the correct answer. 

  1. CURRENCY_TYPE
  2. GROUP_CURRENCY
  3. FX_TYPE
  4. RATETYPE 

Answer: C 

Question #:177   Which of the following values can you use in the destination flow to configure the currency translation business rule?

There are 2 correct answers to this question.  

  1. descendents
  2. property values
  3. blanck
  4. base level members 

Answer: C D

Question #:178   What step is required when setting up Finance or Consolidation Application compared to other Applications?   

  1. Select source Application 
  2. Select Application options
  3. Select copy options
  4. Modify Application 

Answer: B

Question #:179   Which of the following interfaces can you use when you define actions using the business process flow templates.

There are 3 correct answers to this question.  

  1. EMP Office Add-in Excel
  2. Journals
  3. EPM Office Add-in word
  4. BW Application server
  5. Planning and consolidation administration

Answer: A, C, E

Question #:180   Identify the different dimension types

There are 2 correct answers to this question 

  1. Category
  2. Account
  3. Hyperlinks
  4. BOSC
  5. Library 

Answer: A, B

Question #:181   You need to develop a BW query for SAP BPC 11.0. What should you use?

Please choose the correct answer.  

  1. BEx Query Designer 
  2. RTC Modeling Tool
  3. C. Model Extension Tool
  4. D. BW Modeling Tool 

Answer: D

Question #:182   You have defined the global definition in the business rules.which of the following ownership accounts must contain data if you want to perform the ownership calculation?

There are 2 correct answers to this question. 

  1. PCON-percent consolidation
  2. POWN _ percent ownership
  3. POWN SYS – percent ownership_system calculation
  4. PCON SYS – percent consolidation_system calculatiion
  5. PCTRL – percent control 

Answer: A B

Question #:183   After running consolidation, you notice that the elimination offset account is wrong. What property could have the incorrect value?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. ELIMACC
  2. TYPELIM
  3. DIMLIST_ACC
  4. ACCTYPE

Answer: A 

Question #:184   You want to enable users to resolve the “out of balance” issue when blocking controls fail. When you configure the controls, what do you attach to the blocking controls?

Please choose the correct answer. 

  1. a web report
  2. an excel report
  3. a journal
  4. an input schedule  

Answer: C 

Question #:185   The parent company D owns 91% of company A, 51% of company B and 49% of company C. which company can use the equity method?

Please choose the correct answer 

  1. c
  2. a
  3. b
  4. d

Answer: C 

Question #:186   What will be use to launch Excel Report?

choose the correct answer 

  1. Hypertext
  2. Drill down
  3. Control
  4. Status

Answer: A 

Question #:187   What is entered in the destination group account when setting the AR/AP intercompany elimination business rule with the automatic adjustment business rules?

Please choose the correct answer. 

  1. PLUG account
  2. Intercompany accounts payable account
  3. Same value as in the destination minority account
  4. Intercompany accounts receivable account

Answer: A 

Question #:188   How do you configure the data Manager package to execute a specific logic script file?

Please choose the correct answer. 

  1. define the logic script file as a variable in package parameters
  2. define the logic script file in the advanced package settings
  3. define the logic script file in the package link
  4. define the logic script file in the process chain  

Answer: B 

Question #:189   Which of the following functions do you use to load data from a flat file to a model?

Please choose the correct answer. 

  1. Data Preview
  2. Run Package
  3. Organize Package
  4. Download Data

Answer: B 

Question #:190   you are working with BPC Embedded in a replicated scenario.You need to create a local Provider.Aside from the Native SAP HANA table,which other objects are system generated?

Note: There are 2 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. BW Query
  2. External calculation view
  3. Aggregation level.
  4. Workspace

Answer: B  D

Question #:191   Name the folder that the users has access to depend his/ her access account

Choose the correct answer 

  1. Membership
  2. Team
  3. None
  4. Activity 

Answer: B  

Question #:192   What limitations exist for dimension properties in BPC 10.0 for NetWeaver?

Please choose the correct answer. 

  1. Properties with more than 60 characters cannot be used for dimension member formulas.
  2. No more than 20 properties can be created for a given member.
  3. Properties cannot be deleted once they are created.
  4. Property size can only be increased, not decreased. 

Answer:   D

Question #:193   You use the INC account type for revenue accounts and the EXP account type for expense accounts.

What is displayed in an EPM report when revenues are stored as negative values and expenses are stored as positive values?

Note:There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Negative revenue values
  2. Negative expense values
  3. Positive revenue values
  4. Positive expense values 

Answer: A B

Question #:194   Select items required for Enabling the EPM Add-in

There are 2 correct answers to this question 

  1. Disabled items
  2. Control panel
  3. All the above
  4. Microsoft Office excel, Excel Options button
  5. Esc button 

Answer: A D

Question #:195   You CANNOT view the final data in Real Time Consolidation. What could be the issue?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. The work state needs to be complete.
  2. The process needs to be submitted.
  3. The entity needs to be approved.
  4. The data needs to be validated. 

Answer: A C

Question #:196   Where do you activate the parameter that is used to automatically refresh the input form when you open it (input forms and report)?

Please choose the correct answer. 

  1. EPM – Command display options
  2. EPM – User option
  3. EPM – sheet options
  4. EPM – context options 

Answer: C

Question #:197   What is an advantage of using Web reports over of EPM reports?

Please choose the correct answer. 

  1. web reports support EPM functions
  2. web reports suport multiple dimensions in the rows and columns
  3. web reports can access data from multiple sources
  4. web reports use a thin client 

Answer: D

Question #:198   Which dimensions can you use to configure the Balance Carry Forward business rule?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Account
  2. Audit Trail
  3. Entity
  4. Currency
  5. Flow

Answer: B ,D, E

Question #:199   What is the maximum length of a characteristic value in BPC Embedded?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. 32 Characters
  2. 1333 characters
  3. 255 characters
  4. 250 characters

Answer: A

Question #:200   You are developing the following script logic to perfoam an allocation.

*RUNALLOCATION

*FACTOR USING/TOTAL

*DIM ACCOUNT WHAT=LEASECOST;WHERE=<<<;USING=SQUAREFOOTAGE;TOTAL=<<<

*DIM ENTITY WHAT=GLOBALOPS;WHERE=>>>;USING=>>>;TOTAL=BASE(EUROPE)

*DIM COSTCTR WHAT=CORPORATE;WHERE=BAS(SERVICES);USING=>>>;TOTAL=BAS(DIRECT)

*ENDALLOCATION

To which destination members is the above script logic writing the record?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. EUROPE base members
  2. DIRECT base members
  3. LEASECOST
  4. SQUAREFOOTAGE base members
  5. E. SERVICE base members

Answer: C, D, E

Question #:201   To what is the term ‘ROUND’ in the script logic of the attached figure referring?

Please choose the correct answer 

  1. Enhancement spot of the BAdI
  2. Technical name of the BAdI
  3. Parameter used in the BAdI
  4. Filter value in the BAdI 

Answer: D

Question #:202   You are working in BPC Standard. Which dimensions must be identical in all models that use the Exchange Rate Model?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Time
  2. Category
  3. Currency
  4. Account 

Answer: C D

Question #:203   Identify the action required for The value of Planning and Consolidation

Please choose the correct answer 

  1. Marketing
  2. Analyze
  3. Directing
  4. Operations 

Answer: B

Question #:204   You are using BPC Embedded and want ot plan on new members. You decide to import class. What are the function type parameters?

Note: There are 3 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. InfoObject
  2. Property ID
  3. Member ID
  4. InfoProvider
  5. Parent ID

Answer: A, B, E

Question #:205   Find out the implementation factors

There are 2 correct answers to this question 

  1. Branding
  2. esources
  3. Enrichment
  4. Project objectives 

Answer: A B E

Question #:206  When a user tries to log in to an Application using BPC for Excel, the Application does not appear in the list of available Applications the user just created. What is the problem?

Please choose the correct answer. 

  1. The member access profile is not correct.
  2. The Application is not created correctly.
  3. The user is not created correctly.
  4. The task profile is not correct. 

Answer: A

Question #:207  What dimensions can be referenced to each other?

There are 2 correct answers to this question. 

  1. Account to Rate
  2. Time to Category
  3. Flow to Account
  4. Currency to Entity
  5. Intco to Entity

Answer: B D 

Question #:208  How can you add a property other than a hierarchy to a dimension?

Please choose the correct answer. 

  1. Refresh the dimension members.
  2. Process the dimension.
  3. Maintain the dimension members.
  4. Maintain the dimension property. 

Answer: D 

Question #:209  What activities are possible while running a data management package in BPC for NetWeaver?  

There are 3 correct answers to this question.

  1. Importing master data hierarchies
  2. Importing master data descriptions
  3. Importing master data attributes
  4. Importing transaction data
  5. Loading data from InfoProviders 

Answer: B D E 

Question #:210   You are using BPC Standard. You want to calculate revenue as a product of the units sold and price per unit and save the results in the database. How can you achieve this?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Use the worksheet logic
  2. Use business rules
  3. Use a data manager package
  4. Use the dimension member formula

Answer: C 

Question #:211   Which EV functions can support the posting process of an Input Schedule?

(Choose two)

There are 2 correct answers to this question.

  1. EVCOM
  2. EVMNU
  3. EVDRE
  4. EVGTS
  5. EVHOT 

Answer: A C 

Question #:212   Select the key term for-SAP business information warehouse

choose the correct answer

  1. SA
  2. TB
  3. UX
  4. BW 

Answer: D 

Question #:213   You are working in a BPC Standard system.For which of the following models do you have to create at least two”Drivers and Rates”type models?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Standard
  2. Financial
  3. Consolidation
  4. Ownership 

Answer: C 

Question #:214   What do you have to create to capture the data from multiple planning iterations?

Please choose the correct answer. 

  1. dimensions
  2. models
  3. properties
  4. members 

Answer: C 

Question #:215   You are working in a BPC Optimized system and you are setting up data retraction. Which of the following SAP S/4HANA core tables does retraction book to?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. ACDOCP
  2. FAGLBSAS_BAK
  3. COSP
  4. COSS_BAK 

Answer: B

Question #:216   How do you allow data entry and posting in a BPC Excel sheet?

Please choose the correct answer. 

  1. Use a hierarchical structure for member values.
  2. Set the workbook option to ‘Refresh automatically’.
  3. Add a row to show the variance of the plan.
  4. Use base members. 

Answer: B 

Question #:217  For which dimension can you activate a data audit trail for an Application?

Please choose the correct answer.  

    1. Account
    2. Entity
    3. Category
    4. Time 

Answer: C

Question #:218  You need to configure work status to help control the planning process while implementing BPC Standard. Which steps are required?

Note: There are 2 correct answers to this question.

  1. Maintain the reviewer property in the owner dimension.
  2. Enable data locking for the model.
  3. Define a hierarchy in the owner dimension.
  4. Maintain the manager property in the owner dimension. 

Answer: A B

Question #:219  A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose?

  1. Business Rules
  2. Script Logic
  3. Worksheet Logic
  4. Dimension Member Formulas 

Answer: D

Question #:220  Dimension Member sheet consist of the following topics

There are 2 correct answers to this question 

  1. IDs. and description
  2. Groups
  3. Flow charts
  4. Column and hierarchies

Answer:A D

Question #:221  You are working in a BPC Embedded system. You need to configure the task sequence for month-end closing. Which of the following settings must be configured?

Note: There are 2 correct answers to this question

  1. Task frequency
  2. Currency
  3. Currency entity
  4. Task dependency 

Answer: A C

Question #:222  How do you model cost center rollups by profit center when planning is done by cost center?

Please choose the correct answer. 

  1. With a profit center hierarchy by cost center
  2. With a user defined dimension for the profit center
  3. With a profit center property in the cost center dimension
  4. With a cost center hierarchy by profit center 

Answer: D

Question #:223  How do you control inserting records into the database in BPC?

Please choose the correct answer. 

  1. Via Work Status
  2. Via Audit
  3. Via Business Rules
  4. Via Distributor and Collector 

Answer: A

Question #:224  What step is required to configure data audit for BPC standard?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. 

  1. Activate the collection of data by environment.
  2. Add a global parameter in Customizing(SPRO).
  3. Add a parameter to data manager packages
  4. Activate the collection of data by model.

Answer: A

Question #:225  What is a Manage a drill through?

Choose the correct answer 

  1. This allow a user to maintain a drill through parameters
  2. This allow users to view drill through a parameter
  3. This allow a user to run a drill through
  4. None 

Answer: A

Question #:226  What tasks can be done using the Web Administration?

There are 2 correct answers to this question.  

  1. Setting up file types 
  2. Activating but not deactivating auditing 
  3. Adjusting the version number of a report template 
  4. Changing documents type but not document subtype

Answer: A C

Question #:227  What is missing in the following currency translation logic script if you want to translate local currency to reporting currency in a financial model?

*RUN_PROGRAM CURR_CONVERSION CATEGORY=%CATEGORY_SET% TID_RA=%TIME_SET%

RATEENTITY=%ENTITY_SET% *ENDRUN PROGRAM

Please choose the correct answer.  

  1. logic for the group type dimension
  2. logic for the entity type dimension
  3. logic for the currency type dimension
  4. logic for the account type dimension  

Answer: B

Question #:228  What does a consolidation model contains?

there are 2 correct answers to this question 

  1. Accounts
  2. Only contents
  3. Balance sheet data
  4. Proactive data
  5. Income statement 

Answer: C E

Question #:229  You are working in a BPC Optimized system.You need a planning function to copy actual data to plan data.Which of the following characteristics must be included in the fileds to change?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Fiscal year
  2. InfoProvider 
  3. Version
  4. Client

Answer: C 

Question #:230  The attached figure shows a script logic written in BPC for NetWeaver. The dimensions, except for time and account, are all restricted to a single base level member.

The account type dimension has 40 dimension members. How many records are written on execution of this script logic? 

  1. 40
  2. 480
  3. 12
  4. 1

Answer: C 

Question #:231  Which of the following taks can you perform using a Data Manager package deliverd by SAP?

There are 3 correct answers to this question. 

  1. Export transcation data to a flat file.
  2. Load master data and texts from a BW InfoObject.
  3. Export master data to SAP ECC.
  4. Load transaction data from a BW InfoProvider.
  5. Execute a Badl. 

Answer: B D E 

Question #:232  You want to calculate revenues as a product of the unit sold and price for unit and save the results in database. How can you achieve this?

Please choose the correct answer.

  1. Use the worksheet logic 
  2. Use the dimension member formulas
  3. Use business rules
  4. Use the logic script 

Answer: D 

Question #:233  You are working in BPC Standard.Which of the following calculation options is HANA optimization?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Consolidation logic
  2. Local member formulas
  3. Dimension member formulas
  4. Business rules

Answer: A 

Question #:234  You are working in a BPC Embedded system. You need to configure the task sequence for month-end closing. Which of the following settings must be configured?

Note: There are 2 correct answers to this question. 

  1. Currency
  2. Task frequency
  3. Currency entity
  4. Task dependency

Answer: B C 

Question #:235  You have created the controls and a user has tested them for the current period. However, the user does not see the controls for the following period in the controls monitor. How do you resolve this issue?

Please choose the correct answer.

  1. grant authorization to the user to view the controls for following period
  2. assign the control level to the following period
  3. change the work status in the consolidation monitor for the following period
  4. assign the control set to the following period 

Answer: B 

Question #:236  A report has been created with products in the rows displayed in a hierarchy.You would like to display the product members and parents in different colors based on the relative position in the hierarchy.

Which of the following options in the EPM add-in will allow you to accomplish this?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Highlight Selected Hierarchies
  2. Calculate Parents in Hierarchies
  3. Formatting on Specific Level
  4. Formatting on Specific Member/Property

Answer: A B  

 Question #:237  Which of the following options can you use for drill through?

Please choose the correct answer. 

    1. URL based on the current view
    2. RFC connection based on the current view
    3. RFC connection based on the selected cell
    4. URL based on the selected cell

Answer: D 

Question #:238   Identify the 3 different types of Logic (Consolidation)

There are 3 correct answers to this question

  1. Rate type
  2. Front-End
  3. Stored Output
  4. Models
  5. On the fly

Answer: B C E  

Question #:239   In SAP BusinessObjects Planning and Consolidation for NetWeaver, the language texts are missing. How do you fix this issue?

Please choose the correct answer. 

  1. Load data from the InfoProvider.
  2. Import master data descriptions.
  3. Import transaction data.
  4. Refresh dimension members. 

Answer: B 

Question #:240   Which dimensions or properties can you use to determine the rule type and source values in a currency translation business rule?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. RATETYPE
  2. CURRENCY
  3. GROUP_CURRENCY
  4. FLOW

Answer: B C  

Question #:241   What dimensions can be referenced to each other?

There are 2 correct answers to this question. 

  1. Intco to Entity
  2. Currency to Entity
  3. Account to Rate
  4. Flow to Account
  5. Time to Category

Answer: B E  

Question #:242   Where is archived audit data stored in BPC for the SAP NetWeaver technology platform?

Please choose the correct answer. 

  1. In a BW InfoCube
  2. In a BW table
  3. In a DataStore Object
  4. In a flat file

Answer: B   

Question #:243   Dimension Member sheet consist of the following topics

There are 2 correct answers to this question 

  1. Flow charts
  2. Groups
  3. Column and hierarchies
  4. IDs. and description

Answer: C D   

Question #:244   What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule?

Please choose the correct answer 

  1. Intercompany accounts receivable account
  2. Intercompany accounts payable account
  3. Value of the ELIMACC property of account dimension
  4. Same value as in the destination minority account

Answer: C   

Question #:245   You want to calculate revenues as a product of the unit sold and price for unit and save the results in database. How can you achieve this?

Please choose the correct answer. 

    1. Use the dimension member formulas
    2. Use the worksheet logic
    3. Use business rules
    4. Use the logic script 

Answer: D   

Question #:246   What allows you to type the Dimension Member values in your worksheet

Choose the correct answers 

  1. Formatting
  2. Profiles
  3. Member Recognition
  4. Status reports 

Answer: C  

Question #:247   You are working in a BPC Optimized system. You need a planning function to copy actual data to plan data. Which of the following characteristics must be included in the fields to change?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Version
  2. InfoProvider
  3. Client
  4. Fiscal year

Answer: C   

Question #:248   What do you do when you maintain dimensions data manually and want to return to the previous unsaved values?

Please choose the correct answer. 

  1. Choose back
  2. Choose revert
  3. Choose restore
  4. Choose display 

Answer: C 

Question #:249   A customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. What expression in the formula of the business rule for currency conversion would leave the reporting currency value unchanged?

  1. [COPYLC]
  2. [AS_IS]
  3. [NOTRANS]
  4. [END]

Answer: C   

Question #:250   The attached figure shows a script logic written in BPC for NetWeaver. The dimensions, except for time and account, are all restricted to a single base level member.

The account type dimension has 40 dimension members. How many records are written on execution of this script logic? 

  1. 480
  2. 40
  3. 1
  4. 12

Answer: D 

Question #:251   Who is notified when an activity is submitted in the Business Process Flow?

Please choose the correct answer. 

  1. Reviewer
  2. Manager
  3. Owner
  4. Performer 

Answer: A

Question #:252   You use an account by entity report and want to drill download on parent accounts for one entity at a time, as in the attached screenshot.

How to you achieve this drilldownl behavior? 

Please choose the correct answer.

  1. Activate Member and Descendants.
  2. Activate Member and Children.
  3. Activate Expand / Collapse on Single Member.
  4. Activate Keep / Exclude on Single Member 

Answer: C   

Question #:253   Which of the following dimension types are required for an ownership type model?

There are 3 correct answers to this question.

  1.  G – group
  2. B. A – Account
  3. C. I – Intercompany
  4. D. D – Audit
  5. E. R – Currency

Answer: A B C  

Question #:254   How can characteristic relationships be used?

Note:There are 3 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. To distribute data based on valid combinations.
  2. To check combinations based on S/4HANA data.
  3. To derive data based on BW hierarchies.
  4. To delete data based on invalid combinations.
  5. To disaggregate based on reference data.

Answer: B D E   

Question #:255   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?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Breakdown Dimension
  2. Control Level
  3. Thereshold Level
  4. Control Status 

Answer: C   

Question #256: What are the sections related to EPM formatting sheet

There are 2 correct answers to this question 

  1. Subtitle
  2. Heading
  3. Editing
  4. Data and Use column/ cells
  5. Checkboxes 

Answer: D E

Question #257: What is displayed in the report, based on the screenshot of the Control Panel settings?

There are 2 correct answers to this question. 

  1. Net income and all members for accounts in the rows
  2. All base members for accounts except net income in the rows
  3. Total for time in the first column
  4. Total for time in the last column

Answer: A D 

Question #258: You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported?

There are 2 correct answers to this question.  

  1. Mapping only one key figure to the target data although source data has multiple key figures
  2. Loading data from an InfoCube, but not from a DataStore Object
  3. Using JavaScript in the transformation files
  4. Selecting data pertaining to specific master data values to load 

Answer: A D    

Question #259: How do you change an EPM report from read only to read/write using EPM office Add-in Excel?

Please choose the correct answer. 

  1. Switch template to an input schedule  
  2. switch type from report to input form
  3. Activate member recognition in the sheet options
  4. Activate as input form in sheet option  

Answer: C     

Question #260 Which of the following options do you use to calculate KPIs on the fly?

Please choose the correct answer.    

    1. Dimension Member Formulas
    2. Worksheet Logic
    3. Script Logic
    4. Business Rules 

Answer: A   

Question #261 Find out the Environment models from the following

There are 3 correct answers to this question

  1. Social Responsibilities
  2. HR Planning
  3. Sales Planning
  4. Financial Reporting
  5. Political Planning

Answer: B C D    

Question #262 You enter data using EPM Office Add-inn excel. When you attempt to save the data, you receive an error message saying that the member you want to save is not a base level member. What could help you to resolve this issue?

There are 2 correct answers to this question.

  1. Change the calc property of the parent members to N.  
  2. Change the header dimensions to base members
  3. Restrict rows and columns to base member
  4. Set the expand option to ” member and children” 

Answer: B D  

Question #263 What Application option do you have to select when you create an Application to make intercompany eliminations?

Please choose the correct answer.   

  1. Automatic Adjustment
  2. Balance Carry Forward
  3. Validation Rules
  4. Account Transformation

Answer: A      

Question #264  A data load of a data management package shows an error message stating that the number of rejected records is 700. To which value do you need to set the MAXREJECTCOUNT in the transformation file so that the data is loaded regardless of the number of rejected records? 

  1. 701
  2. -1
  3. 700
  4. 0

Answer: B     

Question #265  What interfaces can you use during the step Define Action when setting up a BPF?

Please choose the correct answer. 

  1. Manage Books, BPC Web, BPC for Word
  2. B. Journal, BPC for Excel, BPC for Word 
  3. BPC Administration, BPC for Excel, BPC for Word 
  4. Data Audit, BPC for Excel, BPC for PowerPoint

Answer: B

Question #266   What dimension property is required for consolidation of investments?

Please choose the correct answer.  

  1. INTCO in the entity dimension
  2. FIRST_CONS_DATE in the groups dimension
  3. ENTITY in the groups dimension
  4. OWNER in the entity dimension  

Answer: A   

Question #267   In which section of the transformation file do you define the source InfoObject?

Please choose the correct answer. 

  1. Conversion
  2. Options
  3. Mapping
  4. Selection

Answer: C

Question #268   EvDRE Stands for what?

Choose the correct answer  

  1. Every Day Range Exchange
  2. Everest Data Rapid Exchange
  3. Everest Drone Range Exchange
  4. Everest Data Range Exchange  

Answer: D          

Question #269   Which application type is optional in BPC for consolidation of investments and currency translation?  Please choose the correct answer. 

  1. Ownership
  2. Financial
  3. Consolidation
  4. Rate 

Answer: B            

Question #270   Give one word for-The cell where the comment is retrieved or stored

Choose the correct answer 

  1. Row
  2. Grid
  3. Column
  4. Cell  

Answer: D           

Question #272   You are working in BPC Embedded. What options do you have for modelling persistent data?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. InfoObject
  2. CompositeProvider
  3. AdavancedDataStore Object
  4. MultiProvider  

Answer: A D            

Question #273   In BPC NetWeaver, the language texts are missing. How do you fix this issue?

Please choose the correct answer.  

  1. Import transaction data.
  2. Refresh dimension members.
  3. Import master data descriptions.
  4. Load data from InfoProvider.  

Answer: C            

Question #274   What value for the property DATASRC_TYPE in the data source dimension allows you to identify system postings?

Please choose the correct answer.  

  1. M – Manual
  2. I – Input
  3. A – Automatic
  4. L – Level 

Answer: C            

  1. Question #275   The Account type dimension consists of three properties? What are they

There are 3 correct answers to this question  

  1. Up list
  2. Account type
  3. Mid list
  4. Dim list
  5. Rate type  

Answer: B D E            

Question #276   You are implementing a planning solution that uses BPC Embedded. When you run a planning function,you notice that it is. How can you resolve this issue?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Set the RSPLS_HDB_SUPPORT parameter to HDB_ON.
  2. Create a planning function that runs HANA SQL.
  3. Set the RS_DEBUGLEVEL parameter to 2.
  4. Active Deep HANA Integration.

Answer: A B C            

Question #277   You want to use specific default values when you add data manually from the web client. How can you achieve this?

Please choose the correct answer.  

  1. Select the “Use as Input Form” option
  2. specify the default members for data input
  3. select the “activate Member recognition” option
  4. specify the default members for reporting 

Answer: B

Question #278   During testing you notice that account descriptions are missing. How do you resolve this issue?  

  1. Import master data descriptions.
  2. Import transaction data.
  3. Import master data hierarchies.
  4. Refresh dimension members. 

Answer: A

Question #279   Script logic can be broken in to 3 components. List them.

There are 3 correct answers to this question

  1. Multiple settings
  2. Scoping
  3. Body/ code
  4. Volume
  5. Writing the record

Answer: B C E 

Question #280   How to set a work status in the consolidation monitor.

There are 2 correct answers to this question  

  1. Choose an entity and click work status
  2. Changes in data
  3. Choose work status  
  4. Click refresh to see the update status
  5. Only refresh 

Answer: A D   

Question #281   Which hierarchy is used in the consolidation monitor?

Please choose the correct answer.  

  1. Ownership-based Hierarchy
  2. Entity Hierarchy
  3. Intercompany-based Hierarchy
  4. Group Hierarchy

Answer: A  

Question #282   What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings?

Please choose the correct answer.  

  1. I – Input
  2. B. L – Level
  3. M – Manual
  4. A – Automatic 

Answer: D  

Question #283   When executing the ownership calculation you recevie an error message. You therefore analyze the group/entity structure in the attached screeshot.

Which method type is missing in the consolidation method? 

Please choose the correct answer

  1. P-Proportional
  2. E-Equity
  3. H-Holding
  4. G-Global

Answer: C     

Question #284   What EV functions can support the posting process of an Input Schedule?

There are 2 correct answers to this question. 

  1. EVAPP
  2. EVBET
  3. EVDRE
  4. EVSND
  5. EVGTS

Answer: C D 

Question #285   During testing you notice that account descriptions are missing. How do you resolve this issue?

  1. Import master data hierarchies.
  2. Import master data descriptions.
  3. Import transaction data.
  4. Refresh dimension members.  

Answer: B  

Question #286   What are the implementation factors required to start a project

There are 3 correct answers to this question  

  1. Timeline
  2. Scope
  3. Project objectives
  4. Layoff
  5. Menu  

Answer: A B C 

Question #287   What program can you use to validate the consistency of an application set after copying the standard application set? 

  1. UJA_APPSET_INFO
  2. UJA_COPY_APPSET
  3. UJA_DATA_CHECKER
  4. UJT_CHECK_TABLE_ENTRIES

Answer: C     

Question #288   The access rights you can assign to the sets of members are

There are 3 correct answers to this question  

    1. Write
    2. Follow
    3. Denied
    4. Read only
    5. Accept 

Answer: A C D     

Question #289   Which step is mandatory if you want to check the data integrity of the incoming records(administration)?

Please choose the correct answer. 

  1. Assign a driver dimension to the validation rule
  2. Configure controls
  3. Activate the validations for the environment
  4. Implement a BADI 

Answer: D 

Question #290   Which rlimension type can you use for the context when you use the controls monitor in a financial model?

There are 3 correct answers to this question.  

  1. R-Currency
  2. T-Time
  3. E-Entity
  4. G-Group

Answer: B C D

Question #291   What is displayed in the report, based on the screenshot of the Control Panel settings?

There are 2 correct answers to this question. 

  1. Total for time in the last column
  2. All base members for accounts except net income in the rows
  3. Total for time in the first column
  4. Net income and all members for accounts in the rows 

Answer: A D   

Question #292   You want to be able to insert comments in an Excel popup in SAP BusinessObjects Planning and Consolidation version for NetWeaver?

What do you have to enable?

There are 2 correct answers to this question 

  1. The Enable Comments indicator in model features
  2. Model parameters in Customizing (SPRO)
  3. The Show as Microsoft Excel Comments checkbox
  4. Environment parameters in Customizing (SPRO) 

Answer: A C   

Question #293   how do you change an EPM report from read only to read/write using EPM office Add-in Excel?

Please choose the correct answer. 

  1. Switch type from report to input form
  2. Switch template to an input schedule
  3. Activate as input form in sheet option
  4. Activate member recognition in the sheet options 

Answer: D

Question #294   Data is loaded only in the ‘F_OPE’ flow/subtable. When executing the currency translation for the first time, the CTA_ACT in F_CTA is empty. What is the problem with the logic?  

    1. The data is not available for F_TMP3 flow.
    2. The user needs to execute the task one more time.
    3. The formula is incorrect and needs to be modified.
    4. The logic is correct but the system is doing something wrong.  

Answer: A

Question #295   Who is notified when a step is completed using Business Process Flow?

Please choose the correct answer.  

  1. BPF Manager
  2. BPF User
  3. BPF Owner
  4. BPF Reviewer 

Answer: D 

Question #296   You are working in Bpc Standard. Which of the following dimension type are required for an ownership type model?

Note: There are 3 correct answers to the question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Intercompany
  2. Audit
  3. Group
  4. Account
  5. Currency 

Answer: A B E                                                                                                                                                                                                                       

Question #297   Which of the following journal parameters are available for a model?

Please choose the correct answer.  

  1. Enforce Balanced Journal
  2. Balanced by Currency
  3. Allow Journals to be reopened
  4. Balanced by Entity 

Answer: C  

Question #298   What are the features Add-in The Excel Interface?

There are 2 correct answers to this question  

  1. Create reports
  2. Distribution and collection
  3. BOCF
  4. CRM
  5. SPSS  

Answer: A B    

Question #298   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 accomplish this?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Switch to ‘Display Mode’.
  2. Use the ‘SAPSetData’ formula.
  3. Select the ‘Smart Copy’ button.
  4. Select the ‘Recalculate’ button. 

Answer: B  

Question #299   You want to use work status in Analysis for Office. Which steps are required?

Note: There are 2 correct answers to this question.  

  1. Select the data region in the filter tab
  2. Select the data region in the crosstab
  3. Link the model to the data source
  4. Link the model to the workbook.  

Answer: B  D

Question #300   What fields are required to eliminate the investment when using the ‘All Formula’?

There are 2 correct answers to this question.  

  1. Destination All Account
  2. Source Account
  3. Destination Equity Account
  4. Destination Minority Interest
  5. Destination Group Account

Answer: A B

Question #301   You have created controls and a user has teasted them for the current period. However, period in the Controls Monitor. How do you resolve this issue?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Change the work status in the Consolidation Monitor for the following period.
  2. Grant authorization to the user to view the controls for the following period.
  3. Assign the control set to the following period.
  4. Assign the control level to the following period.

Answer: B

Question #302   You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent?

Please choose the correct answer. 

  1. Threshold Tolerance
  2. Control Level
  3. Equation Type
  4. Breakdown Dimension 

Answer: D

Question #303   All model types must have the following dimension type

Choose the correct answer 

  1. Resources
  2. Machine
  3. Time
  4. Money 

Answer: C

Question #304   You are working in a BPC Embedded system. What object can you maintain immediately after creating an environment?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. 

  1. Report
  2. Business Process Flow
  3. Dimension
  4. Team 

Answer: B

Question #305   Which dimension type is optional for a model?

Please choose the correct answer. 

  1. A–Account
  2. C–Category
  3. T–Time
  4. D–Audit 

Answer: D

Question #306 You are configuring comments in BPC Embedded. Which objects are required?

Note: There are 2 correct answers to this question.

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Please choose the correct answer. 

  1. A Characteristics as key figure
  2. A system-generated data table
  3. An AdavancedDataStore Object
  4. A Composite Provider 

Answer: A C

Question #307 When does default logic run?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

Please choose the correct answer. 

  1. When data is sent from an input form
  2. When business rules are executed
  3. When data is refreshed
  4. When table-based logic is executed 

Answer: A

Question #308 Which of the following journal parameters are available for a model?

Please choose the correct answer. 

  1. Enforce Balanced Journal
  2. Balanced by Currency
  3. Balanced by Entity
  4. Allow Journals to be reopened  

Answer: D 

Question #309 You have created controls and a user has tested them for the current period. However,period in the Controls Monitor. How do you resolve this issue?

Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.

  1. Change the work status in the Consolidation Monitor for the following period.
  2. Assign the control set to the following period.
  3. Grant authorization to the user to view the controls for the following period.
  4. Assign the control level to the following period

Answer: C

Question #310 You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent?

Please choose the correct answer 

  1. Threshold Tolerance
  2. Control Level
  3. Breakdown Dimension
  4. Equation Type 

Answer: C 

Question #311 Which property is optional for account type dimensions? 

  1. ICMATCH
  2. RATETYPE
  3. ACCTYPE
  4. SCALING

Answer: A 

Question #312 Which fields are required to eliminate the investment when using the All Formula? (Choose two)

There are 2 correct answers to this question.  

  1. Destination Group Account
  2. Destination Equity Account
  3. Destination All
  4. Source Account
  5. Destination Minority Interest
  6. Account  

Answer: C D

Question #313 What are the features Add-in The Excel Interface?

There are 2 correct answers to this question 

  1. CRM
  2. Distribution and collection
  3. Create reports
  4. BOCF
  5. SPSS

Answer: B C

I believe that you have liked it. If you want to connect with more informative blog articles, visit our website

Thanks for reading!

                                                                                                                                                      Want to know more? Visit: https://zarantech.teachable.com/                      

                                                    

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

         

 

No related posts.

phoneicon Call us on 1-999-999-9999 (Toll Free) +91 99999 99999

24 X 7 Customer Support X

  • us flag 99999999 (Toll Free)
  • india flag +91 9999999