Interview Questions.

Q1. What Are The Two Version Available For Sap Bpc?

SAP BPC NetWeaver

BPC MS

Q2. 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 purchaser sits at the patron machines, from wherein; you will be doing the layout. There are especially 3 interfaces to be had - BPC Admin, BPC Office, and BPC Web. BPC Office, in turn has 3 interfaces - Excel, Word, PowerPoint. These interfaces can be used for diverse necessities.

Q3. What Is The Use Of Transformation File? What Are The Different Sections In A Transformation File?

Transformation record provides the mapping of fields from BW to BPC and is an excel document in BPC. It contains transaction statistics from InfoObjects in BW with BPC dimensions defined in the management console.

There are 3 sections described for mapping file:

Options: Contains the general settings.

Mapping: Used to assign size in BPC gadget with a source column in BW InfoObject.

Conversion: Contains the link of different Excel sheets to apply the conversion recurring.

Q4. How Is Auditing Done In Sap Bpc? What Are The Different Audit Reports That Can Be Pulled For Audit Purpose?

Audit capabilities allow you to create reviews that incorporates history of consumer periods and device information.

You can create Audit reviews on the following topics:

Business Process Flows: You can create those reports 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 below widespread.

Work Status

Administration Activities

Comments

Data Changes

Q5. What Is Model In Sap Bpc?

To meet the Business Planning and Consolidation requirement of an agency, you want to construct a version in an environment, that is described as a collection of numerous dimensions.

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

Q7. What Are The Key Components In Bpc Architecture?

Requirement: SAP NetWeaver ABAP 7.Three or 7.31

Database: Any of the above version of SAP NetWeaver help.

Operating System: Any supported model of SAP NetWeaver system and database engine.

Q8. Can We Do Reporting On Non Reporting Models And Assign Work Status?

You can do reporting on non-reporting fashions but you can not assign work reputation to them.

Q9. Bpc For Nw Need To Install .Internet Application Server And Web Server Or Not?

Yes. You may have a have a look at the set up manual to be had on market location for distinctive necessities.

Q10. What Are The Key Advantages Of Using Bpc Ms?

Dimension Logic: This may be configured in BPC gadget using simple mathematical formulas.

Business Rules: This permits you to create guidelines in BPC gadget to perform particular capabilities.

K2 Script Logic: This is used to perform a few specific capabilities that could’t be finished the usage of out-of-container capability to satisfy the commercial enterprise requirements. You can create K2 script logics to carry out sure features, which may be achieved in a preferred system.

Q11. What Is The Concept For Plan Data From Bpc?

The concept of making plans is similar to you've got in any other tool. The useful side of the planning remains the same. However, the device differs. The way you configure a making plans state of affairs can be a lot exclusive than any other making plans tool. Unfortunately, it'll now not be viable to cope with this inside the discussion board. You can absolutely undergo the have a look at substances for a higher know-how.

Q12. What Is The Difference Between Drilldown And Drillthrough?

Drilldown is different than drillthrough. Drill down is used to drill down on member statistics inside dimensions. You can drill down on contributors in a worksheet, or you could drill down on charts and graphs. Drill down is conducted within one report within the Excel interface while drill via is a 'bounce' out of doors of the Excel Interface.

Q13. Which Databases Are Supported By Sap Bpc With Netweaver Version?

This layer is responsible to save all the information in database. SAP NW back-stop gadget is accountable to create gadgets and records stored for BPC system. NetWeaver supports most of the databases like SQL Server, DB2, Oracle, and many extra.

Q14. What Is Difference Between Reporting Model And Driver And Rate Model?

We use reporting models for evaluation motive. Non Reporting modules encompass Driver and Rates model and are used for foreign money costs, rate, ownership facts, etc.

Types of Reporting Models:

Consolidation

Finance

Generic

Types of Non Reporting Models:

Rate

Ownership

Q15. What About Bpc In Consolidation Part?

BPC comes with pre-brought components for consolidation, which may be leveraged on. There are few enterprise guidelines, which make the consolidation process less difficult.

Q16. Can You Debug The Data Manager Package?

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

Q17. Bpc For Nw Has An Aggregation Level Or Not, Is Bpc An Application On Top Sap-ip?

