Interview Questions.

Question 1. What Is Epm?

Answer :

SAP Enterprise Performance Management (EPM) lets in your business enterprise to enhance its economic and operational performance management. SAP EPM helps numerous functionalities with SAP Business Planning and Consolidation BPC-NW or BPC-MS like monetary consolidation, financial statistics control, supply chain performance management, method management, and many other regions.

Question 2. What Are The Two Version Available For Sap Bpc?

Answer :

SAP BPC NetWeaver
BPC MS
SAP BO Interview Questions
Question 3. What Are The Key Benefits Of Using Sap Bpc With Netweaver?

Answer :

Star Schema for Exceptional Reporting : SAP BPC uses NW InfoCubes to shop the data. The size version used is extended Star Schema so it makes BPC with NW system an first-rate system for reporting.

No Database Dependence Version: BPC NW model is not depending on database version and may run common databases like DB2, Oracle, SQL Server, and so forth.

BW Accelerator Support : SAP NetWeaver BW accelerator device is a further characteristic that may be used to enhance the overall performance of reporting inside the machine even in case you are using huge datasets. It in a roundabout way helps in saving the cost for a organisation as much less number of report performance troubles are said.

BAdI Development and ABAP Support: SAP BPC with NetWeaver allows you to use ABAP programming to broaden K2 script good judgment. It enables to create enterprise add-in BAdi interface within the returned-stop device, which can be known as later from script logic evolved in BPC system. It enables in fixing the complex business requirements and reducing the improvement time for an enterprise.

Question 4. What Are The Key Advantages Of Using Bpc Ms?

Answer :

Dimension Logic: This may be configured in BPC device the usage of easy mathematical formulation.

Business Rules: This lets in you to create regulations in BPC gadget to perform unique features.

K2 Script Logic: This is used to perform a few particular capabilities which can’t be performed the use of out-of-container functionality to fulfill the enterprise requirements. You can create K2 script logics to perform certain functions, which may be done in a trendy machine.

SAP BO Tutorial
Question 5. What Are The Key Components In Bpc Architecture?

Answer :

Requirement: SAP NetWeaver ABAP 7.Three or 7.31

Database: Any of the above model of SAP NetWeaver aid.

Operating System: Any supported version of SAP NetWeaver device and database engine.

SAP ABAP Interview Questions
Question 6. Which Databases Are Supported By Sap Bpc With Netweaver Version?

Answer :

This layer is accountable to store all the facts in database. SAP NW again-quit gadget is accountable to create objects and statistics saved for BPC system. NetWeaver helps most of the databases like SQL Server, DB2, Oracle, and lots of extra.

Question 7. What Is Model In Sap Bpc?

Answer :

To meet the Business Planning and Consolidation requirement of an organization, you want to construct a version in an environment, which is defined as a group of several dimensions.

SAP ABAP Tutorial SAP FICO Interview Questions
Question 8. What Is The Use Of Logic Scripts In Sap Bpc?

Answer :

Logic Scripts is defined as a hard and fast of SQL or MDX programming shape to perform a few custom designed capabilities for flexibility and manipulate statistics fashions. When a few particular requirements aren't achieved the use of business guidelines, the ones can be met by means of the usage of Logic Scripts.

Question 9. While Creating A Legal Consolidation Application, Which Of The Dimensions Needs To Be Created In Bpc?

Answer :

C_Acct (A) − For retaining 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 carries the commercial enterprise unit used to derive technique.
C_Datasrc (D) − Data Source Dimension.
IntCo (I) − It determines the level of the entity hierarchy at which stage the removal wishes to be carried out.
Time (T) − Time in all dimensions.
Flow (S) − To keep music of actions in Consolidation.

SAP BW Interview Questions
Question 10. What Is The Use Of Dimension - R_acct (a), While Creating A Rate Application In Bpc?

Answer :

R_Acct (A) is used for keeping distinct sorts of Rate.

SAP FICO Tutorial
Question 11. Which Design Models Are Available In Sap Bpc To Fulfill The Business Requirements?

Answer :

Standard Model
Embedded Model
SAP PS Interview Questions
Question 12. How Standard Model Is Different From Embedded Bpc Design Model?

Answer :

Embedded version isn't the same as Standard model and includes facts access to all network customers. For Embedded layout model, initial versions used have been SAP BW Integrated Planning and Planning Application Kit i.E. BW-IP and PAK.

In Standard model, BPC surroundings consists of the BPC programs or models and every model generates a BW InfoCube which is hidden.

SAP BO Interview Questions
Question 13. What Is The Use Of Transformation File? What Are The Different Sections In A Transformation File?

Answer :

Transformation report gives the mapping of fields from BW to BPC and is an excel report in BPC. It contains transaction statistics from InfoObjects in BW with BPC dimensions defined inside the administration console.

There are 3 sections defined for mapping file:

Options: Contains the overall settings.

Mapping: Used to assign size in BPC device with a supply column in BW InfoObject.

Conversion: Contains the hyperlink of other Excel sheets to use the conversion recurring.

