Course List
Knowledge Base
Public Schedule
Enrollment

Events Registration
100's of SAP Certified EPM/BPC Professionals
Our Recent SAP EPM/BPC Certified Graduates
...100's of SAP Graduates
 
SAP NetWeaver BPC 7.0 Competency Development Program – Certification Quiz
We differentiate our training from others by delivering role based SAP Instruction rather than SAP Product focused Training.
   
In the Context of BPC, Explain actual data with example?
   
In the Context of BPC, Explain plan data with example?
   
In the Context of BPC, Explain forecast data with example?
   
In the Context of BPC, Explain outlook data with example?
   
In the Context of BPC, Explain budget data with example?
   
In the Context of BPC, Explain GL data with example, and explain the use of GL data in BPC?
   
7
In the Context of BPC, Explain COPA data with example, and explain the use of COPA data in BPC?
   
What the “ACTUAL” Transaction data required for GPM (Gross Margin Planning) for a company like Wal-Mart?
   
What the “ACTUAL” Transaction data required for Sales for a company like Wal-Mart?
   
10 
What the “ACTUAL” Transaction data required for P&L Planning for a company like Wal- Mart?
   
11 
What the “ACTUAL” Transaction data required for Balance Sheet Planning for a company like Wal-Mart?
   
12 
What the “ACTUAL” Transaction data required for Cash Flow Planning for a company like Wal-Mart?
   
13 
What the “ACTUAL” Transaction data required for COGS planning for a company like Wal- Mart?
   
14 
What the “ACTUAL” Transaction data required for HCM planning for a company like Wal- Mart?
   
15 
What the “ACTUAL” Transaction data required for Legal Consolidation for a company like Wal-Mart?
   
16 
What the “ACTUAL” Transaction data required for COI for a company like Wal-Mart?
   
17 
What is Full P&L for a company like Wal-Mart?
   
18 
Explain Flow dimension with example?
   
19
Explain Monthly, Quarterly and Half Month Closing Proces
   
20 
Explain Local, Transaction, Report, and Group Currency?
   
21 
In the Context of BPC Consolidation, Explain the following with examples?
 
a. Company Code
b. Business Area
c. Business Units
d. Profit Center
e. Primary Cost Center
f. Secondary Cost Center
g. GL account
h. Chart of Account
i. Cost Elements
j. Legal Entity
k. Inter Company
   
22 
In the Context of BPC, Explain cost allocation, activity based costing, fixed cost, variable cost and product costing?
   
23
In the Context of BPC, What are Equity, Minority Interest, US GAPP, and UK GAPP?
   
24 
What are the Dimensions required for each of the following planning for a company like Wal-Mart?
 
a. Balance Sheet
b. Full P&L
c. Cash Flow
d. Cost Center
e. Sales Volume
f. Sales Revenue
g. GMP
h. Operative Expense
i. HCM
   
25 
What are the Hierarchies required for each of the following planning for a company like Wal-Mart?
 
a. Balance Sheet
b. Full P&L
c. Cash Flow
d. Cost Center
e. Sales Volume
f. Sales Revenue
g. GMP
h. Operative Expense
i. HCM
   
26
What is the difference between Management and Statuary Reporting; also explain with example for a company like Wal-Mart?
   
27
What are the Applications required for each of the following planning for a company like Wal-Mart?
 
a. Balance Sheet
b. Full P&L
c. Cash Flow
d. Cost Center
e. Sales Volume
f. Sales Revenue
g. GMP
h. Operative Expense
i. HCM
   
28 
What are the Primary Business Objectives for each of the following planning for a company like Wal-Mart?
 
a. Balance Sheet
b. Full P&L
c. Cash Flow
d. Cost Center
e. Sales Volume
f. Sales Revenue
g. GMP
h. Operative Expense
i. HCM
   
29 
What is the difference between Legal and Profit Center Consolidation?
   
