SAP BPC Interview Questions

Rating: 5
Views: 14520
by Ruchitha Geebu
Last modified: April 5th 2021

If you're looking for SAP BPC Interview Questions and Answers for Experienced & Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research SAP, BPC has a market share of about 1.0%. So, You still have opportunities to move ahead in your career in SAP BPC. Mindmajix offers advanced SAP BPC Interview Questions 2018 that helps you in cracking your interview & acquire your dream career as SAP BPC Developer. 

SAP BPC Interview Questions and Answers

Q1. What is BPC?

Ans As you must be aware that BPC stands for Business Planning and Consolidation. As the name suggests, BPC is used for both Planning and Consolidations, unlike IP, which is used for only planning.

Q2. When BPC 7.5 NW is available?

Ans The 7.5 version is currently in the ramp-up stage and should be available in few months. I am not sure of the exact month.

Q3. BPC for NW has an aggregation level or not, Is BPC an application on top SAP-IP?

Ans BPC and IP have completely different architecture. BPC doesn’t use aggregation levels or filters. BPC and IP have no relation and thus, cannot be compared. BPC uses various script logics, business rules for doing the planning. Manual planning can be done with input schedules. The input schedules are on the excel platform and are quite versatile. You can use BPC functionalities along with native excel functionalities for better design of the input schedules.

Q4. What about BPC in the consolidation part?

Ans BPC comes with pre-delivered components for consolidation, which can be leveraged on. There are few business rules, which make the consolidation process easier.

Q5. What is the concept for plan data from BPC?

Ans The concept of planning is the same as you have in any other tool. The functional side of the planning remains the same. However, the tool differs. The way you configure a planning scenario will be much different than any other planning tool. Unfortunately, it will not be feasible to address this in the forum. You can definitely go through the study materials for a better understanding.

Q6. BPC for NW need to install the .NET application server and Web server or not?

Ans Yes. You can have a look at the installation guide available on the market place for detailed requirements.

Q7. What is BPC client tool? And If I planning on BEx report, I have to create an aggregation level for planning data or not?

Ans BPC client sits on the client machines, from where; you will be doing the design. There are mainly 3 interfaces available – BPC Admin, BPC Office, and BPC Web. BPC Office, in turn has 3 interfaces – Excel, Word, PowerPoint. These interfaces can be used for various requirements.

Q8. Can you debug the data manager package?

Ans UJD_TEST_PACKAGE .You must specify the User ID .The DM package can be selected with F4.

Q9. What are scoping commands?

Ans The following keywords can be used to modify the scope: *XDIM_MEMBERSET Overwrites the scope for that dimension *XDIM_ADDMEMBERSET Add members to the scope of that dimension *XDIM_FILTER Filters the members of the scope of that dimension *XDIM_MAXMEMBERS Specifies the maximum number of members that should be included in one query (per dimension)

Q10. What are system variables?

Ans %USER% – Returns current SAP Business Objects Planning and Consolidation User %APPSET% – Returns current SAP Business Objects Planning and Consolidation AppSet (Application Set) %APPLICATION% – Returns current SAP Business Objects Planning and Consolidation Application %YEAR% – Returns current calendar year.

Q11. What is the difference between EVGTS and EVSND?

Ans EVGTS: The EVGTS (Get value and scale) function retrieves a data value based on the specified members, and scales the value if the scale property is enabled on the dimension. The report templates provided in the sample application set have a scale reference in the Control Panel area of the template. EVSND: EVSND This Send function references another cell and sends its value to the database when you select Send and Refresh Schedules. The parameters specify the dimensions that identify where the data value is to be sent in the database. EVSND returns the value from the database to the referenced cell. You do not need to add any EVGET functions to the sheet to return values to the cell. Since the values are returned to the referenced cell, BPC sends only the cells that have changed since the last send in the current session. By putting the formula in the EVSND cell and not in the input cells, you decrease the chances of your formulas getting overwritten or erased. To further protect the formulas, you may want to hide the EVSND cells in the input schedule. This function takes members that not specified from the current view settings.

Q12. What is the difference between DRILLDOWN and DRILLTHROUGH?

Ans Drill down is different than drill through. Drill down is used to drill down on member data within dimensions. You can drill down on members in a worksheet, or you can drill down on charts and graphs. Drill down is conducted within one report in the Excel interface whereas drill through is a ‘jump’ outside of the Excel Interface.

Q13. What are the options of DRILL THROUGH ?

Ans Jump to any website Jump to a BW query Jump to ECC tcode
what steps are in Processing a dimension?
Processing a dimension will execute the following steps:
Validate Hierarchy.
Validate Dimension member formulas.
Update member data into BW.
BW Attribute change run.

Q14. What steps are in processing a dimension?

Ans Processing a dimension will execute the following steps:
Validate Hierarchy.
Validate Dimension member formulas.
Update member data into BW.
BW Attribute change run.

Q15. What fields will be in Distribution Template?

Ans A Distribution Template may contain the following fields:
BOOK: the title of your distributed book.
SECTION: denotes the beginning of a section.
REPNAME: report filename, location and title (can also be for Input Schedules).
FIXKEY: sets dimension members to the fixed values when generating the report
For example, you can ensure that a report runs for 2008.TOTAL and ACTUAL.
VARYKEYS: lists the dimensions and dimension members that should vary for each report that will get created.
For example, if you want to create a new offline report for each Entity/Cost Center/etc, you would specify that dimension as a Vary Key.
You then map a specific Vary Key to a User ID who should receive that report (for example, the Cost Center manager). This way, each user who gets a report has the required dimension(s) set to their individual values
SECTIONEND: denotes the end of a section.

Q16. How to debug the script logic?

Program UJK_SCRIPT_LOGIC_TESTER will allow you to test and debug script logic

Explore SAP BPC Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!


Ans Technical name of the BADI.

Q18. startroutine = C1 endroutine = C2 What is C1 ?

Ans Badi filters.

Q19. Process performed by setting up two Excel files?

Ans Transformation file (required) .Conversion file (optional)

Q20. Where you can use the Javascript?

Ans Conversion File

Q21. Can VB script be used in Netweaver BPC?

Ans No VB script in NetweaverBPC .

Q22. The list of supported MDX functions is available from the function module


Q23. Which are the on the fly calculations?

Ans Dimension member formulas.

Q24. Which logic is stored in the database?

Ans Script logic.

Check Out SAP BPC Tutorials

Q25. What you need to use dimension member formulas?

Ans – Formula property in the dimension.

Related Pages:
Sap Bpc Sample Resumes