|
|
1 |
In the Context of BPC, Explain actual data with example? |
|
|
2 |
In the Context of BPC, Explain plan data with example? |
|
|
3 |
In the Context of BPC, Explain forecast data with example? |
|
|
4 |
In the Context of BPC, Explain outlook data with example? |
|
|
5 |
In the Context of BPC, Explain budget data with example? |
|
|
6 |
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? |
|
|
8 |
What the “ACTUAL” Transaction data required for GPM (Gross Margin Planning) for a
company like Wal-Mart? |
|
|
9 |
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). |
|
|
|
|