30 
Explain the consolidation process in details (the tasks that are performed during consolidation?
   
31 
Which of the following statements are TRUE?
 
a. ApShell is the delivered application set used as a starting point for client implementations only in SAP BPC NW 7.0.
b. Objects within an AppSet are shared with other AppSets.
c. You begin by copying an existing application set, and then you customize the application set by creating new applications, dimensions, and members.
   
32 
Which of the following statements are TRUE?
 
a. Measures allows you to change the view of your data
b. Measures – time-related views of transaction data, such as Period, Quarter tion n to data, and Year to date.
c. ApShell measures are: Periodic, Quarter To Data, and Year To Date.
d. Most source systems store balances on a periodic basis (whether it is daily, weekly, monthly, fiscal periods, etc).
   
33 
Which of the following statements are TRUE?
 
a. Every dimension in the cube has a dimension member posted in every record and each one is a base level member. Base level members don't have children.
b. Transaction Data is stored in Applications (Cubes).
c. An SAP Business Planning and Consolidation application can be described as being similar to an InfoCube in SAP NetWeaver
d. In SAP NetWeaver, the different types of objects that can be used to store data (or report on views of data) are called InfoProviders.
   
34
ApShell Content:
 
a. InfoArea named /CPMB/APSHELL
b. SAP_BPC_ADMIN , SAP_BPC_SYSADMIN
c. InfoArea: /CPMB/IOBJGEN
d. InfoObject catalog (/CPMB/IOBJGEN)
e. Task and Member Access Profiles
f. Business Rules
g. BPF
   
35 
The _______________ is an important tool to log to different application sets and to set the default set.
   
36 
Which of the following steps are executed When you create a new AppSet
 
a. Copy the AppSet WebFolders/Data within File Service
b. Creates a copy of all NW BW Objects (different technical names)
c. Moves all data to copied AppSet from source AppSet (both transactional as well as master data)
d. Copies Security and BPC metadata
   
37 
____________________ It logs all RFCs from the .NET tier to the ABAP tier. It is a is new in SAP Business Planning and Consolidation 7.0,version for SAP NetWeaver.
   
38 
_____________________ program can be used to check the transport entries of an AppSet.
   
39 
____________________ program can be used to check the consistency for an AppSet.
   
40 
____________ , _______________, _______________, _____________ Dimensions are required in every application
   
41 
Application Create Vs. Copy – Which are TRUE?
 
a. Create and Copy both require you select a “template” application to copy from
b. The major difference then is that Copy will actually copy the data, and you can not change the dimension assignments when copying, while Create allows you to change dimension assignments, but not copy data.
c. When choosing Create, the documents stored in the file system from the Source application will be copied.
d. If the Application Type is Financial or Consolidations, then Journals are also copied during Create.
   
42 
Technically the following operations are realized as _______________ and will technically be executed in a Background Mode, You can use job log in transaction code _____________ to view the detailed log information and progress of these jobs.
 
a. Copy Application
b. Modify Application
c. Optimize Application
d. Copy AppSet
   
43 
Planning applications must reference a _________ application.
   
44 
A dimension can also be flagged as a ___________dimension during modifying an application process which means that a kind of ______________ is created for it, which means security can be controlled through Member Access Profiles.
   
45 
Which of the following Statements are TRUE?
 
a. You can report on non-reporting application data, but you cannot assign work status codes to the data.
b. In addition, you cannot define business rules to these application types.
c. Reporting applications require the four dimension-types: Entity, Account, Rate, and Category but non-reporting types do not.
d. To delete a dimension from an application Set, it is necessary to first delete all the dependencies of that dimension from the application.
   
46 
Back-end InfoProviders- Which of the following are TRUE?
 
a. InfoProvider definitions for an SAP Business Planning and Consolidation application can be seen in SAP NetWeaver using transaction RSA1.
b. Transaction RSDCUBE provides more information about the cubes.
c. The InfoObjects in the BPC-Cube are the same as in “normal” BI cubes: 248 characteristics per BI-dimensions and 13 possible BI-dimensions!
d. To be an Planner you can use the primary admin Task Profile or the System admin Task Profile or create your own Profile but adding the APPLICATION task
   
47 
___________will run a number of technical steps on the SAP NetWeaver BI InfoCube in an attempt to improve performance
   
48 
There are two different type of optimization available 1. Light Optimize 2. Full Optimize
 
a. Light Optimize: ____________________________
b. Full Optimize: ______________________________
   
49 
Full Optimize will check whether the data model of the Business Intelligence (BI) Cube is built appropriately. Specifically, it will check: _____________________
   
50 
Sequence the implementation steps - If the cube structure can be optimized, then we will:
 
1. Take AppSet Offline
2. Bring AppSet back Online
3. Create a Shadow Cube with Optimal Data Model
4. Move data to shadow cube, delete original cube
5. Close Open Request, Compress and Index the Cube, and Update Database Statistics
   
51 
____________ has been mandated by the US Securities and Exchange Commission. The SAP BusinessObjects Planning and Consolidation applications possible solutions include exporting data to a 3rd party tool called BMatrix. Or, exporting the data to a BW InfoCube and have the XBRL application access the data via a BW Query.
   
52 
Fill the blanks
 
a. IFRS stands for _________________________
b. IAS stands for _________________________
c. FASB stands for _________________________
d. IASB stands for _________________________
   
53 
Which of the following are standard business rules?
 
a. Currency Conversion
b. Account Transformation
c. Intercompany Booking
d. Automatic Adjustment
e. Carry-forward
f. US Elimination
   
54 
Match the Following
 
1. InfoArea - Signed Data
2. InfoCube - Templates
3. MultiProvider - Property
4. Characteristics InfoObjects - Member
5. Characteristics Value - Dimensions
6. Attribute - Application
7. Query - Cube or Application
8. Key Figure - Application Set
   
55 
Match the following
 
1. Account = Inter Unit Eliminations and COI Entries.
2. Category = Reclassifications.
3. Datasource = Methods.
4. Entity = additional sub assignments.
5. Groups = Trading Partner.
6. Intercompany = consolidations groups and currency.
7. Additional user defined dimensions = consolidation unit.
8. Business Rules = Posting level and document type.
9. Account transformations = Version.
10. Automatic Adjustments = Item.
   
56 
Which of the following are TRUE
 
a. Applications are InfoCubes in BW.
b. Applications have multiple dimensions and they have multiple properties.
c. The dimensions are characteristics and the attributes are navigational.
d. The Legal application is equivalent to the InfoCube we define in the
e. databasis.
f. The Rate application would equal the TCURR table.
   
57 
ECCS stands for __________________ (ECC Based), BCS stands for ________________(BW Based).
   
58 
Which of the following are correct statements regarding what is delivered or available with the NetWeaver release?
 
a. Business Process Flows are not in the NW 7.0 but may be in the 7.5 release.
b. The Dynamic Hierarchy Editor is not in the 7.0 release but the data can be easily entered via input templates.
c. The NW release features the availability of various data bases and also the use of the BW Accelerator.
d. Time dependent hierarchies in Business Planning and Consolidation are not supported in 7.0.
e. Transports are only available with Microsoft releases.
f. NW features debug capability of script logic.
   
59 
Which of the statements below are correct in regards to BW?
 
a. InfoCubes are made up of Fact and Dimension tables.
b. A BW Dimension table is exactly the same as an Business Planning and Consolidation Dimension.
c. BW Characteristics have three potential types of master data.
d. There are two main types of InfoObjects: Catalogs and InfoAreas.
   
60 
Sequence the following Task in the BPC implementation Order
 
a. Create Input Schedules
b. Create Reports
c. Create The AppSet
d. Create/Setup Data Manager Package
e. Create/Setup Llgic
f. Create Dimension
g. Create Application
h. Create/Setup Business Rules
i. Update Rate and Ownership Data
j. Setup Work Status
   
61 
What Applications do you need for Consolidation as mandatory application?
 
a. Legal
b. Ownership
c. Rate
d. Intercompany Matching
e. Finance
   
62 
True / False - Although all applications can be reported on using normal BPC excel, the applications are referred to in this manner because support applications such as rate and ownership cannot be reported on using Insight (Insight is the infrequently used predictive analytics tool)
   
63 
When you create new applications, you need to select at least one _______ dimension. Then the member access profiles need to allow access to the desired members.
   
64 
What is the Year to Date values.
 
  JAN FEB MAR
Periodic 100 200 0
YTD ??? ??? ???
   
65 
True / False - C, A, E, I can be referenced to other dimensions to provide validation of members which are property valuesin other dimensions. Category can be referenced to a Time type dimension. That means that the property 'Year' in the Category dimension must exist in the time dimension. Account can be referenced to another account type dimension. (the rate type property in the account dimension must exist as a member in the referenced dimension.) Entity can be referenced to a Currency type dimension. (local currency in the entity dimension must exist in a currency dimension if it is referenced.) Intercompany can be referenced to an Entity type dimension. (Entities are property values in an Intercompany dimension).
   
66 
Which of the following are General Dimension Properties?
 
a. CALC
b. ACCTYPE
c. CURRENCY
d. ENTITY
e. EVDESCRIPTION
f. FLOW_TYPE
g. HIR
h. HLEVEL
i. LEVEL
j. PERIOD
k. REPORTING
l. RATETYPE
m. SCALING
n. YEAR
o. SOLVE_ORDER
p. SOLVE_ORDE
   
67 
You can validate the __________ property of the ACCOUNT dimension type by choosing any dimension of dimension type ACCOUNT as a reference dimension of ACCOUNT. This will ensure that the valid values of the RATETYPE property for ___________ are valid members of the reference dimension you choose.
   
68 
You can validate the ________ property of the CATEGORY dimension type by choosing any dimension of type TIME as a reference dimension. This will ensure that the YEAR property of the CATEGORY dimension has a valid value by checking the value against the _________ property of the dimension type TIME that you select.
   
69 
Dimensions Type By Application Mapping [ Note : Use “Yers/No” ]
  _____________________________________________________
Legal            Intercompany            Owner Rate         Matching _____________________________________________________
 
1. Account
2. Sub Tables
3. Category
4. Entity
5. Inter company
6. Time
7. Rate
8. Data Source
   
70 
Which of the following statements are TRUE?
 
a. Account examples include: Balance sheet, Income Statement, Cash Flow,and Validation Accounts.
b. ICAccount consists of the normal account ids but may also have additional hierarchy roll-up ids as well for analysis purposes in the ICMatching application.
c. Rate (Currency) examples include AVG, END and possibly others such as HIST.
d. Category examples include Actual, Plan, Budget, Forecast, Estimates. Entity examples include legal entities such as C1000 and groups such as H1, CG1, CG2.
e. RateEntity examples include: Global. This is the entity type dimension of the Rate application.
   
71 
Gross Margin, Above Gross Margin , and Return on Net Assets are ___________
   
72 
What are the Standard Account Types ?
  1. _______________
2. _______________
3. _______________
4. _______________
   
73 
TRUE/FALSE - Flow Dimension which is used to break down the account activity or flow. For example, some accounts like fixed assets have a subtable dimension containing opening, additions, deletions, transfers, and ending balances.
   
74 
The Main (Group) Properties are:
  a. ________________________
b. ________________________
c. ________________________
d. ________________________
e. ________________________
   
75 
Loading Master Data, Choose the best Options
 
a. Flat File Via DM
b. BW ETL Via Process
c. Manual Data Entry into Member Sheet
d. Manual Copy and Paste into Member Sheets
   
76 
Processing a dimension will execute the following step
  a. _________________________
b. _________________________
c. _________________________
d. _________________________
   
77 
Which is True?
 
a. When you process a dimension, you can choose to process ‘from the member sheet’. This means that when you process a dimension, the values to save back to the master data of the SAP NetWeaver BW InfoObject are taken from the Excel sheet you currently have open on your client machine.
b. If you do not select ‘from the member sheet’, it assumes you have already chosen to save the sheet to the server before processing and therefore the BW master data is updated from the sheet on the server.
   
78 
Four Different Type of Logic are
  a. _________________________
b. _________________________
c. _________________________
d. _________________________
   
79 
You will have two files for each script logic you create:
 
a. .LGF: This file contain ____________________________________
b. .LGX: This file contain ____________________________________
   
80 
______________ is a special logic statement that is executed on every writeback to an application. All logic in ________.LGF is run after data sends. Having all of your logic in the _________.LGF logic file might become unmanageable. Therefore you can create other logic files, such as FXTrans.LGF for foreign currency translation and .ICElim. LGF for intercompany eliminations (if on the Microsoft Platform).