BPC and IP have completely exceptional structure. BPC doesn’t use aggregation ranges or filters. BPC and IP have no relation and for that reason, can't be compared. BPC makes use of diverse script logics, commercial enterprise guidelines for doing the planning. Manual planning may be carried out with enter schedules. The input schedules are on excel platform and are quite versatile. You can use BPC functionalities together with native excel functionalities for better design of the enter schedules.

Q18. What Are System Variables?

%USER%: Returns modern SAP Business Objects Planning and Consolidation User

%APPSET%: Returns current SAP Business Objects Planning and Consolidation AppSet (Application Set)

%APPLICATION%: Returns modern-day SAP Business Objects Planning and Consolidation Application

%YEAR%: Returns contemporary calendar year.

Q19. When Bpc 7.5 Nw Is Available?

The 7.5 model is presently within the ramp-up degree and must be available in few months. I am now not positive of the exact month.

Q20. How Can You Migrate Evdre Reports Created By Bpc 7.5 Excel To Bpc 10.0?

Go to EPM Ribbon → More → EvDRE Migration.

Q21. What Is The Use Of Work Status? What Are The Key Attributes In Defining Work Status?

Work status is used to lock a area of data in a version. This is used to override the consumer’s member get entry to privilege to write down to a selected area.

There are multiple dimensions described for a place with one property known as as OWNER. While defining the work fame, following are described:

Work States: It belongs to bodily kingdom of information.

Security: You can set one-of-a-kind degrees of protection on converting facts inside the machine –All or Locked. You can set who can exchange the paintings kingdom − Manager or Owner.

Data Update: This defines how facts can be up to date by the customer.

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

Q22. What Are The Key Benefits Of Using Sap Bpc With Netweaver?

Star Schema for Exceptional Reporting : SAP BPC uses NW InfoCubes to shop the facts. The dimension version used is prolonged Star Schema so it makes BPC with NW device an tremendous device for reporting.

No Database Dependence Version: BPC NW version isn't always depending on database version and can run common databases like DB2, Oracle, SQL Server, etc.

BW Accelerator Support : SAP NetWeaver BW accelerator tool is an additional feature that can be used to enhance the overall performance of reporting in the device even if you are the usage of huge datasets. It in a roundabout way enables in saving the price for a agency as much less range of document overall performance issues are suggested.

BAdI Development and ABAP Support: SAP BPC with NetWeaver lets in you to use ABAP programming to expand K2 script common sense. It permits to create business add-in BAdi interface within the again-cease machine, which can be known as later from script good judgment evolved in BPC device. It allows in fixing the complicated enterprise requirements and decreasing the improvement time for an business enterprise.

Q23. What Are The Two Sections In Custom Menu Template?

Custom menu content material is described by two sections in custom menu template - Default phase and Menu item phase.

Q24. What Is The Use Of Conversion File? Name Different Sections In A Conversion File.?

A conversion report is used to apply the conversion policies for BPC dimension and is an Excel record. It incorporates 3 sections:

External: Contains the cost from external supply.

Internal: Contains the cost it need to be having for BPC size.

Formula: Defines the conversion formulation carried out to every file.

Q25. What Are The Requirements To Perform Simple Currency Conversions And Complex Currency Conversions?

Simple Conversion: 

There need to be a Rate software wherein you store the exchange quotes.

You need to have an account dimension, which incorporates RATETYPE.

Entity dimension must include a property CURRENCY.

FXTRANS logic must be to be had and DEFAULT good judgment have to encompass a name to FXTRANS logic.

Entity measurement need to include the property TRANSALATE_TO. 

Complex Conversion:

There should be a Rate application in which you save the alternate costs.

Application need to include a CURRENCY kind dimension.

There need to be assets REPORTING for the CURRENCY dimension.

Entity size need to encompass the property CURRENCY.

Account dimension ought to encompass assets RATETYPE.

FXTRANS logic should be available.

DEFAULT logic must encompass a call to FXTRANS logic.

Q26. How Standard Model Is Different From Embedded Bpc Design Model?

Embedded version isn't like Standard version and consists of statistics get admission to to all network customers. For Embedded design version, preliminary variations used have been SAP BW Integrated Planning and Planning Application Kit i.E. BW-IP and PAK.

