SAP BPC INTERVIEW QUESTIONS

   

• 1. What is BPC?

As you must be aware that BPC stands for Business Planning and Consolidation. As the name suggest, 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 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 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 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.

• 6. BPC for NW need to install .NET application server and Web server or not?

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

• 7. What is 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 tcode.

• 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 Distribution Template?

1. A Distribution Template may contain the following fields:
2. BOOK: the title of your distributed book.
3. SECTION: denotes the beginning of a section.
4. REPNAME: report filename, location and title (can also be for Input Schedules).
5. 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.
6. 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