22 September, 2020
Are you planning to attend an interview for the SAP BPC Developer role but confused on how to crack that interview and also what would be the most probable SAP BPC Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked SAP BPC Interview Questions which are often asked in multiple interviews.
Ans: BPC stands for Business Planning and Consolidation. BPC is used for both Planning and Consolidations, unlike IP, which is used for only planning.
Ans: The 7.5 version is currently in the ramp-up stage and should be available in a few months. I am not sure of the exact month.
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.
Ans: BPC comes with pre-delivered components for consolidation, which can be leveraged on. There are a few business rules, which make the consolidation process easier.
Want to become expert in supporting all operational and financial activities in an organization, enroll in our "SAP BPC Training"
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.
Ans: Yes, You can have a look at the installation guide available on the marketplace for detailed requirements.
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.
Ans: UJD_TEST_PACKAGE.You must specify the User ID. The DM package can be selected with F4.
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)
Ans: %USER% - Returns current SAP Business Objects Planning and Consolidation User %APPSET% - Returns current SAP BusinessObjects Planning and Consolidation AppSet (Application Set) %APPLICATION% - Returns current SAP BusinessObjects Planning and Consolidation Application %YEAR% - Returns current calendar year.
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: EVANS 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 EVANS 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.
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.
Ans: Jump to any website Jump to a BW query Jump to ECC code.
Ans: Processing a dimension will execute the following steps:
Ans: A Distribution Template may contain the following fields:
For example, if you want to create a new offline report for each Entity/Cost Center/etc, you would specify that dimension as a Very Key.
Ans: This layer is responsible to store all the data in the database. SAP NW back-end system is responsible to create objects and data stored for BPC system. NetWeaver supports most of the databases like SQL Server, DB2, Oracle, and many more.
Ans: To meet the Business Planning and Consolidation requirement of an organization, you need to build a model in an environment, which is defined as a collection of several dimensions.
Ans: Logic Scripts is defined as a set of SQL or MDX programming structures to perform some customized functions for flexibility and manage data models. When some specific requirements are not achieved using business rules, those can be met by the use of Logic Scripts.
Ans: R_Acct (A) is used for maintaining different types of Rate.
Ans: Embedded model is different from the Standard model and includes data access to all community users. For the Embedded design model, the initial versions used were SAP BW Integrated Planning and Planning Application Kit i.e. BW-IP and PAK.
In the Standard Model, the BPC environment contains the BPC applications or models and each model generates a BW InfoCube which is hidden.
Ans: The transformation file provides the mapping of fields from BW to BPC and is an excel file in BPC. It contains transaction data from InfoObjects in BW with BPC dimensions defined in the administration console.
There are three sections defined for the mapping file.
Ans: A conversion file is used to apply the conversion rules for the BPC dimension and is an Excel file. It contains three sections
|totals by Account||This custom report contains an Account dimension with subtotals in rows and any dimension across in columns.|
|Variance||This custom report contains any dimension in rows and categories comparison in columns. It also features Variances calculation (both amount and percentage). With both YTD and Periodic boxes.|
|Consolidating||This custom report contains any dimension in rows and Entity type members across in columns with hierarchy.|
|Comparative X||This custom report contains any dimension in rows and categories comparison in columns and also retrieves the Last Year same period data. With both YTD and Periodic boxes.|
|Comparison with 3 -year||Year over Year comparison.|
|Drill in Place||This template performs drill in place.|
|Nested||This allows any two-dimension to be nested in a row and the third dimension in the column.|
|Sort on value||This template performs the sort of total value.|
|Drill Dimension||This allows using the drill in one dimension to others.|
Ans: Go to EPM Ribbon → More → EvDRE Migration.
Ans: To define the member dimension formula, you have to put a Square bracket around the dimension and there is a dot between two.
[PRODUCT].[PRODUCT1] – [PRODUCT].[PRODUCT2]
[SALES].[SALES1] / [SALES].[SALES2]
Standard Arithmetic functions have to be used in dimension formula - addition (+), subtraction (-), multiplication (*), division (/) - are used in SAP NetWeaver.
Ans: Work status is used to lock a region of data in a model. This is used to override the user’s member access privilege to write to a particular region.
There are multiple dimensions defined for a region with one property called as OWNER. While defining the work status, the following are defined
Ans: Audit functions allow you to create reports that contain a history of user sessions and system information.
You can create Audit reports on the following topics
Business Process Flows − You can create these reports in BPF.
Security − You can create these reports in Security.
General − You can create these reports in general.
Ans: Custom menu content is defined by two sections in the custom menu template - The default section and Menu item section.
|NORMALSCREEN||Value is True − It opens the custom menu in the Excel interface. Value is False − It opens the custom menu in Standard Excel.|
|HIDEEVTOOLBARS||If Value is True − It will hide the Planning and Consolidation Toolbar. If Value is False − It will display the Planning and Consolidation Toolbar.|
|CVLIST||It is used to define the dimensions that have to be displayed on the top of the custom menu page. These dimensions can be changed into the report mentioned in the Custom menu.|
The menu Item section includes the following parameters
Ans: We use reporting models for analysis purposes. Non Reporting modules include Driver and Rates model and are used for currency rates, price, ownership data, etc.
Types of Reporting Models:
Types of Non-Reporting Models:
Ans: To perform currency conversion and intercompany eliminations, you need a dimension type - Intercompany dimension (I). To execute intercompany elimination, an application should have the following:
|Entity||ELIM||1 char||It contains ‘Y’ or blank|
|InterCompany||Entity||20||Entity Id w.r.t Intercompany member|
|Currency||Reporting||1||‘Y’ or blank|