BPC (Business Planning and Consolidation) Interview Questions
In SAP BPC, how can you define the usefulness of Logic Scripts?
Logic Scripts are primarily defined as a set of SQL or MDX programming structure meant for performing few customized functions for the purpose of managing data models along with flexibility. When few of the specific requirements are not attained by virtue of using business rules, those can be achieved by using the Logic Scripts.
Please tell what are the two version available for SAP BPC?
The two versions available for SAP BPC are:
- SAP BPC NetWeaver
- BPC MS
What is BPC client tool? If I plan the BEx report, am I required to create an aggregation level for planning data or not?
You will be required to manage the design part, BPC client sits on the client machines.
There are primarily 3 interfaces available
- BPC web
- BPC Admin
- BPC Office.
There are 3 interfaces in BPC office namely
All these interfaces can be utilized for different requirements.
In SAP BPC, what is the usage of Logic Scripts?
Logic Scripts has been defined as a set of SQL or MDX programming structure which are meant for performing 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 usage of Logic Scripts.
In SAP BPC, what is Model ?
For meeting therequirements within an organization, in an environment, the user is required to build a model and this stated as a collection of various dimensions.
What are various SAP BPC built-in functionalities?
The various built-in functionalities delivered BPC (Business Planning and Consolidation) are:
- Strategic Planning
Can we use VB script in Netweaver BPC?
No, VB script cannot be used in NetweaverBPC
What are the various components of BPC security ?
The following components for BPC security are:
- Member access profile
- Task profile
Define the various pre-requisites (on the server side) used for installation in SAP BPC 10.1?
For installing the software, the user requires SAP NetWeaver BW 7.4 SP05 as a basis along with SAP UI5 1.16. All the databases which are supported by BW – i.e. few some traditional databases and SAP HANA.
For BPC 10.1, what is the BW release required?
For both BPC 10.1, the embedded and standard the minimum BW release is BW 7.40 SP5.
For BPC 10.1, Is HANA DB a mandate?
BPC 10.1 Standard has provisions for supporting both HANA DB and non-HANA DB. The Embedded BPC 10.1 only supports HANA DB.
Which version of HANA SP is essential for BPC 10.1?
HANA SP7 is required for BPC 10.1 and BW 7.40 SP5 requires HANA SP7. Incase the customer is only utilizing BPC , then is software component CPMBPC required to be installed.