SAP BPC Interview Questions & Answers For Beginners | SAP Trainings Online

//SAP BPC Interview Questions & Answers For Beginners | SAP Trainings Online

SAP BPC Interview Questions & Answers For Beginners | SAP Trainings Online

SAP BPC INTERVIEW QUESTIONS & ANSWERS

These SAP BPC interview questions have been designed specially to get job aspirants acquainted with the nature of questions you may encounter during interview of SAP BPC consultant. These are the questions for beginners as well as for experienced.

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.

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.

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.

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.

What are the two version available for SAP BPC?

SAP BPC NetWeaver

BPC MS

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.

What are the key benefits of using SAP BPC with NetWeaver?

Star Schema for Exceptional Reporting − SAP BPC uses NW InfoCubes to store the data. The dimension model used is extended Star Schema so it makes BPC with NW system an exceptional system for reporting.

No Database Dependence Version − BPC NW version is not dependent on database version and can run common databases like DB2, Oracle, SQL Server, etc.

BW Accelerator SupportSAP NetWeaver BW accelerator tool is an additional feature that can be used to enhance the performance of reporting in the system even if you are using large datasets. It indirectly helps in saving the cost for a company as less number of report performance issues are reported.

BAdI Development and ABAP SupportSAP BPC with NetWeaver allows you to use ABAP programming to develop K2 script logic. It enables to create business add-in BAdi interface in the back-end system, which can be called later from script logic developed in BPC system. It helps in solving the complex business requirements and reducing the development time for an organization.

What are the key advantages of using BPC MS?

Dimension Logic − This can be configured in BPC system using simple mathematical formulas.

Business Rules − This allows you to create rules in BPC system to perform specific functions.

K2 Script Logic − This is used to perform some specific functions which can’t be achieved using out-of-box functionality to meet the business requirements. You can create K2 script logics to perform certain functions, which can be performed in a standard system.

What are the key components in BPC architecture?

Requirement − SAP NetWeaver ABAP 7.3 or 7.31

Database − Any of the above version of SAP NetWeaver support.

Operating System − Any supported version of SAP NetWeaver system and database engine.

Which databases are supported by SAP BPC with NetWeaver version?

This layer is responsible to store all the data in 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.

What is Model in SAP BPC?

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.

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.

What is the use of Logic Scripts in SAP BPC?

Logic Scripts is defined as a set of SQL or MDX programming structure 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.

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.

Can you debug the data manager package?

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

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

What is the use of Logic Scripts in SAP BPC?

Logic Scripts is defined as a set of SQL or MDX programming structure 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.

While creating a legal consolidation application, which of the dimensions needs to be created in BPC?

C_Acct (A) − For maintaining charts of account.

C_Category (C) − To define category.

Groups (R) − Like GROUP A (USD), GROUP B (EUR), and GROUP C (RMB).

Entity (E) − It contains the business unit used to derive process.

C_Datasrc (D) − Data Source Dimension.

IntCo (I) − It determines the level of the entity hierarchy at which level the elimination needs to be performed.

Time (T) − Time in all dimensions.

Flow (S) − To keep track of movements in Consolidation.

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.

Which design models are available in SAP BPC to fulfill the business requirements?

Standard model

Embedded model

How Standard model is different from Embedded BPC design model?

Embedded model is different from Standard model and includes data access to all community users. For Embedded design model, initial versions used were SAP BW Integrated Planning and Planning Application Kit i.e. BW-IP and PAK.

In Standard model, BPC environment contains the BPC applications or models and each model generates a BW InfoCube which is hidden.

What is the use of Transformation file? What are the different sections in a Transformation file?

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 mapping file:

Options − Contains the general settings.

Mapping − Used to assign dimension in BPC system with a source column in BW InfoObject.

Conversion − Contains the link of other Excel sheets to apply the conversion routine.

What is the use of conversion file? Name different sections in a conversion file?

A conversion file is used to apply the conversion rules for BPC dimension and is an Excel file. It contains three sections:

External − Contains the value from external source.

Internal − Contains the value it should be having for BPC dimension.

Formula − Defines the conversion formula applied to each record.

What are the different methods that can be used to create reports and input schedules in Business Planning and Consolidation?

  • Using Default Templates
  • EvDRE Builder
  • Drag and Drop Interface
  • Blank workbook

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.

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.

What are the options of DRILL THROUGH ?

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.

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.

What fields will be in 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.

We provide best online training classes in many SAP Courses  in accordance with Industry standards.Our trainings are throughout USA, UK, Australia, UAE, Canada, Saudi Arabia, New Zealand, India and Many other Countries

By | 2017-09-26T09:22:43+00:00 September 26th, 2017|Uncategorized|0 Comments

About the Author:

Leave A Comment