Home / SAP BPC

SAP BPC Interview Questions

Rating: 5.0Blog-star
Views: 14734
by Ruchitha Geebu
Last modified: July 19th 2021

If you're looking for SAP BPC Interview Questions and Answers for Experienced & Freshers, you are in the right place. There are a 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 2021 that helps you in cracking your interview & acquire your dream career as SAP BPC Developer. 

SAP BPC Interview Questions and Answers

1. What is BPC?

As you must be aware that SAP 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.

2. When BPC 7.5 NW is available?

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.

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

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.

4. What about BPC in the consolidation part?

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

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

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.

Subscribe to explore the latest tech updates, career transformation tips, and much more.

6. BPC for NW needs to install the .NET application server and Web server or not?

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

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

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.

8. Can you debug the data manager package?

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

9. What are scoping commands?

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)

10. What are system variables?

  • %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.

11. What is the difference between EVGTS and EVSND?

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.

12. What is the difference between DRILLDOWN and DRILLTHROUGH?

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.

13. What are the options of DRILL THROUGH?

Jump to any website Jump to a BW query Jump to ECC code
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.

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

15. What fields will be in the Distribution Template?

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.

16. How to debug the script logic?

UJKT
Program UJK_SCRIPT_LOGIC_TESTER will allow you to test and debug script logic

17. START_BADI ROUND. CODE …. ENDBADI. What is ROUND?

The technical name of the BADI.

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

Badi filters.

19. Process performed by setting up two Excel files?

Transformation file (required) .Conversion file (optional)

20. Where you can use Javascript?

Conversion File

21. Can the VB script be used in Netweaver BPC?

No VB script in NetweaverBPC.

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

BAPI_MDPROVIDER_GET_FUNCTIONS.

23. Which are the on-the-fly calculations?

Dimension member formulas.

24. Which logic is stored in the database?

Script logic.

Q25. What do you need to use dimension member formulas?

Ans – Formula property in the dimension

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

 

About Author

author
NameRuchitha Geebu
Author Bio

I am Ruchitha, working as a content writer for MindMajix technologies. My writings focus on the latest technical software, tutorials, and innovations. I am also into research about AI and Neuromarketing. I am a media post-graduate from BCU – Birmingham, UK. Before, my writings focused on business articles on digital marketing and social media. You can connect with me on LinkedIn.