SAP BW Tutorial
Question 14. What Is The Use Of Conversion File? Name Different Sections In A Conversion File.?

Answer :

A conversion file is used to apply the conversion regulations for BPC size and is an Excel record. It includes 3 sections:

External: Contains the value from external source.

Internal: Contains the value it ought to be having for BPC dimension.

Formula: Defines the conversion system implemented to each file.

Question 15. What Are The Different Methods That Can Be Used To Create Reports And Input Schedules In Business Planning And Consolidation?

Answer :

Using Default Templates
EvDRE Builder
Drag and Drop Interface
Blank workbook
SAP APO Interview Questions
Question sixteen. How Can You Migrate Evdre Reports Created By Bpc 7.5 Excel To Bpc 10.0?

Answer :

Go to EPM Ribbon → More → EvDRE Migration.

SAP PS Tutorial
Question 17. What Is The Syntax For Dimension Logic? Which Operators Can Be Used In Dimension Logic?

Answer :

To outline member size components, you need to placed a Square bracket around the size and there's dot among two.

[PRODUCT].[PRODUCT1] – [PRODUCT].[PRODUCT2]

[SALES].[SALES1] / [SALES].[SALES2]

Standard Arithmetic functions must be utilized in size formula - addition (+), subtraction (-), multiplication (*), department (/) - are used in SAP NetWeaver.

SAP BODS Interview Questions
Question 18. What Are The Requirements To Perform Simple Currency Conversions And Complex Currency Conversions?

Answer :

Simple Conversion: 

There must be a Rate software in which you store the exchange prices.
You ought to have an account dimension, which incorporates RATETYPE.
Entity size should consist of a belongings CURRENCY.
FXTRANS common sense need to be to be had and DEFAULT common sense should encompass a call to FXTRANS logic.
Entity size should consist of the belongings TRANSALATE_TO. 
Complex Conversion:

There ought to be a Rate software wherein you save the alternate fees.
Application need to include a CURRENCY kind measurement.
There must be belongings REPORTING for the CURRENCY size.
Entity dimension need to include the assets CURRENCY.
Account measurement have to encompass assets RATETYPE.
FXTRANS good judgment ought to be to be had.
DEFAULT common sense ought to consist of a name to FXTRANS logic.
SAP ABAP Interview Questions
Question 19. What Is The Use Of Work Status? What Are The Key Attributes In Defining Work Status?

Answer :

Work popularity is used to lock a area of records in a version. This is used to override the user’s member get right of entry to privilege to write down to a particular place.

There are a couple of dimensions defined for a region with one assets known as as OWNER. While defining the work repute, following are defined:

Work States: It belongs to bodily nation of facts.

Security: You can set specific tiers of safety on changing records inside the device –All or Locked. You can set who can exchange the paintings country − Manager or Owner.

Data Update: This defines how facts may be updated by using the customer.

Push: This option is used to push the same paintings nation for all the youngsters of a member.

SAP BPC Tutorial
Question 20. What Are The Options For Book Publishing In Bpc?

Answer :

You can post books to BPC internet. Administrators and Power users have an option to create books of stories through amassing collection of stories.

You can select an output as Printer copy or .Pdf report, which may be stored on the server. You can use Book Publishing wizard for this. Go to ePublish option and choose Book Publishing wizard from there.

SAP BDC Interview Questions
Question 21. How Is Auditing Done In Sap Bpc? What Are The Different Audit Reports That Can Be Pulled For Audit Purpose?

Answer :

Audit features permit you to create reports that contains records of consumer classes and gadget statistics.
You can create Audit reports on the subsequent topics:

Business Process Flows: You can create these reviews in BPF.

Standard
Step
Audit
Security: You can create these reports in Security.

User
Team
Task Profiles
Data Access Profiles
BPF
General: You can create those reviews underneath wellknown.

Work Status
Administration Activities
Comments
Data Changes
Question 22. What Are The Two Sections In Custom Menu Template?

Answer :

Custom menu content is described by means of two sections in custom menu template - Default segment and Menu object segment.

SAP APO Tutorial
Question 23. What Is Difference Between Reporting Model And Driver And Rate Model?

Answer :

We use reporting models for analysis reason. Non Reporting modules consist of Driver and Rates version and are used for foreign money fees, price, possession records, and many others.

Types of Reporting Models:

Consolidation
Finance
Generic
Types of Non Reporting Models:

Rate
Ownership
SAP BW on HANA Interview Questions
Question 24. Can We Do Reporting On Non Reporting Models And Assign Work Status?

Answer :

You can do reporting on non-reporting models however you can't assign work repute to them.

SAP FICO Interview Questions
Question 25. To Perform Inter Company Elimination, Which Dimensions Should Be Defined And What Properties Should Be Created For These Dimensions?

Answer :

To perform foreign money conversion and intercompany eliminations, you need a size type - Intercompany measurement (I). To execute intercompany elimination, an application must have the subsequent:

Dimension Type “I” for intercompany removal.
Dimension “I” must consist of a belongings ENTITY.
Account size have to encompass the assets ELIMACC.
Entity measurement ought to include the property ELIM.
You ought to set the ideal business tables.
There ought to be DPT bundle to execute intercompany common sense need to be available.
SAP BODS Tutorial
Question 26. When Bpc 7.5 Nw Is Available?

Answer :

The 7.5 model is presently within the ramp-up stage and should be to be had in few months. I am no longer certain of the precise month.

Sap Bapi Interview Questions
Question 27. Bpc For Nw Has An Aggregation Level Or Not, Is Bpc An Application On Top Sap-ip?

Answer :

BPC and IP have completely different architecture. BPC doesn’t use aggregation tiers or filters. BPC and IP haven't any relation and therefore, can not be as compared. BPC uses numerous script logics, business rules for doing the making plans. Manual planning may be accomplished with enter schedules. The enter schedules are on excel platform and are quite flexible. You can use BPC functionalities at the side of native excel functionalities for higher design of the input schedules.

SAP BW Interview Questions
Question 28. What About Bpc In Consolidation Part?

Answer :

BPC comes with pre-introduced components for consolidation, which may be leveraged on. There are few business policies, which make the consolidation process less complicated.

SAP BW on HANA Tutorial
Question 29. What Is The Concept For Plan Data From Bpc?

Answer :

The concept of making plans is similar to you have in another tool. The practical aspect of the planning remains the equal. However, the device differs. The way you configure a making plans scenario will be tons specific than some other planning tool. Unfortunately, it'll not be possible to deal with this inside the discussion board. You can certainly undergo the observe substances for a higher know-how.

Sap Business One Interview Questions
Question 30. Bpc For Nw Need To Install .Internet Application Server And Web Server Or Not?

Answer :

Yes. You will have a observe the installation guide available on market place for specified necessities.

Question 31. What Is Bpc Client Tool? And If I Planning On Bex Report, I Have To Create An Aggregation Level For Planning Data Or Not?

Answer :

BPC customer sits on the consumer machines, from in which; you'll be doing the layout. There are specially three interfaces to be had - BPC Admin, BPC Office, and BPC Web. BPC Office, in turn has three interfaces - Excel, Word, PowerPoint. These interfaces may be used for various requirements.

Question 32. Can You Debug The Data Manager Package?

Answer :

UJD_TEST_PACKAGE .You need to specify the User ID .The DM bundle may be decided on with F4 .

Question 33. What Are Scoping Commands?

Answer :

The following keywords can be used to adjust the scope:

*XDIM_MEMBERSET Overwrites the scope for that size *XDIM_ADDMEMBERSET Add contributors to the scope of that measurement
*XDIM_FILTER Filters the contributors of the scope of that measurement 
*XDIM_MAXMEMBERS Specifies the most wide variety of individuals that have to be blanketed in a single query (in keeping with size)
SAP PS Interview Questions
Question 34. What Are System Variables?

Answer :

%USER%: Returns modern SAP Business Objects Planning and Consolidation User
%APPSET%: Returns modern SAP Business Objects Planning and Consolidation AppSet (Application Set)
%APPLICATION%: Returns modern SAP Business Objects Planning and Consolidation Application
%YEAR%: Returns present day calendar year.

Question 35. What Is The Difference Between Evgts And Evsnd?

Answer :

EVGTS: The EVGTS (Get value and scale) characteristic retrieves a facts value primarily based on the desired participants, and scales the price if the dimensions property is enabled on the size. The document templates furnished within the sample application set have a scale reference in the Control Panel location of the template.

EVSND: EVSND This Send function references any other mobile and sends its price to the database while you pick out Send and Refresh Schedules. The parameters specify the size that identify in which the information cost is to be sent in the database. EVSND returns the cost from the database to the referenced cellular. You do now not need to add any EVGET capabilities to the sheet to return values to the cellular. Since the values are again to the referenced mobile, BPC sends best the cells which have modified because the final send inside the present day session. By placing the formula within the EVSND cellular and no longer inside the enter cells, you decrease the chances of your formulation getting overwritten or erased. To similarly defend the formulas, you could want to hide the EVSND cells within the enter agenda. This feature takes individuals that not targeted from the modern view settings.

Question 36. What Is The Difference Between Drilldown And Drillthrough?

Answer :

Drilldown is extraordinary than drillthrough. Drill down is used to drill down on member records inside dimensions. You can drill down on members in a worksheet, or you may drill down on charts and graphs. Drill down is conducted within one report in the Excel interface whereas drill through is a 'bounce' outside of the Excel Interface.

SAP APO Interview Questions
Question 37. What Are The Options Of Drill Through ?

Answer :

Jump to any website Jump to a BW question Jump to ECC tcode.

Question 38. What Steps Are In Processing A Dimension?

Answer :

Processing a dimension will execute the following steps:

Validate Hierarchy.
Validate Dimension member formulas.
Update member facts into BW.
BW Attribute change run.