In Standard version, BPC surroundings contains the BPC packages or fashions and each version generates a BW InfoCube which is hidden.

Q27. What Are The Options Of Drill Through ?

Jump to any internet site Jump to a BW question Jump to ECC tcode.

Q28. What Is The Difference Between Evgts And Evsnd?

EVGTS: The EVGTS (Get price and scale) characteristic retrieves a data cost primarily based on the desired contributors, and scales the price if the dimensions assets is enabled on the measurement. The report templates provided in the pattern application set have a scale reference in the Control Panel place of the template.

EVSND: EVSND This Send characteristic references another mobile and sends its price to the database while you pick Send and Refresh Schedules. The parameters specify the size that identify where the statistics value is to be sent inside the database. EVSND returns the value from the database to the referenced cellular. You do no longer want to feature any EVGET functions to the sheet to go back values to the cell. Since the values are lower back to the referenced mobile, BPC sends simplest the cells which have modified since the final ship inside the modern consultation. By putting the formula in the EVSND cell and now not inside the input cells, you lower the probabilities of your formulas getting overwritten or erased. To in addition guard the formulation, you may need to cover the EVSND cells within the enter schedule. This feature takes individuals that no longer certain from the present day view settings.

Q29. What Is The Use Of Dimension - R_acct (a), While Creating A Rate Application In Bpc?

R_Acct (A) is used for maintaining unique forms of Rate.

Q30. What Are Scoping Commands?

The following key phrases may be used to alter the scope:

*XDIM_MEMBERSET Overwrites the scope for that measurement *XDIM_ADDMEMBERSET Add contributors to the scope of that measurement

*XDIM_FILTER Filters the members of the scope of that size 

*XDIM_MAXMEMBERS Specifies the most number of contributors that need to be blanketed in one question (in step with measurement)

Q31. What Are The Options For Book Publishing In Bpc?

You can put up books to BPC web. Administrators and Power users have an option to create books of news by using gathering collection of news.

You can choose an output as Printer reproduction or .Pdf document, which can be saved at the server. You can use Book Publishing wizard for this. Go to ePublish choice and pick Book Publishing wizard from there.

Q32. To Perform Inter Company Elimination, Which Dimensions Should Be Defined And What Properties Should Be Created For These Dimensions?

To perform currency conversion and intercompany eliminations, you need a size type - Intercompany size (I). To execute intercompany removal, an utility should have the following:

Dimension Type “I” for intercompany removal.

Dimension “I” need to include a belongings ENTITY.

Account measurement ought to encompass the property ELIMACC.

Entity measurement need to encompass the property ELIM.

You should set an appropriate enterprise tables.

There must be DPT package deal to execute intercompany logic ought to be to be had.

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

C_Acct (A) − For keeping charts of account.

C_Category (C) − To define class.

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

Entity (E) − It contains the commercial enterprise unit used to derive system.

C_Datasrc (D) − Data Source Dimension.

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

Time (T) − Time in all dimensions.

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

Q34. What Steps Are In Processing A Dimension?

Processing a measurement will execute the subsequent steps:

Validate Hierarchy.

Validate Dimension member formulation.

Update member records into BW.

BW Attribute change run.

Q35. What Is Epm?

SAP Enterprise Performance Management (EPM) allows your agency to enhance its monetary and operational overall performance control. SAP EPM supports diverse functionalities with SAP Business Planning and Consolidation BPC-NW or BPC-MS like financial consolidation, financial statistics management, deliver chain performance control, approach management, and lots of different regions.

Q36. Which Design Models Are Available In Sap Bpc To Fulfill The Business Requirements?

Standard Model

Embedded Model

Q37. What Is The Syntax For Dimension Logic? Which Operators Can Be Used In Dimension Logic?

To define member dimension components, you have to placed a Square bracket around the dimension and there may be dot between .

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

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

Standard Arithmetic functions need to be used in dimension formulation - addition (+), subtraction (-), multiplication (*), department (/) - are utilized in SAP NetWeaver.

Q38. What Is The Use Of Logic Scripts In Sap Bpc?

Logic Scripts is defined as a hard and fast of SQL or MDX programming structure to carry out some custom designed capabilities for flexibility and control records models. When a few specific requirements aren't carried out using commercial enterprise regulations, those can be met by using using Logic Scripts.