SAP BPC 10.0 TRAINING VIDEOS WITH PROJECT CAL ME 91-8106855785

Currency Translation

Why do you need Currency Translation?
In big corporations it is quite common to find multicurrency financial models where a
large portion of the data is already in the desired reporting currency. For example, a
US based company may have facilities located in Germany and Canada which
require data to be loaded in their local currencies for internal reporting purposes.
However, for management and external reporting purposes financial statements are
prepared only in US Dollars (the reporting currency).
SAP BPC version for NW provides standard support for multicurrency translation
and reporting. The default configuration expects all data to be loaded in the local
currency (LC) and then translated into one or more common reporting currencies
depending on the requirement. However, if a significant portion of the LC data is
also in the main reporting currency used, there are alternative configurations
available that can dramatically improve currency conversion time and save disk

Currency Conversion
Currency conversion can be executed in three ways in SAP Business Planning and
Consolidation:
„ Automatically with each data submission (Default Logic).
„ Schedule as a separate task via a Data Manager package.
„ Through the consolidation monitor ( for consolidation type model only)
„ Examples of where the Data Manager method would be utilized would include:
„ Periodically (i.e. at the end of the day when all data has been entered).
„ After data import/loads.
„ Recalculate and update translated values on all existing data when conversion
rates are changed.
„ As part of a standard consolidation cycle, once data for all reporting units has
been submitted and validated.
Currency Conversion Setup
In order for the standard currency conversion function to work you must have the
following items in your Environment:
„ Rate model: used to store the currency rates used for translation into the reporting/group
currencies. The Rate model must be referenced to the calling model (i.e.: Planning or Legal
models)
„ Currency type “R” dimension: stores the reporting and input currencies for your organization.
„ CURRENCY attribute in the Entity type dimension: defines the local (functional) reporting
currency of the input/submitted values for the entity member.
„ Group dimension: stores one Member with the attribute “CURRENCY_TYPE” set to “N”.
„ RATETYPE attribute in the Account dimension: determines the rate and logic to be used in
translation of the given account (average, end of month, or none).
„ BUSINESS RULES for currency conversion which define the rates and logic to be applied to
each Account Rate Type.
„ SCRIPT LOGIC TASK to pass to the program the appropriate parameters.
„ An appropriate Data Manager Package to invoke the script logic.

Account Dimension
ACCOUNT :
-Must include the following attribute: RATETYPE
Examples:  AVG (defined in Rate model)
NOTRANS
<blank>
The value of the RATETYPE attribute must be a valid key member in the rule table for
currency translation, such as AVG, END, and ENDFL
Entity Dimension
ENTITY :
-Must include the following attribute: CURRENCY
Examples: EUR, USD, JPY
The CURRENCY attribute denotes the local currency for the current ENTITY. For
example, for ENTITY US, the currency is USD; for FRANCE, the currency is EUR. The
value of this attribute must be a valid member of the INPUTCURRENCY dimension.

DataSrc Dimension
DATASRC :
-Must include the following properties: DATASRC_TYPE, IS_CONVERTED
The DATASRC_TYPE attribute signifies the data source type. The following four values
are available:
I (input)
M (manual adjustment)
L (datasrc level, for consolidation only)
A (automatic adjustment or elimination)
When the IS_CONVERTED attribute is set to N or blank, members are ignored in the
conversion. When set to Y, members are converted from the local currency to the
desired currency.
RptCurrency Dimension
RPTCURRENCY :
-Must include the following master data ID: “LC”
-Must include the following properties: CURRENCY_TYPE
L (local currency)
R (Reporting currency)
T (Transaction currency) Optional

Group Dimension
Groups :
-Must include the following master data for CURRENCY_TYPE = “N”
-Must include the following properties: CURRENCY_TYPE
G (Group currency)
N (Non group)

Time Dimension
TIME :
-Must include the following properties: YEAR, PERIOD, TIMEID, MONTHNUM
The YEAR attribute contains the year information of the ID. For example, if the ID is
2008.AUG, YEAR is 2008.
The PERIOD attribute denotes the period to which the current time belongs. For
example, if the ID is 2008.AUG, PERIOD is AUG.
The TIMEID attribute is a numerical value for the current time. For example, for
2008.AUG, the TIMEID is 20080800.

RATE model – R_Acct Dimension
R_ACCT
-Must include an ID for the defined rates: such as “AVG”, “END”, etc.
-Must include the following properties:
ACCTYPE example: “AST”
RATETYPE example: “FX

Planning Environment Up
BUSINESS RULE
[AVG] = Ave Monthly Rate
Other key formulas:
[END] = month end rate
[AS_IS] = current rate
[HIST] = historical rate
As defined in “R_ACCT


RATE model – InputCurrency Dimension
INPUTCURRENCY
-Must include the following properties:
MD example: “M” or “D”
[Multiply or Divide the rate factor}
Blank entries
will Default to
“M”


RATE model – R_Entity Dimension
R_ENTITY
-Must include the following ID: “GLOBAL”
Keyword

SAP BPC INTERVIEW&CERTICATION QUESTIONS

BPC 7.5 INTERVIEW , CERTIFICATION QUESTIONS

39.What is Mdxlib.lgf.
MDXLibrary.lgf contains base examples of dimension formulas .
40.What is default logic file ?
Default.LGF file
Default Logic is a special logic statement that gets executed on every writeback to an
application.
41.What are .LGF and .LGX files ?
.LGF - an ASCII file that you use to create/edit your logic calculations and is accessed
through the Script Logic editor in the Admin Console.
.LGX - the compiled logic file. Created by the system when you validate and save
your logic. This is an executable version of the .LGF file. This is always generated on
the fly when you execute a .LGF file.
42.What are the major 7.5 enhancements ?
TMVL for time offset function
DESTINATION_APP now supports RENAME_DIM, ADD_DIM & SKIP_DIM
FOR/NEXT now supports variable
WHEN/IS/ENDWHEN support variable
ALLOCATION’s FACTOR now supports all basic mathematical functions with
USING & TOTAL
ELSE within WHEN/ENDWHEN now accumulates with original records
43. *XDIM_MEMBERSET TIME = 2006.AUG
*XDIM_MEMBERSET CATEGORY=ACTUAL
*DESTINATION_APP=DETAIL_PLAN
*SKIP_DIM = P_ACTIVITY
*ADD_DIM P_DATASRC=INPUT, PRODUCT = NO_PRODUCT, MARKET =
NO_MARKET
*RENAME_DIM P_ACCT=P_ACCTDETAIL
*WHEN CATEGORY
*IS "ACTUAL"
*REC(EXPRESSION=%VALUE%)
*ENDWHEN
What is SKIP_DIM command does?
What is ADD_DIM does ?
What is RENAME_DIM does ?
44.Allocation Function?
*RUNALLOCATION
*FACTOR=<driver>
*DIM P_ACCT WHAT=<source>; WHERE=<target>; Using=<distribution key>;
[Total=<distribution key>]
*DIM <other dimensions>
*ENDALLOCATION
Explain
Ø  WHAT
Ø  WHERE
Ø  USING
Ø  TOTAL
Ø  FACTOR
45.What are scoping commands ?
The following keywords can be used to modify the scope:
*XDIM_MEMBERSET
Overwrites the scope for that dimension
*XDIM_ADDMEMBERSET
Add members to the scope of that dimension
*XDIM_FILTER
Filters the members of the scope of that dimension
*XDIM_MAXMEMBERS
Specifies the maximum number of members that should be included in one query (per
dimension)
46.What command is used to update the records in the database ?
COMMIT .
47.Can you use data manager prompts in the script logic ?
TRUE or FALSE
Answer;TRUE
48.What are system variables ?
%USER% - Returns current SAP BusinessObjects Planning and Consolidation User
%APPSET% - Returns current SAP BusinessObjects Planning and Consolidation AppSet
(Application Set)
%APPLICATION% - Returns current SAP BusinessObjects Planning and Consolidation
Application
%YEAR% - Returns current calendar year
49.What are delivered measures ?
Ø  Periodic,
Ø  QTD,
Ø  YTD
50.What are custom measures ?
Using ABAP program UJA_MAINTAIN_MEASURE_FORMULA
51.Custom measures can be created using ABAp program – TRUE or FALSE.
52.What is the difference between EVGTS and EVSND
EVGTS : The EvGTS (Get value and scale) function retrieves a data value based on the specified
members, and scales the value if the scale property is enabled on the dimension. The report templates
provided in the sample application set have a scale reference in the Control Panel area of the template.
EVSND: EvSND
This Send function references another cell and sends its value to the database when you select Send and
Refresh Schedules.The parameters specify the dimensions that identify where the data value is to be
sent in the database. EvSND returns the value from the database to the referenced cell. You do not need
to add any EvGET functions to the sheet to return values to the cell. Since the values are returned to the
referenced cell, BPC sends only the cells that have changed since the last send in the current session.
By putting the formula in the EvSND cell and not in the input cells, you decrease the chances of your
formulas getting overwritten or erased. To further protect the formulas, you may want to hide the
EvSND cells in the input schedule.This function takes members that not specified from the current view
settings.
53. XDIM_MEMBERSET doesot allow
Properties.*SELECT is a second possibility to refer to properties needed in connection with the
XDIM_MEMBERSET statement.
XDIM_MEMBERSET doesot allow Properties.
XDIM_FILTER is one possibility to reference properties within the scope.
54. %DIMNAME_SET% is a variable which inherits the dimension member
from the current view. – TRUE or FALSE .
55.What are 4 types of methods to read the data ?
Ø  RSDRI
Ø  MDX
Ø  AXIS
Ø  CELL
56.What is UJSTATS tcode ?
- BPC statistics
57.How to switch on the stats and what is the web parameter ?
Application Web parameter called BPC_STATISTICS – Should be set to ON
58.What type of query EVDRE creates – RSDRI or MDX ?
59.What is the purpose of the program UJO_STATISTICS_DELETE ?
- To delete the stats table entries.
60. Cell queries have been moved to Axis Queries because they are faster even though they bring back
more data – TRUE or FALSE.
61. What is sparsity  coefficient ?
62. CoefficientPost BPC 7.0 SP3, the SparsityCoeffiecientis no longer used – TRUE or FALSE.
-TRUE
63. Custom suppression adds another EVDRE – TRUE o FALSE
-TRUE
64.What is the difference between DRILLDOWN and DRILLTHROUGH ?
Drill down is different than drill through. Drill down is used to drill down on member data within
dimensions. You can drill down on members in a worksheet, or you can drill down on charts and graphs.
Drill
down is conducted within one report in the Excel interface whereas drill through is a 'jump' outside of
the Excel Interface.
65.What are the options of DRILL THROUGH?
Ø  Jump to any website
Ø  Jump to a BW query
Ø  Jump to ECC tcode
66. The business rules are broken down into Appset and Application sections. In the application the
destination data source is assigned to the method in the automatic assignment
TRUE OR FALSE
-   TRUE
67. During first cons the diff between the investment and the parents share of subs equity Is written to
goodwill  .
TRUE OR FALSE
-   TRUE
68. The purchase method only adjusts the investment for market value changes in the subsidiary
TRUE OR FALSE
-   FALSE
69. The purchase method is typically used in the US where the parent has a majority of shares or has
controlling interest over the subsidiary .
TRUE OR FALSE
-   TRUE
70. Annual Net Income of the subsidiary is split between the parent and the minority shareholders
during subsequent consolidation activities .
TRUE OR FALSE
-   TRUE
80. When the consolidation program is executed, it reads dim prop, cons methods and percentages in
the ownership app.
TRUE OR FALSE
-   TRUE
-  
81. The dimlist property in the account dim can be used as a selection criteria for account to be included
in the source of the calculation .
TRUE OR FALSE
-   TRUE
82. The method assignments by entity and their percentages are read from the DHE
TRUE OR FALSE
-   FALSE
83.Dynamichieracgy Editor is available in NW BPC 7.5.
TRUE OR FALSE
-   TRUE
84.DHE is a user interface and data is stored in the cube ?
TRUE OR FALSE
-   TRUE
85. Main reason to consider using IC matching is that you want to do the matching on transaction
currency and you do not want to add this currency to the Legal App.
TRUE OR FALSE
-   TRUE
86. The IC booking function concentrates into each entity the declarations all other entities vs the
particular entity. This then allows the end users within each reporting entity to run a report which
matches all of its declarations against the balance of the other entities without assigning owner read
access to other entities.
TRUE OR FALSE
-   TRUE
87. The IC Matching App is a Financial Type with Currency Conversion and Intercompany Booking
business rules .
TRUE OR FALSE
-   TRUE
88. Running the ICDATA.LGF logic file via the corresponding ICDATA package runs intercompany
reconciliation .
TRUE OR FALSE
-   TRUE
89. Running the ICBOOKING.LGF via the ICBooking package runs intercompany reconciliation and posts
differences .
TRUE OR FALSE
-   TRUE
90. Setting up the Seller rule type in ICBooking Business Rules means that the seller will receive any
variances . TRUE OR FALSE
-   FALSE .
91. ICMatching postings happen at the group level.
. TRUE OR FALSE
-   FALSE .
92. ICMatching postings happen at the entity level.
. TRUE OR FALSE
-   TRUE.
93. US Elim entries happen at Group Level .
TRUE OR FALSE
-   TRUE
94. Automatic Adjust entries happen at Group or Group & Entity Level.
TRUE OR FALSE
-   TRUE
95. During IC Elim , in order to keep the BS of each Entity balanced, the reverse amount is booked to a
plug account .
TRUE OR FALSE
-   TRUE
96 The Plug/offset account should be balanced at  Entity level .
. TRUE OR FALSE
-   FALSE .
97. The Plug/offset account should be balanced at  Group level .
. TRUE OR FALSE
-   TRUE .
98. The Elim is written to a diff data src so that the initial value of the account is not overwritten .
. TRUE OR FALSE
-   TRUE .
99. A unique requirement while dealing with IC entries is that they should only be reflected in any given
group only if both the entity and partner entity which it was doing business with are a part of that
group.
. TRUE OR FALSE
-   TRUE .
100.
% of Ownership = Shares Owned/Shares Outstanding*100
% of Minority Interest = 100 –(Shares Owned/Shares Outstanding*100)
. TRUE OR FALSE
-   TRUE .
101. RUN CONSOLIDATION only performs the eliminations, as Currency Translation has to be run before
to populate the data in the Group Currencies .
. TRUE OR FALSE
-   TRUE .
102. the reverse amount is booked to a Plug account .
. TRUE OR FALSE
-   TRUE .
103. Processing a dimension will execute the following steps:
•   Validate Hierarchy.
•   Validate Dimension member formulas.
•   Update member data into BW.
•   BW Attribute change run.
104. Plug Account should be balanced at group level (only Intercompany missmatches are left).
TRUE OR FALSE
-   TRUE
105. ACCTYPE is required for account type dimensions and is used to control sign display and
aggregation behavior in reporting.
TRUE OR FALSE
-   TRUE
106. DIMLIST# properties are used as selection criteria in business rules.
TRUE OR FALSE
-   TRUE
107. Dimension  member formulas are defined at the Application Set level, thus they are valid
across all applications which use the dimension.
TRUE OR FALSE
-   TRUE
107.
Ø  // denote comments.
Ø  '*' indicates executable lines of code.
Ø  No '.' at the end of statements.
Ø  '#' is used in MDX statements to denote the receiver of the calculation
108. Use transaction code 'UJKT' to do logic debugging!
109. The NetWeaver logic files can be accessed by using the t-code UJFS.
110. Once the Consolidation User sees the validation account with a non zero value, they would know to
run the Validation package which performs customer derived validation checks and sets the validation
account back to zero.
TRUE OR FALSE
-   TRUE
111.In the conversion file : If you want to ignore external data (as listed in the External
column), you can place the keyword *skip in the Internal column.
TRUE OR FALSE
-   TRUE
-  
112. You can use the asterisk (*) and question mark (?) wildcards in the External or Internal columns. An
asterisk (*) stands for any character, while a question mark (?) stands for any single character.
TRUE OR FALSE
-   TRUE
113. If the source InfoCube has multiple key figures, the MVAL keyword can be used to import the data
in only one data load.
. TRUE OR FALSE
Ø  TRUE .
114. By adding an ‘ENABLEJRN’ property to any dimension, only the members with a ‘Y’ in that property
can be selected in journals.
. TRUE OR FALSE
Ø  TRUE .
115. If you have already created a journal template, creating a new  template that changes the structure
of the journal entries deletes the old template and all journal entries associated with that template.
. TRUE OR FALSE
Ø  TRUE .
116. The 'Driver' dimension is the one dimension per application whose members are used to compare
against other dimension members to see if they are permissible. There is only one driver dimension per
application but it can be used as a point of comparison with any other dimension in the application.
. TRUE OR FALSE
Ø  TRUE .
117. "Validation:The only operators are '<>' and '='. But you can include multiple single values separated
by commas.
. TRUE OR FALSE
Ø  TRUE .
118. Which of the following are true regarding the reversal of signs during data loads?
Choose the correct answer(s).
A If the source value is positive it will be reversed if it is an AST account type.
B If the source value is positive or negative it will be reversed if it is an AST account type.
C If the source value is positive or negative it will be reversed if it is an LEQ account type.
D If the source value is positive or negative it will be reversed if it is an INC account type.
E If the source value is positive or negative it will be reversed if it is an EXP account type.
F If the source value is negative it will be reversed if it is an AST account type.
119. Team
A group of users. Fairly equivalent to a NW role.
One user can be designated as a team leader.
120. It is the combination of member access profiles & task profiles that determine overall BPC access.
TRUE OR FALSE
Ø  TRUE
121.some important programs:
UJA_COPY_APPSET
UJA_APPSET_BAK_RESTORE
UJ0_STATISTICS_DELETE
UJA3_WRITE_SYS_ADMIN_NO_CHECK
UJA_REFRESH_DIM_CACHE
UJK_SCRIPT_LOGIC_TESTER
UJKT
UJT_CHECK_TABLE_ENTRIES will allow you to check table entries for transports
MDX Test
122. 52. Tables within BW system:
Tables associated with cube fall under /B28/F or E namespace
Tables associated with the ABAP fall under UJ namespace
All the BI objects would get created under /CPMB/ name space.
123.Comparison of Microsoft Analysis Server table to BW tables:
Open Request – Write Back table
Fact Table – Fac2 Table
E Table – Fact Table
124.You can find the tables through their technical names in Se16 TC.
TRUE OR FALSE
Ø  TRUE
125. Two types of Optimization:
Lite Optimize: will close the open request, compress and index the cube, and update database
statistics for the BI Cube. Moves the data from F-Table to E-Table
Full Optimize: will perform the same operations as Lite Optimize, but will also check the NetWeaver BI
data model. If the data model can be improved, Full Optimize will do so, and this could take a long time
to run (for
cubes with large data volumes). Data moves from F-Table to E-Table and also closes the Request ID’s .
126. data remodel is done in full optimization .
TRUE OR FALSE
Ø  TRUE
127.Compression is done in Lite and Full optimization.
TRUE OR FALSE
Ø  TRUE
128.
BPC 7.5 SP05 patch 1 increased formatting performance by 40%
TRUE OR FALSE
Ø  TRUE
129.You can change the BPC dimensions in the backend which BW.
TRUE OR FALSE
Ø  FALSE .
130.
Cell queries have been moved to Axis Queries because they are faster even though they bring back
more data.
TRUE OR FALSE
Ø  TRUE
131.
If multiple EVDRE’s are needed, the first EVDRE should be RSDRI in order to build the rows.
TRUE OR FALSE
Ø  TRUE
132. Work Status is set up from the Administrators at both the application set and application level.
TRUE OR FALSE
Ø  TRUE
133.Work Status is set only athe application level .
TRUE OR FALSE
FALSE
134. To use work state tracking, you must specify the hierarchy (H1, H2, H3, ...,Hn) within the owner
dimension for which you want to use work status.
TRUE OR FALSE
Ø  TRUE
135. You specify the hierarchy for which you want to track the work status of deliverables in the
APPROVALORG field on the Setting Application Parameters.
TRUE OR FALSE
Ø  TRUE
136. Work Status:You can define only one hierarchy for each application within an application set.
TRUE OR FALSE
Ø  TRUE
137.The work state “Locks Not Set” “is a Default work state” with internal code of “0” with “both” for
Controlled by. This work state must be the first and cannot be changed.
TRUE OR FALSE
Ø  TRUE
138. SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver allows setting any
combination of between 3 and 5 dimensions as relevant for locking, despite the dimension type. So
Work Status can also be configured for an Account type dimension.
TRUE OR FALSE
Ø  TRUE
139. Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version
for SAP NetWeaver.
TRUE OR FALSE
Ø  TRUE
140. There is a reporting function EVLCK available as well. This function provides a read only comment
retrieval for Work Status.
TRUE OR FALSE
Ø  TRUE
Ø  
141. Script logic statements are case-insensitive.
TRUE OR FALSE
Ø  TRUE
142. You cannot use MDX keywords in *REC.
TRUE OR FALSE
Ø  TRUE
143. REC always needs to be accompanied by WHEN / IS / ENDWHEN. Stand-alone REC statements do
not have any effect.
TRUE OR FALSE
Ø  TRUE
144. *FOR / *NEXT
*FOR / *NEXT is used to repeat certain scripts written between a FOR and an immediate NEXT for a set
of members. Sets of members can be provided either directly in the FOR statement or through variable.
The Logic Module supports any number of FORNEXT loops in the body of the logic files. The *FOR
Statement has to be accompanied by a variable. In the Example %KPI% is the user defined variable
which was used for the Loop.
145. The SELECT statement is fairly limited, as it only supports the equal sign (=) , not equal to (<>) and
cannot be used to combine multiple filter criteria with AND or OR keywords.
146. SELECTCASE structures currently CANNOT be nested.
147. WHEN/ENDWHEN which has a much better performance then *SELECTCASE.
148. The syntax for dimension member formulas requires a square bracket around the dimension and
the member and separated by a period. The only exception is with the account dimension, where only
the dimension member is needed.
Standard arithmetic functions are available, such as addition (+), subtraction (-),multiplication (*) and
division (/), as are the MDX keywords supported by SAP NetWeaver BW. New with SAP Business
Planning and Consolidation, upper and lower case letter sensitivity becomes important for dimensions
and dimension members, sobe careful in your formulas!.
148. The SAP Business Planning and Consolidation default Solve_Order is equal to 3 for measures and 5
for members.
149. SPREAD:The Spread modeling option allows you to take a value and allocate it among selected
destination cells. The value can be allocated equally, or it can be weighted by a range of values. For
example, you can take the value 100 and spread it across a number of columns that represent each
month of the year.
150. TREND:The Trend modeling option takes a value or percentage and grows it by a factor among
selected cells. This option places the source value in the first cell of the destination range. Each
subsequent cell in the destination increases by the amount or percentage specified.
151. WEIGHTED:The Weighted modeling option lets you allocate a set of values by weighted factors in
your spreadsheet. It allows you to take a set of values, grow them if desired, and then allocate the new
amount based on the relative weights of the selected cells. The destination range is the same as the
weight range. For example, you can weigh 12 months of revenue based on 12 months of cost of sales.
161. The comment feature must be turned on at the Application level for both methods.
162. EVCOM - Add a comment to a cell .
163.Comments are stored in
Ø  Cube
Ø  DSO
Ø  Real time cube
Ø  Table
Answer: Table
164. What are the reporting commands updates the data base:
-   EVDRE
-   EVGTS
-   EVCOM
-   EVBT
Answer: EVDRE & EVCOM
165. To use the excel popup feature for comments, you need to turn that on via th workbook options.
TRUE OR FALSE
Ø  TRUE
166. System Reports are pre-designed web reports, that allow you to report on system
information/activity, rather than transaction/master data in the system.You can report on:
• Activity Audit
• Data Audit
• Security
• Comments
• Work Status
167. A Distribution Template may contain the following fields:
• BOOK: the title of your distributed book.
• SECTION: denotes the beginning of a section.
• REPNAME: report filename, location and title (can also be for Input Schedules).
• FIXKEY: sets dimension members to the fixed values when generating the report
– For example, you can ensure that a report runs for 2008.TOTAL and
ACTUAL.
• VARYKEYS: lists the dimensions and dimension members that should vary for each report that will get
created.
– For example, if you want to create a new offline report for each Entity/Cost Center/etc, you would
specify that dimension as a Vary Key.
– You then map a specific Vary Key to a User ID who should receive that report (for example, the Cost
Center manager). This way, each user who gets a report has the required dimension(s) set to their
individual values
Note: If you wish to distribute by email, make sure an email address has been maintained for each user.
• SECTIONEND: denotes the end of a section.
168. Validations configuration is performed in transaction UJ_VALIDATION.
TRUE OR FALSE
Ø  TRUE
169. One driver dimension for each application for validation.
TRUE OR FALSE
Ø  TRUE
170.Only one is correct.
Ø  There can be n driver dimension or 1 app.
Ø  There can be only 1 driver dimension for 1 app.
Ø  There can be n driver dimensions for m apps.
Ø  There can be max 5 driver dimensions for a single app.
Ø  Answer : There can be only 1 driver dimension for 1 app.
171. Rules and Members are a N:N relationship (1 rule can be assigned to multiple members, and 1
member can be assigned to multiple rules).
TRUE OR FALSE
Ø  TRUE
172. You can turn validations on or off by application.
TRUE OR FALSE
Ø  TRUE
173. The EvUSR (User ID) function returns the name of the user who is logged on to the system.
174.TheEvAST (Application set) function returns the name of the current application set.
175.TheEvAPP (Application) function returns the current application name.
176.TheEvDES (Description) function returns the description of a specified member.
177.TheEvDIM (Dimension) function retrieves a dimension name of the specified type from the
database.
178.The EVPRO function returns the value of a specified property for a specified member.
179.TheEvRTI function returns the time and date of the last data refresh.
180.TheEvCOM function references another cell and sends its value, a textual comment, to the
database when specified.
181.TheEvHOT (hot link) function sets up a hot link to another report or cell withi another report. Hot
links can be used to guide a user through ad-hoc analysis.
182.TheEvGTS (Get value and scale) function retrieves a data value based on the specified members,
and scales the value if the scale property is enabled on the dimension.
183.This Send function references another cell and sends its value to the database when you select
Send and Refresh Schedules.
184.TheEvTIM (time period offset) function specifies an offset from a given time period.
185.You can double click on the EVCVW output to set the current view. EVDRE templates use the
EVCVW function in the page key range.
186.EVPRO is being used below to pull in the account type property. EVBET performs
186.A variance calculation based on the acctype value. For example, if revenue actual is greater than
plan, the variance if positive. However, if expense actual is higher than plan, the variance is negative.
187.EVBET is used to calculate variances in conjunction with the ACCTYPE property.
188. AVAILABLEFLAG Controls whether the system is offline or not. Yes means the system is online and
available for sending data to the database. You can take the system offline by changing the value to No.
(Required)
189. YTDINPUT This parameter controls whether data is input in year-to-date format. Valid options are
1, which means ytd format; or 0, which means periodic format. (Optional) YTDInputTimeHir This
parameter designates the time hierarchy that will be used by a YTD storage application. H1 is the
default.
190. If an application parameter is required, you can leave it blank to accept the default, but if you
delete the parameter, the system may not work correctly. If an application parameter is optional, you
can delete it if you wantto.
191.if the application parameter is required and it is blank then
Ø  System will crash
Ø  Will throw an error message
Ø  Gives a warning message
Ø  Leave it blank to accept the default.
192. You can set work status to top-down in the TOPDOWN field in the Application Parameters.
193. Work Status locks can allow you to lock down documents that have had the Application Context
specified.
194. There is an AppSet web admin parameter called “LANDINGPAGEITEM”, which allows you to
control what is viewed when you open the BPC Web “Getting Started” page (landing.aspx).
195. 'AS_IS' is key word that is supported in the formula field that means to leave a value untouched if
it is already in the destination currency. 'AS_IS' cannot be combined with anything other than '-1'.
'AS_IS' is used when you need a historical rate.
196.
END - uses the end of month rate as stored in the rate application.
AVG - uses the average rate as stored in the rate application.
COPYLC - translate the local currency to group or reporting currency with a
factor of '1.
OPEEND - the end rate of the last period of the prior year.
AS_IS - Leave untouched a value already in the target currency.
OPEAVG - the average rate of the last period of the prior year.
197.
Ø  Equity Method 30
Ø  Purchase method 86
Ø  Proportional Method 70
198. Generally speaking, if the ownership % is greater that 50% the purchase method will be used in
the US but the equity method is used if the amount is less than 50%. The proportionate method is
similar to the purchase method and is used more frequently in Europe.
199. A owns 80% of B company, 70% of C and 40 % of D.
Which company can use the quitymethod.
Ø  B
Ø  B & C
Ø  D
Ø  A
Answer : A company can use equity method.
200. The properties that begin with 'Org' all relate to the dynamic hierarchy editor.
201. Ownership data can be entered via the Dynamic Hierarchy Editor or via input templates.
202. There are five possible adjustment types: But typically this is blank except for Equity and
Proportionate.
• Generic
• Equity
• Proportional
• New (acquisitions)
• Leaving (divestitures)
203. In the NetWeaver release, the 'Groups' dimension is typically used whereas the  Microsoft release
referred to it as the 'Consolview' dimension.
204. The business rules are broken down into Appset and Application sections for Automatic
Adjustments – TRUE.
205. In the Appset, the Rules, Methods, and Formulas are defined. In the Application, the destination
datasource is assigned t the method in the 'automatic adjustments'. In the automatic adjustment
details, the source accounts, reversal signs, target accounts, and target flows, are specified .
206. A unique requirement when dealing with inter unit elimination entries is that they should only be
reflected in any given group if both the entity and the partner entity which it was doing business with
are part of the group.
207. The adjustment types include the same 5 rule types: Generic, Equity, Proportional, New, and
Leaving.
208. The consolidation method types include: New, Holding, Global, Proportional, Equity, Leaving @
the beginning of the year, Leaving @ the end of the year .
209. Any number of commit instructions can be entered in a logic file. However, the number of commit
instructions should be kept to the minimum, because they have a negative impact on the overall
performance of the logic execution due to increased communication between database and Script logic
engineThe ideal case is to have one commit at the end .
210.BPC supports compounded info objects .
TRUE OR FALSE
Ø  FALSE.
211.BPC doesn’t support compounded info objects.You have to write proper transformation .
TRUE OR FALSE
Ø  FALSE.
212.Data packages available are :
Standard Data Loading Packages
Financial Packages
Administrative Packages
Misc Packages
213. Import Hierarchy package…Only supports Overwrite mode, not update mode .The node name in
the hierarchies, after transformation, should be a existing members in BPC target dimension.Supports
reading hierarchies by time and version dependency, but not writing hierarchies to BPC by time and
version dependency.
214.Master data the BADI is based on the table level .
TRUE OR FALSE
Ø  TRUE.
215.Transaction data the BADI is based on the package level .
TRUE OR FALSE
Ø  TRUE.
216. Package Link is application based and can not be used across applications.
The packages in one package link are executed in sequence. If one package fails, then all subsequent
packages will not run.
217. What are the options available for transaction data load ?
Merge and Replace options are both available .
TRUE OR FALSE
TRUE
218. One driver dim per application is allowed while setting up validations using UJ_VALIDATIONS.
TRUE OR FALSE
TRUE
219. The driver dim can only be the account dim while setting up validations.
TRUE OR FALSE
Ø  FALSE
220. If two applications are using the account dim , the validation will be set across applications.
TRUE OR FALSE
TRUE
221. All config in UJ_VALIDATION is _____Specific
Ø  Application
Ø  App Set
Ø  Dimension
Ø  DSO
Answer: App Set
222. While setting up validations in UJ_VALIDATIONS.
Ø  Value ranges
Ø  Use non existing members
Ø  Only = sign
Ø  You can include multiple values.
Answer: A,B,D
223. It is possible to turn validations on/off by Journals, Manual Planning and Data Manager.
TRUE OR FALSE
TRUE
224. Following is true with regards to validations
Ø  All validations config can be transported
Ø  Validations integrate with Activity Audit
Ø  Authorisation is controlled by access to task profiles
Ø  last changed date and time is stored in tables
Ø  auth is ctrled by access to transaction code S-TRANS
Answer: A,B,D.
225. It is possible to log the process of copying and deleting an Appset.
TRUE OR FALSE
FALSE.
226. All changes regarding activation and de-activation of audits is logged into the system
TRUE OR FALSE
TRUE
227. An Application set is equivalent to a MS Analysis Services Database.
TRUE OR FALSE
TRUE
228. An Application is equivalent to a table in a relational database
TRUE OR FALSE
TRUE
229. In the MS Version the ApShell comes with 5 of 6 app types.
TRUE OR FALSE
TRUE
Note:Does not include Generic,non-reporting type. Includes apps like Finance ,Legal,Lrate,Rate and
Ownership .
230. In the MS Version, you can create custom menus , define security and add them to the custom
menu list in BPC for Excel .
TRUE OR FALSE
TRUE
231. In case the SQL dim data and Excel member do not correspond the _________ is needed to make
sure the diff storage types contain the same members.
Ø  Process Dim
Ø  Delete Dim
Ø  Export Dim
Ø  Modify Dim
Answer: Export Dim
232. Processing a dim in the MS version will execute the foll steps.
Ø  Create info objects
Ø  Save to the server
Ø  Validate the Formulas
Ø  Validate the hierarchies
Answer: C & D
233. You can schedule processing of dimensions in the MS Version .
TRUE OR FALSE
TRUE
234. Duplicate dim types are allowed in one application.
TRUE OR FALSE
FALSE.
Note:Duplicates are allowed if it is user defined dimesnions.
235. In the MS Version you can set the system to remind you to optimize the app when the database
records reach a certain limit.
TRUE OR FALSE
TRUE
236. When you load data via data manager in the MS Version it resides in the "Real Time" data storage.
TRUE OR FALSE
FALSE.
Note: When you load data via DM it resides in the FAC2 tables which is the short term data storage.
237. The Compress database option in the MS Version sums multiple entries for the same CV into one
entry so that data strorage space is minimized.
TRUE OR FALSE
TRUE
238. Index Defragmentation has no effect on FACT Tables.
TRUE OR FALSE
FALSE.
Note:ID can update all indices and statisticsto receive a faster access to the data. ID has an effect on
FACT tables .
239. The BPC DM is an instance of the MS Analysis Integration Services.
TRUE OR FALSE
TRUE
240. Data Manager can handle meta data.
TRUE OR FALSE
FALSE.
Note: Only Master data and Transaction data .
241. Clear package creates an additional record with a reverse sign and is eliminated upon compression
to achieve the deleted effect.
TRUE OR FALSE
TRUE
242. Worksheet Logic does not require a call to the server.
TRUE OR FALSE
TRUE
243.Worksheet Logic doesn’t update the database.
TRUE OR FALSE
TRUE
244. Dimension logic can only be used with the Account type dimension .
TRUE OR FALSE
FALSE.
Note:It can be used with any dim having the formula property .
255. Upon posting a Journal the system runs the logic that Is specific to journal processes. You can
create a Journal.lgf to overwrite this.
TRUE OR FALSE
TRUE
256. In case of Work Status, if a child is added to the hierarchy, and if the parent is locked, the child will
also be in locked status.
TRUE OR FALSE
TRUE
257. Re-posting a journal is like posting the values again with a reverse sign.
TRUE OR FALSE
FALSE.
Note: Unposting is posting the JV again but with a reverse sign. Reposting is posting the values twice to
the database .
258. There are no dynamic template wizard available for the EVDRE function .
TRUE OR FALSE
TRUE
259. EVDRE produces smaller workbooks the EVSND and EVGET as there is no need to embed functions
to send or receive data.
TRUE OR FALSE
TRUE
260.. You cannot build a static report using EVDRE.
TRUE OR FALSE
FALSE.
261. The ________ option controls the sending of data by EVDRE .
Ø  Workbook
Ø  Esubmit
Ø  Eanalyze
Ø  Etools
Answer: Workbook.
262.Where you set the layout is input schedule or report.
Ø  Workbook options – Input schedule or Report.
263. Refresh option recreates the sturcture of the report and then refreshes the cells.
TRUE OR FALSE
FALSE.
Note: Expand All does this.
264.What is the difference between EXPANDALL and REFRESH ?
265.EXPANDALL is time consuming than REFRESH.
TRUE OR FALSE
TRUE
266. The member for each dim is tied to the CV from the Page Key Range using the EVCVW function.
TRUE OR FALSE
TRUE
267. The _________ allows you to select the members from a member look-up dialog box by double
clicking on the cell that contains the formula
Ø  EVCOM
Ø  EVMBR
Ø  EVCVW
Ø  EVITM
Answwr: EVMBR
268. You can use the Cell key range only on static reports .
TRUE OR FALSE
TRUE
Note: Use the cell key range to overwrite the CV for any cell that Is a part of the data range
269. You can base the suppression option on a diff region of data than the one being retrieved.
TRUE OR FALSE
TRUE.
270. In the advance formatting, all the 6 cols can be arranged in any order.
TRUE OR FALSE
FALSE
Note: They must be found in the correct order - Criteria,Evaluate in , format, Use, Parameters, Apply to.
271. Time is a flat dimension .
TRUE OR FALSE
FALSE
Note: Times iahierachialdimension .
272. In BPC you can assign task profiles directly to users.
TRUE OR FALSE
TRUE.
273.In BPC you can assign task profiles to Team and assign users to the team.
TRUE OR FALSE
TRUE.
274. Drag and drop reporting provides an alternative method for creating reports and does not use the
EVDRE Functions .
TRUE OR FALSE
FALSE
275. In EVDRE , Report is pulled by Page Key Range and not by Current View.
TRUE OR FALSE
TRUE
276. BW has detailed level data and BPC is executive data.
TRUE OR FALSE
TRUE
277. The menu command ‘MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION  is useful for
Ø  Refresh the schedule without sending data
Ø  Sending data and refresh the worksheet
Ø  Sending data without clearing or refreshing the worksheet
Answer : Sending data without clearing or refreshing the worksheet
278. The  dimension type that is required  for effecting currency translations is
Ø  Currency Type
Ø  Flow Type
Ø  Entity Type
Ø  Rate Type
Answer: Currency Type
279. Delivered properties like Scaling, formula etc can be shared across Appsets
TRUE OR FALSE
TRUE
Note: The dimensions are app set specific not application specific.
280. A step is re-opened? What is the next step status?
Ø  Open
Ø  Re-open
Ø  Pending
Ø  Delayed
Ø  Approved
Answer: Delayed .
281. What is BW object equivalent to a BPC cube?
Ø  Info cube
Ø  Info object
Ø  DSO
Ø  Info area
Ø  Table
Answer: Info Cube.
281. Where are the archived reports stored in BW?
Ø  Cube
Ø  SAO
Ø  Write DSO
Ø  Real Time cube
Ø  Tables
Answer: Tables
282. Where do you set up the data audit for transactional data?
Ø  BPC Admin
Ø  BPC excel interface
Ø  Web Admin parameters at app set level
Ø  Web Admin parameters at application level .
Answer: Web Admin Parameters at application level.
283. What DIM is same for all applications in consolidation setup?
Ø  Category, time
Ø  Category,entity,time
Ø  Category,group,time
Ø  Category,group,Time,Entity
Answer: category & Time
284.IC Matching is required for consolidation setup.
TRUE OR FALSE
FALSE
285.What are the 3 apps required for Legal consolidation
Ø  Ownership
Ø  Rate
Ø  Legal
286.Ownership and Rate for non-reporting type apps.
TRUE OR FALSE
TRUE
287.Rate is like equivalent to TCURR in ECC system.
TRUE OR FALSE
TRUE
288. Which of these transformation file options is unique for NW setup?
Ø  SELECTION
Ø  MAXREJECTCOUNT
Ø  VALIDATION
Ø  SELECT
Answer: SELECTION
289. What is not possible through work-status?
To lock a BPF – Business Process Workflow
290.What is the name of the program to check the appset consistency ?
UJA_APP_DATA_CHECKER
291. Transaction data is described by
Ø  Infocube
Ø  Dimension
Ø  Appset
Ø  Dimension Members
Ø  Calculated KF’s
Answer: Dimension Members
292. The required dim types for reporting,generic is ACET .
TRUE OR FALSE
TRUE
293. During optimization the records are moved from the F-fact table to the E-fact table.
TRUE OR FALSE
TRUE
294. SAP BPC does not have the facility of portioning.
TRUE OR FALSE
TRUE
295. You can access the "Modify Work Status option thru the __________ menu.
Ø  Edata
Ø  Esubmit
Ø  Eanalyse
Ø  Etools
Answer: esubmit
296. The copy package can copy from several senders to one receiver.
TRUE OR FALSE
FALSE
Note: Always 1:1 relationship.
297. Compounding is supported in the /CPMB namespace.
TRUE OR FALSE
FALSE
298. Non-team leaders can manage a package at the team level .
TRUE OR FALSE
FALSE
Note: Non team leaders's can only run a package within the company or team folder.
299. A user can be both a system admin and primary admin .
TRUE OR FALSE
TRUE.
300. Default logic ref system constants which allow you to use diff dim names .
TRUE OR FALSE
TRUE
301. Default logic allows you to set fixed filters such as the fiscal year
TRUE OR FALSE
FALSE
Note: None of the logic sets fixed filters
302. Validation must be run to clear the validation account .
TRUE OR FALSE
TRUE.
303. The designated validation account is specified in work status config (MS only) .
TRUE OR FALSE
TRUE
304. Every time the validation is run, the validation account is incriminated by 1 so the user knows how
many time validation was run .
TRUE OR FALSE
FALSE
305. The *REC instruction tells the program what to do once the specified criteria has been met .
TRUE OR FALSE
TRUE
306. Each *REC instruction generates one new record to post to the data base
TRUE OR FALSE
TRUE
307. Script logic calculations cannot cross applications within on Appset .
TRUE OR FALSE
FALSE.
308. Script Logic is used to calc data but only for base level data in the application.
TRUE OR FALSE
TRUE
309. You use journals to record and make adjustments to the database.
TRUE OR FALSE
TRUE
310. How many journal templates are in a application
Ø  N no of journal templates.
Ø  Only one journal template per application.
Ø  Based on the no of dimensions
Ø  Journal templates are app set specific.
Answer: only one journal template per application .
311.The Ownership Account contains
Ø  Percentages
Ø  Methods
Ø  Parent Positions
Ø  Entity
Ø  Rates
Answer: Percentages,Methods and positions.
312. Ownership data is collected and stored by entity and intco.
TRUE OR FALSE
TRUE
313. In the ownership cube percentages and methods are stored by Entity
TRUE OR FALSE
TRUE
314. Any user with "manage template task " can save and update objects to the company folder or
team folder .
TRUE OR FALSE
TRUE
315. When data is entered into YTD, its periodic values used for reporting purposes, are calculated as
the difference between the current period and the last period.
TRUE OR FALSE
TRUE
316. One can decide to store data in YTD or on a Periodic basis setting the AppSetParameters .
TRUE OR FALSE
TRUE
317. Info Area - App set .
318. All dimensions in the application appear in the current view .
319. Multiple single values or ranges are not allowed - Current View .
320. The Current View is user dependent, therefore you will only be able to view information that your
member access profile allows.
321. "Work Book Option:Templates being used for reading have a workbook type of 'Report' whereas
templates being for both read and write have a type of 'Input Schedule'."
TRUE OR FALSE
TRUE
322. Park n Go lock down the report or input schedule and the current view data.
TRUE OR FALSE
TRUE
323. EvDRE is bidirectional; it can both send and retrieve data. It combines and extends the
functionality of other BPC functions such as EvGET and EvSND.
TRUE OR FALSE
TRUE
324. 10 dimesion types
A E C T R G I D S U
325.What is the new dimension in 7.5
GROUP
326.What is IFRS and US GAAP? Which is more specific GAAP or IFRS ?
- GAAP is more specific .
327. BPC allows periodic or YTD data storage while BCS is always periodic.
TRUE OR FALSE
TRUE
328.The Microsoft versions have a soft limit of 20 dimensions per Application .
TRUE OR FALSE
TRUE
329. InfoCubes used for Business Planning and Consolidation only
contain one key figure.
TRUE OR FALSE
TRUE
330. Request id’s stay ’open’ until a threshold of 50,000 records is reached. However,they can be
closed by turning the request id green, switching from plan to load mode, or by running the ’close trans
request’ function module.
TRUE OR FALSE
TRUE
331. The BW F Fact table is similar to the Microsoft based Write Back and Fac2 table.The BW ’E’ Fact
table is like the Microsoft Fact table.
332.When you create a BPC application – it creates a info cube, multi provider and a query.
333. Why a multiprovider is created when BPC application is created ?
334.Why a query is created when a BPC application is created ?
335. You can report on non-reporting application data, but you cannot assign work status codes to the
data. In addition, you cannot define business rules to these application types.
336.When you create an application you reference an application and business rules ?
TRUE OR FALSE
TRUE
337.What are the components of BPC security ?
·   Member access profile
·   Task  profile
·   Teams
·   Users
338. When you create new applications, you need to select at least one ’secure’ dimension. Then the
member access profiles need to allow access to the desired members.
TRUE OR FALSE
TRUE
339. If the carry forward business planning function is working because the following web application
parameter is not set
·   CARRYFORWARD
·   OPENING BALANCE
·   COPY OPENING
·   BALANCE CARRYOVER
Answer : COPY OPENING
340. If the YTD web admin parameter is set to YTD  then the data stored in the cube will
·   Cash YTD measure and Revenue YTD measure will be the same.
·   Cash periodic  measure and Revenue periodic measure will be the same.
·   Cash YTD measure and Revenue YTD measure are different.
·   Cash periodic  measure and Revenue periodic measure are different.
Answer: 2 are correct answers .
341.
·   ’DIMLIST#’ properties are used to provide selection criteria in business rules.
·   ’GROUP’ is used to designate an account as PL or BS.
·   ’ELIMACC’ is used for US Elims and logic based eliminations in Microsoft typically.
·   ’FORMULA’ is for dimension formulas.
342. All of the properties which begin with ’ORG...’ are related to the Dynamic Hierarchy Editor .
TRUE OR FALSE
TRUE
343. You cannot delete a dimension when it is being used by an application.
TRUE OR FALSE
TRUE
344. C, A, E, I can be referenced to other dimensions.
·   Category & Time – year common
·   Account & Account – Rate Type property
·   Entity & Currency – Local currency property
·   Intercompany & Entity – Entity values
345. CALC - a system-generated property that indicates calculated members.
TRUE OR FALSE
TRUE
346. Hierarchies are stored as SAP NetWeaver BW Hierarchies.
TRUE OR FALSE
TRUE
347. Hierarchies are stored as a separate dimension in MS version.
TRUE OR FALSE
TRUE
348. SCALING is a property of account used to display values in thousands for example in formula based
reports.
TRUE OR FALSE
TRUE
349.What are the 4 account types ?
AST, INC, EXP & LEQ
350.It is possible to create custom account types?
TRUE OR FALSE
FALSE.
351.Check the signs for the account types stored in DB and reporting ?
352.Processing a dimension does the following
•   Validate Dimension member formulas.
•   Validate Hierarchy .
•   Update member data into BW.
•   BW Attribute change run.
353.Which 2 functions can be used using script logic and business rules. 2 answers are correct.
·   Carry Forward
·   Validation
·   Automatic ajustments
·   Currency Translation
Answer : A & D
354. In microsoft the work status cannot be advanced if the ’validation’ account as defined in the
application work status has a non zero value.
TRUE OR FALSE
TRUE
355.What is missing  in this code ?
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %C_CATEGORY_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
ENTITY = %ENTITY_SET%
*ENDRUN_PROGRAM
·   CURRENCY = %RPTCURRENCY_SET%
·   RATEENTITY = %ENTITY_SET%
·   ACCOUNT = %ACC_SET%
·   Rate type is missing
·   TCURR table is missing
Answer: A
356.When you load the data to the BPC info provider you want to delete the existing data and reload
the new data what options you use
·   Merge and replace the date
·   Append the date
·   Delete and do a full load
·   Replace and clear
·   Merge the data
Answer: Replace and Clear
357.What is distributor and collector ?
358. Only reports can be distributed and collected  and not the Input Schedules ?
TRUE OR FALSE
FALSE.
359. What are the Out of the Box solution for loading the master data load?
Load Master Data from SAP ERP directly into BPC, version for SAP NetWeaver .
Load Master Data from SAP NetWeaver BI Characteristics Directly Using Data Manager
Flat file by DM
Flat File in BW
Answer; A & B
359.What are the Out of the Box solution for loading the transaction data load ?
·   Load transaction data from SAP NetWeaver BI using an Open Hub destination that provides flat
files to data manager (Delta Load)
·   Load transaction data from SAP NetWeaver BI InfoCubes directly using data manager custom
process type (Delta Load)
·   Load transaction data via flat file via SAP NetWeaver BI dataflow .
·   Load transaction data via UD Connect (SAP NetWeaver BI dataflow )
·     Load Transaction Data via Flat File using BPC Data Manager
Answer: A & B
360. When performing a “Copy AppSet” action, all Validations configuration is copied as well. Likewise,
for “Delete AppSet” all Validations configuration is also deleted.
TRUE OR FALSE
TRUE
361. The new dimension type ’G’ is new in 7.5 and permits the calculation of multiple group currencies
by adding multiple currencies into currency type dimension in the group dimension .
TRUE OR FALSE
TRUE
362. Stored procedures are used on the Microsoft product but not in NW. NW uses process chains and
programs.
TRUE OR FALSE
TRUE
363. By adding a value of ’Y’ to the IS_CONSOL property, the corresponding datasource will be included
in the consolidation processing, otherwise they are ignored.
TRUE OR FALSE
TRUE
364. By adding a value of ’Y’ to the IS_CONVERTED property, the corresponding datasource will be
included in the conversion from local to the desired currency, otherwise they are ignored.
TRUE OR FALSE
TRUE
365. What are the required dimensions to create the BPF instances ?
·   Time
·   Time and category
·   Category
·   Entity,category and Time
Answer: Time
366.There is no opening criteria for the first step in the BFP process .
TRUE OR FALSE
TRUE
367.When an BPF action is completed or status changed who gets notified ?
·   Owner
·   Reviewer
·   Manager
·   Admin
Answer: Owner
368. Time is the only required dimension. It is best practice to select at least two dimensions to define
an instance. The instance will be used to determine the status of the steps.Usually Time and Category .
369. The first step of the BPF always opens regardless of the opening criteria.
TRUE OR FALSE
TRUE
370. Allow Reopen will allow that step to be reopened after completion. If this is set to ‘No’ that step
can’t be reopened during execution.
371 Opening criteria All Step Region will enable opening of the next step only after all step regions are
complete whereas in case of Matched Step Region when you complete a stepregion, the next step
opens for the same step region.
TRUE OR FALSE
TRUE
372.Drill through calls the following
·   Any URL
·   Any BEX Query
·   Any ECC tcode
TRUE OR FALSE
TRUE
373. Data audit is captured at the Application level.
TRUE OR FALSE
TRUE
374. Activity audit is captured at the AppSet level.
TRUE OR FALSE
TRUE
375. When a new application is created, you must define member access to the secured dimensions
that reside in the application. This is required in order to use BPC Web, BPC for Excel, BPC for Word and
BPC for PowerPoint with any newly created application that contains secured dimensions.
376. Some components in SAP Business Planning and Consolidation do not post delta values (e.g.
Journals), in which case, the package size is always set to 99,999,999 (meaning packaging will never be
used).
377. You specify the hierarchy for which you want to track the work status of deliverables in the
APPROVALORG field on the Setting Application Parameters .
378. Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version
for SAP NetWeaver.
TRUE OR FALSE
TRUE
379.What controls access to applications?
Member Access Profile, Tasks
380.Limitation of dimension property?
Size cannot be decreased
381. Required DIM for inter-company setup?
382.What is different in options when you create a legal application?
383.What can you do while creating a BPF?
Matched opening criteria, owner
384.There is a problem in currency translation? Where would you look?
Property MD in Rate
385.A step is re-opened? What is the next step status?
386.What is BW object equivalent to a BPC cube?
387.Where are the archived reports stored in BW?
388.What can you do in web admin interface?
389.Which of these would require additional programming while loading
data?
Open hub data load
390. Where do you set up the data audit for transactional data?
App level or Appset level and where( web-admin/BPC client)
391.What DIM is same for all applications in consolidation setup?
Entity/Category
392.Which of these transformation file options is unique for NW setup?
SELECT
393.How are hierarchies stored in MS?
As a Dimension
394. What is  AS-IS keyword for conversion
395.What is not possible through work-status?
Locking a BPF step
396.An application is not shown while logging into excel? What is wrong?
Member Access not given
397.Program to check AppSet consistency
UJA_APP_Data_Checker
398.What are the reporting applications ?
399.What are the non-reporting applications ?
400.Can you assign work-status codes which application : reporting or non-reporting.
401.What are the required dimesions for reporting application?
402.What is light optimization ?
403.What is full optimization?
404.Changing the BI data model is light or full optimization?
405.Does partitioning available in BPC cubes ?
406.Does BPC uses the Sap standard time dimension ?
407.Is it possible to change the DB parameters in BW for BPC cubes ?
408.What are the objects get created in the backend when BPC application is
created ?
409.Why a multiprovider and a query got created on top of the application
cube and what is the purpose ?
410.Can a BPC infocube can be changed without the re modeling tool in BI ?
411.What information does UJA_APPL table contains ?
412.Does MDX statements select from the cube or from the query build on
the multi provider ?
413.What is the purpose of the web admin parameter YTDINPUT ?
414.What is a measure ?
415.What is signeddata ?
416.What are the 3 delivered measure ?
417.What is the purpose of the UJA_FORMULA table ?
418.Why we need UJA_FORMULA and UJA_FORMULA_APP ?
419.What is concurrency lock?
420.What is tcode RSPLSE ?
421.What you maintain in tcode RSPLSE ?
422.Does BPS  and Integrated planning also use RSPLSE ?
423.What is UJR_PARAM table used for ?
424.What are the 2 types of locking ?
425.What is the formula for calculating id record level locking or interval level
locking is needed/
426.What is sparsity coefficient ?
427. BPC Data Manager packages are technically executed as a BW process
chain.
TRUE OR FALSE
428.  True Or False
a.  Planning InfoCubes are write optimized but Standard
InfoCubes are read optimized.
b.  Consolidation InfoCubes are write optimized because the request id
stays open until a threshold is reached for example.
c.  Request id's in real time cubes can be closed by switching the cube to
the Standard type.
d.  A Real Time InfoCube has two 'data' modes, but only one will ever be
used by Business Planning and Consolidation.
e.  As data comes in to the Planning InfoCube, it arrives in the 'F' table
and remains there until it is compressed into the 'E' table.
f.  SAP BusinessObjects Planning and Consolidation can also be set up
against Data Store Objects.
429.  Choose the Correct Answer(s)
a.  There are two main types of InfoObjects: Catalogs and
InfoAreas.
b.  BW Characteristics have three potential types of master data.
c.  A BW Dimension table is exactly the same as an Business Planning
and Consolidation Dimension.
d.  InfoCubes are made up of Fact and Dimension tables.
430.   Choose the Correct Answer(s)
a.  An SAP BusinessObjects Planning and Consolidation
dimension is like a BW Characteristic
b.  An SAP BusinessObjects Planning and Consolidation property is like
an Attribute in BW.
c.  The SAP BusinessObjects Planning and Consolidation 'signed data'
column is like a key figure in an InfoCube.
d.  An AppSet is like a BW InfoArea.
e.  An SAP BusinessObjects Planning and Consolidation team folder is
equivalent to a BW Role.
f.  An SAP BusinessObjects Planning and Consolidation InfoCube is just
like an Application in BW.
431.   Fill in the Blank: BPC Application Development can be carried out
from the BPC _____________, ______________. The system automatically
populates BW with the related object
432.   BPC equivalent of BI Objects: Fill in the Blank
a.  Characteristics , ___________________________
b.  InfoCubes , ___________________________
c.  MultiProvider , ___________________________
d.  Process Chain, __________________________
e.  Transports, ______________________________
433.   What are the entire required dimension “Non Reporting–Generic”
Application?
434.  What is the reference Application for “Reporting–Generic”
application?
435.  What is common between “Non Reporting– Generic” and
“Reporting– Generic” Application?
436.   We can not _______________ to “Non Reporting” application?
437.   Which of the following application options are common between
Finance and Consolidation Application?
a.  Currency Conversion
b.  Calculation
c.  Intercompany Booking
d.  Intercompany Elimination
e.  Validations
f.  US Elimination
g.  Opening Balance
438.   True Or False: Is it possible to create an Application without a
Reference Application?
439.    True Or False: Is it possible to create a Dimension without a
Reference Dimension?
440.   ________________ allow the automated processing of data to render
a consolidated set of financial statements.
441.   When you create new applications, we need to select at least one
____________ dimension. Then the ________________ need to allow access
to the desired member
442.   Measure dimension used to determine application as a
________________ OR _________________
443.   Most secure system store balances on a ________________ basis
whether the data is entered/stored in daily, weekly , monthly , fiscal period
444.   _____________ namespace is a reserved namespace in SAP
NetWeaver BI for BPC
445.   BPC Dimensions are created under an Application Set with BI
Technical names of InfoObjects are generated with naming convention
/CPM/XXYYYYY, Where “XX” _____________ , and “YYYYY” is a
____________________ string
446.  Default Application set for BPC Excel, Admin , Word , PPT can be set
through ______________________
447.   True Or False
a.  Only user with System Admin rights can create a new
application , Dimension ,business rules table , work status
b.  Only user with Admin rights can create a new application , Dimension
,business rules table , work status
c.  Only user with Primary Admin rights can create a new application ,
Dimension ,business rules table , work status
448.   How to create an application set without using an existing application
set?
449.
___________,______________,_________________,_____________
_ are copied from the source application set to the target application set
based on the user choice
450.  ______________________ allows us to monitor the scheduled
application set copy process
451.   True Or False
a.  Does not copy the Master Data and Transaction Data
b.  Creates all the new Dimension with different technical name
c.  Copies WebFolder
d.  Any error in copy function will rollback all the data that has been
copied and files that has been created
452.   ______________________, _____________________ are application
status , _____________ can be obtained while processing Dimension
453.  True or False:
a.  Administrator can not continue to work on the Application
Set when the Application set is in “Unavailable”
b.  Users can continue to work on the Application Set when the
Application set is in “Unavailable”
454.  Which of the following tasks can be performed when the application
set is in Offline
a.  Executing Data Manager Package
b.  Write back through input schedule
c.  Executing Reports
455.   Fill in the Blanks: _____________ will force an update of the template
files to the clients , this can be changed in _______________, and
___________________
456.   Which of the following objects we can transport?
a.  Application Set
b.  Dimension Data
c.  Application Data
457.   True or False:
a.  Every AppSet has a 2 character AppSetPrefix stored in a table
called UJA_APPSET_INFO
b.  This prefix can be used in the technical name of
i..  InfoArea
ii.  InfoObject
iii.  InfoObject Catalog
iv.  InfoCube
458.   ___________________ is new in BPC NW 7.0 , it logs all the .NET tier
to the ABAP tier.
459.   which of the following are new functions available only In SAP BPC
NW 7.0 and this in available only in SAP BI Administrator workbench and
__________TCODE used to execute this function
a.  UJT_CHECK_TABLE_ENTRIES
b.  UJA_COPY_APPSET
c.  UJA_DATA_CHECKER
d.  UJS_ACTVIATE_CONTENT
459.   ______________ Dimension does not have to be part of any
application within the set , and it is needed validate ____________in the
Entity dimension
460.  _____________________, and ________________________ can be
specified while creating Dimension
461.   True or False
a.  Dimension properties are SAP BI Attributes
b.  Dimension names are not case sensitive
c.  Dimension properties are not case sensitive
d.  Dimension names are 20 character length
e.  Dimension property names are not limited to any character length
f.  For an existing dimension property , you can only increase the length
up to 60 character , you can not reduce the length
g.  To reduce the property storage length , we need to create a new
dimension with the reduced length and then copy the data from the old
dimension to the new one
h.  Dimension properties properties which is more then 60 character
stored in BW as a short text ,
461.   ______________,_______________, __________________ are 3
different type of properties , and _____________ property technical names
won’t change
462.   Choose the BEST - Dimension properties are used which of the
following BPC Functions
a.  Reporting
b.  Data Manager Selection
c.  Logic Formulas
d.  Member Lookups
463.   True or False
a.  You can not delete an Application if it is already assigned to
an Application
b.  Member sheet is a temporary storage
c.  Member sheet each time rebuild from the SAP BW Database when
we open it
d.  After deleting a member from an dimension requires “re-processing”
both dimension and application
464.   Under what circumstance you create same dimension with different
name , Example : ACCOUNT, ACCOUNT_L , DATASRC , DATASRC_L , etc
a.  When same dimension needed for different application with
different set of Members
b.  When same dimension needed for different application with same
set of Members
c.  When same dimension needed for different application with different
set of properties
d.  When same dimension needed for different application with same
set of properties
465.   True or False
a.  Hierarchy properties does not appear in the property list in
“Maintain Dimension Property”
b.  PARENT“N” property can be directly added as a column in the
Dimension member sheet via “Maintain Dimension Member”
c.  You can not have PARENT1, PARENT3 and skip PARENT2 , this will fail
in the validation
d.  You can have PARENT1, PARENT3 , PARENT2 , this will not fail order
does not matter
e.  We can have PARENT”N” column for each different hierarchy rollup
with in the dimension
f.  A parent will have the same children if it is used across multiple
hierarchies
466.   How many level we have in “CONUS” and “CONSMALL” hierarchy ?
467.   Which of the following functions performed when we process the
Dimension?
a.  Validate Hierarchy
b.  Validate Dimension Member Formula
c.  Update Member Data in BI
d.  BI attribute Change run in BI
e.  Invalidate Server cache for Dimension member by updating version
468.   Which of the following Dimension definition can not be changed
through SAP BW Admin workbench
a.  Base unit of Measure
b.  Currency Attribute
c.  Auth relevant
d.  Unit of Measure for Char
469.   True Or False
a.  In a Dimension , All user defined properties are defined as a
Navigational attributes
b.  In a Dimension , All user Reserved properties are defined as a Display
attributes
c.  In SAP BW workbench, we have change the Attribute TAB only
through the BPC Admin if there is any change, not through the BW
workbench
470.   Choose the “BEST Option” to load master data
a.  Direct entry into the Member Sheet
b.  Copy from an external Excel file into Member Sheet
c.  BI File load process
d.  BPC Data Manager Flat File Load
e.  Use BI techniques to load into BI Data Target and then BPC
f.  BI load process directly into BPC
471.   Choose the Best Answers - If you use BI technique to load master
data you will have to
a.  You will need to run the hierarchy attribute change run in BI
manually as well as make sure the caching mechanisms in SAP Business
Planning and Consolidation were updated correctly.
b.  You can call ABAP program UJA_REFRESH_DIM_CACHE using the
process type “ABAP_PROGRAM” in a process chain to update the BPC
dimension cache.
472.   Which of the following tasks can be performed as a background job
Via process chain?
a.  Copy Application
b.  Modify Application
c.  Optimize Application
d.  Copy AppSet.
473.   True or False
a.  If the Application Type is Financial or Consolidations, then
Journals are also copied during Create.
b.  One Rate application can not be referenced by multiple other
applications
c.  You can report on non-reporting application data, but you can assign
work status codes to the data.
474.   Netweaver restrictions for the InfoObjects in the BPC-Cube are the
same as in “normal” BI cubes _____________ characteristics per BI-dimensions and ______ possible BI-dimensions
475.   There ______________, ______________are 2 type of optimization
techniques to optimize the application
476.   In the Context of BPC, Explain actual data with example?
477.   In the Context of BPC, Explain plan data with example?
478.   In the Context of BPC, Explain forecast data with example?
479.   In the Context of BPC, Explain outlook data with example?
480.   In the Context of BPC, Explain budget data with example?
481.   In the Context of BPC, Explain GL data with example, and explain the
use of GL data in BPC?
482.  In the Context of BPC, Explain COPA data with example, and explain
the use of COPA data in BPC?
483.   What the “ACTUAL” Transaction data required for GPM (Gross
Margin Planning) for a company like Wal-Mart?
484.   What the “ACTUAL” Transaction data required for Sales for a
company like Wal-Mart?
485.   What the “ACTUAL” Transaction data required for P&L Planning for a
company like Wal- Mart?
486.   What the “ACTUAL” Transaction data required for Balance Sheet
Planning for a company like Wal-Mart?
487.   What the “ACTUAL” Transaction data required for Cash Flow Planning
for a company like Wal-Mart?
488.   What the “ACTUAL” Transaction data required for COGS planning for
a company like Wal- Mart?
489.   What the “ACTUAL” Transaction data required for HCM planning for a
company like Wal- Mart?
490.   What the “ACTUAL” Transaction data required for Legal Consolidation
for a company like Wal-Mart?
491.   What the “ACTUAL” Transaction data required for COI for a company
like Wal-Mart?
492.   What is Full P&L for a company like Wal-Mart?
493.   Explain Flow dimension with example?
494.  Explain Monthly, Quarterly and Half Month Closing Proces
495.   Explain Local, Transaction, Report, and Group Currency?
496.   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
497.   In the Context of BPC, Explain cost allocation, activity based costing,
fixed cost, variable cost and product costing?
498.  In the Context of BPC, What are Equity, Minority Interest, US GAPP,
and UK GAPP?
499.   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
500.   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
501.  What is the difference between Management and Statuary
Reporting; also explain with example for a company like Wal-Mart?
502.  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
502.   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
503.   What is the difference between Legal and Profit Center
Consolidation?
504.   Explain the consolidation process in details (the tasks that are
performed during consolidation?
505.   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.
506.   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).
507.   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.
508.  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
509.   The _______________ is an important tool to log to different
application sets and to set the default set.
510.   Which of the following steps are executed When you create a new
AppSet
a.  Copy the AppSetWebFolders/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
511.   ____________________ 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.
512.   _____________________ program can be used to check the
transport entries of an AppSet.
513.   ____________________ program can be used to check the
consistency for an AppSet.
514.   ____________ , _______________, _______________,
_____________ Dimensions are required in every application
515.   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.
516.   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
517.   Planning applications must reference a _________ application.
518.   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.
519.   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.
520.   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
521.   ___________will run a number of technical steps on the SAP
NetWeaver BI InfoCube in an attempt to improve performance
522.   There are two different type of optimization available 1. Light
Optimize 2. Full Optimize
a.  Light Optimize: ____________________________
b.  Full Optimize: ______________________________
523.   Full Optimize will check whether the data model of the Business
Intelligence (BI) Cube is built appropriately. Specifically, it will check:
_____________________
524.   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
525.   ____________ 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.
526.   Fill the blanks
a.  IFRS stands for _________________________
b.  IAS stands for _________________________
c.  FASB stands for _________________________
d.  IASB stands for _________________________
527.   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
528.   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
529.   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.
530.   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.
531.   ECCS stands for __________________ (ECC Based), BCS stands for
________________(BW Based).
532.   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.
533.   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.
534.   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
535.   What Applications do you need for Consolidation as mandatory
application?
a.  Legal
b.  Ownership
c.  Rate
d.  Intercompany Matching
e.  Finance
536.   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)
537.   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.
538.   What is the Year to Date values.
JAN  FEB  MAR
Periodic  100  200  0
YTD  ???  ???  ???
539.   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).
540.   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
541.   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.
542.   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.
543.   Dimensions Type By Application Mapping * Note : Use “Yers/No” +
_____________________________________________________
Legal Intercompany Owner Rate Matching
_____________________________________________________
1.  Account
544.  Sub Tables
3.  Category
4.  Entity
5.  Inter company
6.  Time
7.  Rate
8.  Data Source
545.   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.
546.  Gross Margin, Above Gross Margin , and Return on Net Assets are
___________
547.   What are the Standard Account Types ?
1. _______________
2. _______________
3. _______________
4. _______________
548.   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.
549.   The Main (Group) Properties are:
a. ________________________
b. ________________________
c. ________________________
d. ________________________
e. ________________________
550.   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
551.   Processing a dimension will execute the following step
a. _________________________
b. _________________________
c. _________________________
d. _________________________
552.   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.
553.   Four Different Type of Logic are
a. _________________________
b. _________________________
c. _________________________
d. _________________________
554.   You will have two files for each script logic you create:
a.  .LGF: This file contain
____________________________________
b.  .LGX: This file contain ____________________________________
555.   ______________ 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).
556. The most important BPC Consolidations Features include:
Choose the correct answer(s).
□ A The ability to load data from multiple source systems.
□ B Push back of data to ECC.
□ C Flexible multidimensional data model.
□ D Automated consolidation functions such as balance carry forward
and eliminations.
□ E Full support of all the major accounting standards.
□ F The ability to run BW Queries on Business Planning and
Consolidation data.
557. Which of the following ApShell components can be used for Legal
Consolidations?
Choose the correct answer(s).
□ A The account, flow, entity and intercompany dimensions.
□ B The delivered legal application.
□ C The master data in the delivered dimensions.
□ D The delivered logic files for the consolidations functions such as
consolidation, balance carry forward, and currency translation.
□ E The delivered process chains that go with the consolidation
functions.
□ F The delivered packages for each of the consolidation functions.
558. Which of the following are correct statements regarding what is
delivered or
available with the NetWeaver release?
Choose the correct answer(s).
□ A Business Process Flows are not in the NW 7.0 but are in the 7.5
release.
□ B The Dynamic Hierarchy Editor is not in the 7.0 release but is in
the 7.5 realease. The data can also be entered very easily 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.
559. Which of the following statements are true regarding Business Planning
and Consolidation vs. BW terms?
Choose the correct answer(s).
□ A An SAP BusinessObjects Planning and Consolidation dimension
is like a BW Characteristic.
□ B An SAP BusinessObjects Planning and Consolidation property is
like an Attribute in BW.
□ C The SAP BusinessObjects Planning and Consolidation 'signed
data' column is like a key figure in an InfoCube.
□ D An AppSet is like a BW InfoArea.
□ E An SAP BusinessObjects Planning and Consolidation team folder
is equivalent to a BW Role.
□ F An SAP BusinessObjects Planning and Consolidation InfoCube is
just like an Application in BW.
560. Which of the statements below are correct in regards to BW?
Choose the correct answer(s).
□ 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.
561.. Which of the following are true regarding Real Time InfoCubes?
Choose the correct answer(s).
□ A Real Time InfoCubes are write optimized but Standard InfoCubes
are read optimized.
□ B Real Time InfoCubes are write optimized because the request id
stays open until a threshold is reached for example.
□ C Request id's in real time cubes can be closed by switching the
cube to the Standard type.
□ D A Real Time InfoCube has two 'data' modes, but only one will
ever be used by Business Planning and Consolidation.
□ E As data comes in to the Real Time InfoCube, it arrives in the 'F'
table and remains there until it is compressed into the 'E' table.
□ F SAP BusinessObjects Planning and Consolidation can also be set
up against Data Store Objects.
561. Legal Consolidation applications are referenced to a and
applications.
Fill in the blanks to complete the sentence.
562.. Legal Consolidations which perform COI requires which of the following
applications?
Choose the correct answer(s).
□ A Matching.
□ B Legal.
□ C Ownership.
□ D Rate
□ E Planning
□ F Cons Unit
563.. Which of the following statements are true regarding Consolidation
applications?
Choose the correct answer(s).
□ A They require a time dependent Entity dimension to track
subsidiary assignments to consolidations groups through time.
□ B The legal application is a consolidation / reporting type
application.
□ C The ownership application is a non-reporting / ownership type
application.
□ D The rate application is a non-reporting / rate type application.
□ E The planning application is a reporting / financial type application.
□ F The matching application is a reporting / financial type application
referenced to a rate application.
564.. The four required dimension types for any application include:
Choose the correct answer(s).
□ A Intco Dimension
□ B Category
□ C Account
□ D Time
□ E Entity
□ F Request Id
565.. The Entity dimension has what consolidation related properties?
Choose the correct answer(s).
□ A Hierarchy
□ B Currency
□ C Formula
□ D Related Intco member
□ E Solve Order
566. In general, dimension properties are used for:
Choose the correct answer(s).
□ A Data selections in Input Templates
□ B Identifying destinations for the system to write to
□ C Data selections in Business Rules
□ D The execution of logic / programs
□ E Display in reports
567. Which of the following is true regarding the dimensions that applications
use?
Choose the correct answer(s).
□ A The Rate app uses: Rate, Category, RateEntity, Time, Input
Currency.
□ B The Legal app uses: Account, Flow, Category, Entity, Group
currency.
□ C The Ownership app uses: OwnAccount, Category, Entity, Time,
Flow.
□ D The Matching app uses: Account, Flow, Category, Entity, Intco,
Time, Group, Datasrc.
□ E The Legal app, uses: Real time InfoCubes and DSO's.
□ F The ownership app uses: Request ID, Unit, and Time dimension.
568. Default logic performs the following functions:
Choose the correct answer(s).
□ A Default logic references system constants which allow you to
use different dimension names.
□ B Set fixed filters such as the fiscal year.
□ C Specifies the balance sheet account to record annual net income.
□ D Identifies the application for which you want to perform currency
translation.
□ E Allows you to use different member id's for close and error flows.
□ F Records a value of 1 in a validation account if a difference is
detected.
569. The default logic uses *IF commands to do 'If Then' logic.
Determine whether this statement is true or false.
□ True
□ False
570. Business Planning and Consolidation uses an XDIMMEMBERSET to select
data regions.
Determine whether this statement is true or false.
□ True
□ False
571. The default logic 'Validation and Increment' works as follows:
Choose the correct answer(s).
□ A Whenever the default logic is triggered, a incremental value of 1
is written to a designated account member.
□ B Then, that incremental value is written off via a manual journal
entry.
□ C If a user tries to approve a data region and the validation account
is not zero, they are prevented from advancing the work status.
(Microsoft only)
□ D Validation must be run to clear the validation account.
□ E The designated validation account is specified in work status
configuration. (Microsoft only)
□ F Every time validation is run, the validation account is incriminated
by 1 so the user knows how many times validation was run.
572.. Which of the below are included in the steps to do a flat file transaction
data load?
Choose the correct answer(s).
□ A Upload the file to the SAP BusinessObjects Planning and
Consolidation Server.
□ B Create a conversion file to map external to internal names.
□ C Create a transformation file that includes the conversion file.
□ D Identify the InfoProvider.
□ E Run the data manager import file package.
□ F Save the data.
573.. Which of the following are true regarding the reversal of signs during
data
loads?
Choose the correct answer(s).
□ A If the source value is positive it will be reversed if it is an AST
account type.
□ B If the source value is positive or negative it will be reversed if it
is an AST account type.
□ C If the source value is positive or negative it will be reversed if it
is an LEQ account type.
□ D If the source value is positive or negative it will be reversed if it
is an INC account type.
□ E If the source value is positive or negative it will be reversed if it
is an EXP account type.
□ F If the source value is negative it will be reversed if it is an AST
account type.
574.. Which of these scenarios could be a viable option to input data into a
Planning and Consolidation InfoCube?
Choose the correct answer(s).
□ A You have incoming flat files from a legacy source system.
□ B You were faxed the trial balance and you want to enter it manually
via an input template.
□ C You have data in a BI InfoCube that was loaded from the ECC
New General Ledger.
□ D You want to distribute spreadsheets and collect them from the
various subsidiaries.
□ E You have adjusting entries to make at the group level.
□ F You want to use the infamous BI ETL data loading functionality.
575. Which of the following are important to keep in mind when you use
journal
entries for an application?
Choose the correct answer(s).
□ A Once a template has been created, it should not be changed
because part of the audit trail is lost.
□ B You can use the property 'enablejrn' in a dimension to control
which members can be posted against in a journal entry.
□ C Journal entries hit the line item DSO and the Totals InfoCube.
□ D Journal entries have to be copied from one period to the next
when the Legal Application is set to YTD.
□ E Journal entries can be forced to balance by either checking that
setting in the journal itself or turning that feature on in the
application parameters.
576. Journal control features include:
Choose the correct answer(s).
□ A The new NW validation rules which prevent invalid characteristic
combinations.
□ B Tolerances groups.
□ C Work status control for journals.
□ D Journal security involves defining users who can administer,
create, post, or unpost journal entries.
□ E Posting periods can be closed.
577. Which of the following best describes balance carry forward (BCF)?
Choose the correct answer(s).
□ A BCF is normally run at the beginning of the new year.
□ B BCF copies balance sheet account balances into period 000 of
the new year.
□ C BCF does not always write a balance sheet balance to the same
account.
□ D BCF can be used to copy multiple flows from one year to opening
balance in the subsequent year.
□ E BCF business rules include: Source account, Source datasrc,
Destination account and the reverse sign indicator (the Datasrc
is inherit).
577. Which of the following are true statements regarding the 'Account
Transformations?
Choose the correct answer(s).
□ A They can be used to calculate and store values such as for cash
flow reporting purposes.
□ B Allows read and write capability for four dimensions: Account,
Category, Time, and Datasrc.
□ C Additional features include: reversing signs, YTD or Period
values, and offsets to determine the source year and period.
□ D Account transformations copy from the source and write to the
target dimensions.
□ E Account transformations delete from the source and write to the
target dimensions.
578. Your client has asked you to provide a synopsis of the Allocation
function.
Which of the following points should you include?
Choose the correct answer(s).
□ A Allocations are typically used in managerial accounting scenarios.
□ B Allocations are used as a dis-aggregation feature such as for
distributing corporate overhead.
□ C The components include a segment, cycle, and cycle run group.
□ D The delivered objects for allocation include: Logic, Package,
Business Rules, the allocation program, and the allocation process
chain.
□ E Allocations could also be used for balance sheet items.
579. Your boss needs a summary of what you learned in the Business
Planning
and Consolidation class about validations and so you would include which
of the following:
Choose the correct answer(s).
□ A There are actually two types of validations available: the
more traditional 'value' validations, and also the characteristic
combination validation as well.
□ B If a false result is returned, the variance between the balances in
the two sets of accounts will be automatically posted to an “error”
account.
□ C If an out of balance is calculated, the system automatically locks
the period based on a special validation account in work status.
□ D The validation account that is written to when out of balances
exist is defined in Work Status (Microsoft only).
□ E If the validation account is not zero, work status can be advanced.
□ F Account1, Flow1, and Sign1 form the receiving dimensions.
580. You are interested in sharing the conceptual information you learned in
class
with your fellow accountants. Which of the following would be correct to
convey?
Choose the correct answer(s).
□ A Currency translation is used to prepare a set of financials in a
corporation's group currency with the potentially distorting effects
of exchange rate fluctuations clearly presented.
□ B Currency translations for legal consolidations is usually run as a
job at month end not as data is input into the system.
□ C Long term asset opening balances are translated normally using
average periodic rates.
□ D Asset acquisitions are usually translated using average periodic
rates.
□ E PL items are usually translated using average periodic rates.
581. Currency translation business rule tables have which of the following
features?
Choose the correct answer(s).
□ A Define the rates and logic to be applied to each Account Rate Type.
□ B Source flow member determination.
□ C Destination account.
□ D Source flow.
□ E Formulas using the Rate application account dimension.
□ F Force closing which closes the period.
582. The currency conversion setup includes which of the following?
Choose the correct answer(s).
□ A A rate application which is referenced to the legal application and
stores the exchange rates used to translate into the reporting and
group currencies.
□ B The currency property of the Entity dimension which designates
the local operating currency of legal subsidiaries normally.
□ C Rate Type property in the account dimension which determines
the rate and logic to be used in translation.
□ D Tcurr table which stores exchanges rates such as spot and
historical.
□ E Currency business rules.
□ F The currency data manager package and process chain.
583. Currency translation calculations typically work as follows:
Choose the correct answer(s).
□ A Opening balance is bought in at the END rate plus the change in
the END rates multiplied by the closing LC value.
□ B The change is bought over at the average rate plus the difference
between the END and AVG rate multiplied by the LC .
□ C The closing balance is valued at the LC times the END rate.
□ D Translation differences can be written to separate flow members.
□ E Translation differences are also written to the journal document
DSO.
584. Your closing activities take less than an hour for COI since most of
your subsidiaries are wholly owned so there would not be any benefit of
automating the COI manual process.
Determine whether this statement is true or false.
□ True
□ False
585. What statements are true for the purchase method?
Choose the correct answer(s).
□ A First consolidation eliminates the sub's equity against the parent's
investment.
□ B During first consolidation, any difference between the investment
and the parent's share of the sub's equity is written to goodwill.
□ C The purchase method only adjusts the investment for market
value changes in the subsidiary.
□ D The purchase method is typically used in the US where the parent
has a majority of the shares or has controlling interest over the
subsidiary.
□ E Annual net income of the subsidiary is split between the parent
and the minority shareholders during subsequent consolidation
activities.
586. If a subsidiary reports $150m of annual net income, the corporation
would
report $100m if they own 67% of the subsidiary's shares while minority
stockholders would report $50m.
Determine whether this statement is true or false.
□ True
□ False
587. Which of the following describe the COI process?
Choose the correct answer(s).
□ A When the consolidation program is executed, it reads dimension
properties, consolidations methods and %'s in the Ownership
application.
□ B The 'dimlist' (or related property) in the account dimension can
be used as a selection criteria for accounts to be included in the
source of the calculation.
□ C The method assignments by entity and their percentages are read
from the Dynamic Hierarchy.
□ D The business rules are broken down into Appset and Application
sections.
□ E In the Appset, the Rules, Methods, and Formulas are defined.
□ F In the Application, the destination datasource is assigned to
the method in the 'automatic adjustments'. In the automatic
adjustment details, the source accounts, reversal signs, target
accounts, and target flows, are specified.
588. Which of the following are included in the 10 key steps?
Choose the correct answer(s).
□ A Set up the dimension members and properties.
□ B Create the IC Matching Application.
□ C Set the application parameters.
□ D Configure the business rules at the Appset level.
□ E Configure the automatic adjustment bus rules in the Legal App.
□ F Input methods, position, and percentages in the Ownership
application.
589. What reasons do you have for using an IC Matching Application?
Choose the correct answer(s).
□ A You cannot use transaction currency in the Legal App.
□ B It makes it easier to manage the data due to the smaller volumes.
□ C You can avoid changing users data access for the legal app.
□ D It is easier to manage work status.
590. Which of the following are required to do IC Matching?
Choose the correct answer(s).
□ A The IC Matching App must include an Inter Company Dim of
type 'I'.
□ B The Inter Company Dim must include the property Entity.
□ C The Entity Dim needs a property of I or E for Internal vs.
Customer facing subsidiaries.
□ D The Inter Company Booking business rules and Currency
Conversion rules need to be set up.
□ E A data manger package that executes the ICBookingprogram .
□ F Default logic which has the ICData logic referenced.
591.. The ARAP related dimension properties include which of the following?
Choose the correct answer(s).
□ A Entities have an internal vs. external indicator for inter unit vs.
customer activities.
□ B Datasrc has: DataSrc_Type A (automatic), Is_Converted which
can be yes, no, or filled with Group currency.
□ C Intco has the corresponding Entity property.
□ D Account can have a 'DimList' property with a value such as ARAP.
□ E Category has an a book vs. tax indicator for book Gaap vs. IRS
valuations.
592.. When the consolidation program is executed, what happens?
Choose the correct answer(s).
□ A The program reads the dimension properties, consolidation
methods and %'s in the Ownership application.
□ B The program then reads the business rule tables and a DimList
property for the Account Dimension.
□ C The program reads the Rules, Methods and Formulas from the
application business rules.
□ D The program then reads the destination datasrc which is assigned
to the method in the application business rules table called
'automatic adjustments'.
□ E The program then will post a validation account for any
differences.
□ F The program reads the automatic adjustment tables to fetch the
source accounts, reverse signs, target accounts, and target flows.
593. The Equity elimination process includes which of the following
supporting
information?
Choose the correct answer(s).
□ A The entity and linked intercompany member.
□ B The method 'posted' into the Ownership Application for each
entity.
□ C The Elimination name or ID from a DimList property for the
account dimension.
□ D The Dynamic Hierarchy method assignments.
□ E The Equity Data Store Object.
594. Which of the following are true regarding Consolidation Rules?
Choose the correct answer(s).
□ A They can be found in the application.
□ B The can be found in the appset.
□ C Consolidation rules have 5 possible rule types.
□ D All of the rule types also appear in the consolidation methods
as 'method' types.
□ E Rule id's are assigned to rule types in the Cons Rules and then to
the automatic adjustment details.
595. The application business rule tables have which of the following
attributes?
Choose the correct answer(s).
□ A The automatic adjustment table includes link to the consolidation
rules via the adjustment types which are linked to the rule types.
□ B The destination datasrc member has to have an 'A'utomaticdatasrc
type property value.
□ C The adjustment id identifies the destination datasrc and adjustment
type and links that to the details which include the source account,
sign reversal, destination all account, etc.
□ D They can only be maintained at the appset level.
□ E The 'Level' is the solve order, lower values are processed first.
□ F The rule id in the details table comes from the consolidation rules
table.
596. Which of the following are feasible scenarios for how to use the
reporting
tool set available to you?
Choose the correct answer(s).
□ A Use EVDRE when you need the most efficient and robust solution.
□ B Use Word/PPT for documents or presentations that have live data.
□ C Use Live Reporting for the biggest data volumes.
□ D Export data on to a normal BI InfoCube ... as part of a standard
solution.
□ E Use Dynamic Schedules for manual data input.
□ F Use Dynamic Reports for Ad Hoc Excel reporting.
http://www.sap.com/services/education/catalog/businessobjectstraining/epm/certificationtest.epx?co
ntext=[[C_EPMBPC_70|]]|
Section/Category:
·   Additional Topics
·   Business Process Flows(BPF’s);Work Status.
·   Currency Translation  and Other Business Rules.
·   Data Loading, Transformations  and Conversions.
·   Data Reconciliation and Journals.
·   Database Structure
·   Design Considerations for AppsetsandAapplications.
·   Logic and Calculations.
·   Schedules and Reports.
·   Security Concept.
The most number of  questions :16 questions came from Logic and Calculations. Around 4 questions
from security concept, 8 from BPF’s and WF’s,8 from Additional topics,etc.
Sample Questions from SAP  Website:
1. Where is archived audit data stored in BPC for the SAP NetWeaver technology platform?
Please choose the correct answer.
a)   O   In a flat file
b)   O   In a BW InfoCube
c)   O   In a BW table
d)   O   In a DataStore Object
2 . What settings are possible for restricting data access for a given work state?
Note: There are 2 correct answers to this question.
a)   O   Administrator ?
b)   O   Reviewer
c)   O   Owner
d)   O   Manager
e)   O   Assistant
3. What components are needed to run business rules?
Note: There are 3 correct answers to this question.
a)   O   Business Rule
b)   O   Dimension Logic
c)   O   Conversion File
d)   O   Data Manager Package
e)   O   Script Logic
4. What data management option is required to load transaction data from a file to a BPC application?
Please choose the correct answer.
a)   O   Maintain data management. ?
b)   O   Run the data management package. ?
c)   O   Organize the package list.
d)   O   Download the data file.
5. Which dimension type is optional for an application?
Please choose the correct answer.
a)   O   Data source type
b)   O   Account type
c)   O   Time type
d)   O   Category type
6. What benefits does BPC offer to a corporation?
Note: There are 2 correct answers to this question.
a)   O   It gives the IT department control over budgeting and planning
functions.
b)   O   It integrates with the Microsoft Office Suite including Word,
Excel, and PowerPoint.
c)   O   It enables compliance with IFRS and SOX.
d)   O   It enables you to drill through to the SAP-ECC system for
reporting.
7. A KPI should be calculated centrally, on-the-fly, and be available to all reports.
Which implementation option do you choose?
Please choose the correct answer.
a)   O   Worksheet Logic
b)   O   Business Rules
c)   O   Script Logic
d)   O   Dimension Member Formulas
8. Which implementation steps are mandatory to set up an on-the-fly KPI calculation?
Please choose the correct answer.
a)   O   Execute a data management package.
b)   O   Add the 'Formula' property to the account member.
c)   O   Update the 'system_constants' file.
d)   O   Add the library file 'mdxlib.lgl' to the options sheet of the
account member.
9. Which function is used to perform a better or worse comparison of two values?
Please choose the correct answer.
a)   O   EVPRP
b)   O   EVGTS
c)   O   EVPRO
d)   O   EVBET
10. Which parameter in the options list of a transformation file is available only in BPC for the SAP
NetWeaver technology platform?
Please choose the correct answer.
a)  O  DELIMITER
b)   O   SELECTION
c)  O   VALIDATERECORDS
d)  O   AMOUNTDECIMALPOINT
Solutions
1 a) Incorrect   2 a) Incorrect   3 a) Correct   4 a) Incorrect   5 a) Correct
1 b) Incorrect   2 b) Incorrect   3 b) Incorrect   4 b) Correct   5 b) Incorrect
1 c) Correct   2 c) Correct   3 c) Incorrect   4 c) Incorrect   5 c) Incorrect
1 d) Incorrect   2 d) Correct   3 d) Correct   4 d) Incorrect   5 d) Incorrect
2 e) Incorrect   3 e) Correct
6 a) Incorrect   7 a) Incorrect   8 a) Incorrect   9 a) Incorrect   10 a) Incorrect
6 b) Correct   7 b) Incorrect   8 b) Correct   9 b) Incorrect   10 b) Correct
6 c) Correct   7 c) Incorrect   8 c) Incorrect   9 c) Incorrect   10 c) Incorrect
6 d) Incorrect   7 d) Correct   8 d) Incorrect   9 d) Correct   10 d) Incorrect
SAP Certified Application Associate – SAP BusinessObjects Planning and Consolidation 7.5 – print view
print view
Disclaimer: These sample questions are for self-evaluation purposes only and do not appear on the
actual certification exams. Answering the sample questions correctly is no guarantee that you will pass
the certification exam. The certification exam covers a much broader spectrum of topics, so do make
sure you have familiarized yourself with all topics listed in the exam competency areas before taking
the certification exam.
Questions
1. User1 is the parent owner and user2 is the child owner. What happens when user2 sets a work
status?
Note: There are three (3) correct answers to this question.
a)   O  If it is set to "Manager", user1 can post a journal.
b)  O  If it is set to "All", only user1 and user2 can post a journal.
c)  O  If it is set to "Locked", neither can post a journal.
d)  O  If it is set to "Manager", user2 can post a journal.
e)  O  If it is set to "Both", user1 and user2 can post a journal.
2. For which scenario is it impossible to use the work status?
Please choose the correct answer.
a)  O  To track the progress of a planning process
b)  O  To lock a step in a Business Process Flow
c)  O  To allow or disallow a user to modify data
d)  O  To lock a region of data in an Application
3. For which users does the system prevent saving templates to the company folder?
Note: There are two (2) correct answers to this question.
a)  O  For a non admin user with the Manage Template task
b)  O  For a non admin user without the Manage Template task
c)  O  For a user with the Primary Admin default function task
d)  O  For a team leader with the Manage Template task
e)  O  For a team leader without the Manage Template task
4. What dimension types are mandatory for the Application type Financial?
Note: There are two (2) correct answers to this question.
a)  O  S – Subtable
b)  O  C – Category
c)  O  I – Intercompany
d)  O  T – Time
e)  O  D – DataSource
5. Who is notified when a step is completed using Business Process Flow?
Please choose the correct answer.
a)   O  BPF Reviewer
b)  O  BPF Manager
c)  O  BPF Owner
d)  O  BPF User
6. Which settings do you need to make for the Source Account to calculate the annual net income (ANI)
for the liability account?
Please choose the correct answer.
a)  O  Revenue and Cost, Destination Account = ANI, reverse sign
b)  O  Expense, Destination Account = Revenue and ANI, reverse sign
c)  O  Revenue and Cost, Destination Account = ANI, do not reverse
sign
d)  O  Expense, Destination Account = Revenue and ANI, do not reverse
sign
7. Which fields are required to eliminate the investment when using the All Formula?
Note: There are two (2) correct answers to this question.
a)  O  Source Account
b)  O  Destination All Account
c)  O  Destination Group Account
d)  O  Destination Equity Account
e)  O  Destination Minority Interest
8. In SAP BusinessObjects Planning and Consolidation for NetWeaver, the language texts are missing.
How do you fix this issue?
Please choose the correct answer.
a)  O  Import transaction data.
b)  O  Load data from the InfoProvider.
c)  O  Refresh dimension members.
d)  O  Import master data descriptions.
9. Which data management option is required to load transaction data from a file to an SAP
BusinessObjects Planning and Consolidation Application?
Please choose the correct answer.
a)  O  Run the data management package.
b)  O  Organize the package list.
c)  O  Download the data file.
d)  O  Maintain data management.
10. Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for
NetWeaver?
Please choose the correct answer.
a)  O  Financial Processes
b)  O  Data Management
c)  O  Reporting Management
d)  O  System Administrative
11. Which dimension type is optional for an Application?
Please choose the correct answer.
a)  O  Data source type
b)  O  Category type
c)  O  Time type
d)  O  Account type
12. How can you add a property other than a hierarchy to a dimension?
Please choose the correct answer.
a)  O  Maintain the dimension property.
b)  O  Refresh the dimension members.
c)  O  Maintain the dimension members.
d)  O  Process the dimension.
13. Which implementation step is mandatory to set up an on-the-fly KPI calculation?
Please choose the correct answer.
a)  O  Add the "Formula" property to the account member.
b)  O  Execute a data management package.
c)  O  Update the "system_constants" file.
d)  O  Add the library file "mdxlib.lgl" to the options sheet of the
account member.
14. A KPI should be calculated centrally, on-the-fly, and be available to all reports.
Which implementation option do you choose?
Please choose the correct answer.
a)  O  Worksheet Logic
b)  O  Business Rules
c)  O  Dimension Member Formulas
d)  O  Script Logic
15. Which EV functions can support the posting process of an Input Schedule?
Note: There are two (2) correct answers to this question.
a)  O  EVDRE
b)  O  EVGTS
c)  O  EVCOM
d)  O  EVMNU
e)  O  EVHOT
16. Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for
NetWeaver?
Please choose the correct answer.
a)  O  MultiProviders
b)  O  Business Rules
c)  O  Roles
d)  O  Journal Templates
Solutions
1 a) Correct  2 a) Incorrect  3 a) Correct  4 a) Incorrect  5 a) Incorrect
1 b) Incorrect  2 b) Correct  3 b) Correct  4 b) Correct  5 b) Incorrect
1 c) Correct  2 c) Incorrect  3 c) Incorrect  4 c) Incorrect  5 c) Correct
1 d) Incorrect  2 d) Incorrect  3 d) Incorrect  4 d) Correct  5 d) Incorrect
1 e) Correct    3 e) Incorrect  4 e) Incorrect
6 a) Incorrect  7 a) Correct  8 a) Incorrect  9 a) Correct  10 a) Incorrect
6 b) Incorrect  7 b) Correct  8 b) Incorrect  9 b) Incorrect  10 b) Incorrect
6 c) Correct  7 c) Incorrect  8 c) Incorrect  9 c) Incorrect  10 c) Correct
6 d) Incorrect  7 d) Incorrect  8 d) Correct  9 d) Incorrect  10 d) Incorrect
7 e) Incorrect  
11 a)
Correct
12 a)
Correct
13 a)
Correct
14 a)
Incorrect
15 a)
Correct
16 a)
Incorrect
11 b)
Incorrect
12 b)
Incorrect
13 b)
Incorrect
14 b)
Incorrect
15 b)
Incorrect
16 b)
Incorrect
11 c)
Incorrect
12 c)
Incorrect
13 c)
Incorrect
14 c)
Correct
15 c)
Correct
16 c)
Correct
11 d)
Incorrect
12 d)
Incorrect
13 d)
Incorrect
14 d)
Incorrect
15 d)
Incorrect
16 d)
Incorrect
15 e)
Incorrect
16 a)
Incorrect
BPC 2
Some Basic Definitions in BW:
Here are some basic concepts. The planning data in the netweaver BW is stored in the REAL TIME Info
cube. There are 2 types of infocubes – Standard or basic cube and Real time info cube. The real time
infocube is optimized so that you can write and read data from the cube. Also know as transactional
info cube. The real time infocube load status can be changed to Load mode or Planning mode . It can be
changed in RSA1/cube/context menu.Again the data is stored only in REAL TIME Infocube and not in
standard or basic cube or DSO or Write optimized DSO or Multiprovider or infoset or infoobject or
table.
BPC Vs BW:
No  BW  BPC
1.  Infoarea  Appshell
2.  Cube  Application
3.  Multiprovider  Application
4.  Infoobjects – costcenter,cocode  Dimensions
5.  Master data  Members
6.  Navigational Attributes –
Material color , size,etc
Properties
7.   Key Figures – Quantity or
Amount
Signed data/Amount(Please
check below notes)
8.  Bex Query  EVDRE Reports
9.  Process Chains  Data Manager Packages
* Signed data/Amount – There is only one key figure in the BPC cubes.
The important tcodes with the above
·   SAP_CONVERT_NORMAL_TRANS – Convert Normal to transactional cube.
·   RSINPUT – To create sample data.Can be used in testing phase to input the data .
The real time cube request will stay open till 50K records.
BPC 3
Dimensions :
·   A – Account Type
·   C – Category Type
·   E – Entity Type
·   T – Time Type
·   R – Currency Type
·   I – Intercompany
·   D – Data source
·   S – Subtable
·   U – User Defined
Required Dimensions in each application:
·   A – Account Type
·   C – Category Type
·   E – Entity Type
·   T – Time Type
Required dimension in each application set
·   R – Currency Type
Required dimension for Intercompany Eliminations
·   I – Intercompany
Just remember the above dimensions – like what are required dimensions for each  application or what
dimensions are optional for an application etc.
Dimesions& Properties – Continuation
·   What is process Dimension functionality: When you create/change a dimension all the changes
are updated to the database – BW cube. After you create the dimension you have to process the
dimension in the BPC admin console to update the DB.
·   Dimension field names can be max 20 chars.
·   Dimension properties length if it is less than or equal to 60 will be stored as a BI attributes.
·   More than 60 will be stored as a string in BW.
·   There is no limit of the length of the properties.
·     In BPC you can only increase the size of the property and you can’t reduce the size. This is very
important.
·   It is not possible to delete the member until it is deleted from all applications where it is
used.Same as deleting the master data in BW.
·   If the property length is more than 60 it can’t be used in script logic calculations.
·   Renaming a existing member is not possible in netweaver BW. Copy and use it.
MASTER DATA LOAD
How to load the master data:
Standard Solutions:
·   Enter master data directly in spreadsheet.
·   Copy from an external spreadsheet and paste to the member excel sheet.
·   From ERP master data tables to BW infoobjects  and from BW infoobjects to BPC dimensions by
DTP – Full load.
·   Load master data by flatfile in the backend like using flatfile DS and DTP.
·   Load master data by flat file by using data manager.
Custom Solutions:
·   Load master data from ERP to BPC dimension by using the data manager –
transformation/conversion functionalities.
·   Load master data from BW Infoobjects to BPC dimension by using the data manager –
transformation/conversion functionalities.
So 4 standard solutions and 2 custom solutions.
Some Security concepts:
·   Security is maintained in the frontend for the BPC apps  .
·   Security is maintained at the appset level.
·   There are 2 components – Task profile and member access profile.
·   Task Profile: A task profile determines what type of activities a user or team can perform
in BPC.
·   Member Access Profile: A member access profile determines applications and dimension
members where a user or a team has read, write or deny access to a particular region of
data in the application.
·    User can be assigned to task profile and member access profile.
·   A team can be assigned to task profile and member access profile.
·   Then users can be assigned to the team.
·   There can be only one team leader per team in sap netweaver 7.0.
·   System Admin: By default a System Admin can create, modify, or delete
application sets and define security.
•   Primary Admin: By default a Primary Admin can do all admin tasks except
create, modify, or delete application sets.
•   Secondary Admin: By default being a Secondary Admin allows users to
manage dimension members and to maintain locks.
•   Within “Modify Application” you have to set “Secured” for the authorization
relevant dimensions.Only for these dimensions you will have to define if you want a write-read,
read-only, read or deny access for certain members of this secured dimension.
•   For the dimensions which are no secured dimensions you have a “sap-all” access
to all members
·   You are not able to post a journal entry then what is the issue.Check you have the necessary task
profile assigned to your id  or team.
·   You created a new application and when login you can’t see the application what you created. So
you are missing the member access profile. For that application-members. Read or Write or Deny
access. Without having defined a Member Access Profile its not possible to work with the
Application.
·   What is the task profile name for accessing the content library and live report – The task name is
ZFP.
Hierarchies
How hierarchies are treated in MS version of BPC.
·   There is no hierarchy in MS version of BPC.
·   Hierarchy is treated as BW hierarchy.
·   Hierarchy is treated as a measure.
·   Each hierarchy is treated as a separate dimension in the DB.
The correct answer is separate dimension in the DB. So keep the hierarchies minimum in MS version.
·   You can have more than one hierarchy for the same dimension.
·   To define a hierarchy add the Paranet property as a column directly in a dimension member sheet
via Maintain Dimension Members.
·   Hierarchies should be named as Parentn where n is the no of the hierarchy. For example if you
have 2 hierarchies then you create as Parent1 and Parent2.
·   Hierarchies are stored as SAP Net weaver BW Hierarchies in BPC Net weaver version .
·   Hierarchies are stored as a separate dimension in MS version BPC.
·   The order of the hierarchies are not important like Parent1,Parent3,Parent2.
·   But you should not skip a hierarchy like Parent1, Parent3.
Some EV Expansion commands
·   SELF   - Returns the current member
·   EVDPS   - Returns the current member and its  dependents
·     EVDEP   - Returns the current member’s dependents
·   EVBSS   - Returns the current member and its  base level members.
·   EVBAS   - Returns the current member’s base level members.
·   EVALS – Return the current member and all members below it
·   EVALL   - Returns all members below the current member.
·   EVMEMBERS   - returns all members, above and below the current member.
Some MDX Expansion commands
·   BEFORE   - Returns descendant members from leveldown value only . Includes
<Members>,if and only if LevelDown value specified is the level of <Members>.
·   AFTER   - returns descendant members from all levels subordinate to LevelDOWN value.
·   LEAVES Returns leaf descendant members irrespective of the level.
·   SELF_AND_AFTER   - Returns descendant members from LevelDown value and all levels
subordinate to LevelDown value.
·   SELF_AND_BEFORE   - Returns descendant members from LevelDown value and all levels
between <Members> and LevelDown value.
·   SELF_BEFORE_AFTER   - Returns descendant members from all levels subordinate to the level of
<Members>.
·   BEFORE_AND_AFTER   - Returns descendant members from all levels subordinate to the level of
<Members> except members from LevelDown value.
Just remember the above commands.
Some questions like
What is EVDEP – 1 answer is correct
·   Returns the current members dependents
·   Returns the current member and its dependents
·     Returns the base members and its dependents
·   Returns all base level members.
What are MDX commands- 3 answers are correct
·   Before
·   After
·   Any
·   SELF_AND_BEFORE
Where you set the report or Input Schedule option
Workbook ---.Set option-à Report or Input Schedule.
What the EV functions which saves the data in the database.
·   EVSND
·   EVDRE
·   EVCOM
Delivered Templates
·   10 reporting templates ready to use
·   5 input schedule templates ready to use.
What is Park N ‘Go:
Use this function to lock the current view in a report or input schedule, or both
the current view and data, or to take the workbook offline.
Transformations and Conversion File:
Some important points to remember
Web Admin parameters for file upload:
• ALLOWEXTENSIONS: Defines allowed file extensions for upload
• ALLOW_FILE_SIZE: This is the maximum file size a user is allowed to
upload. The default value is 100 MB.
• DEFAULT_EXTENSIONS: This is the list of default extensions that are
allowed. This list includes: XLS, XLT, DOC, DOT, PPT, POT, XML, MHT,
MHTML, HTM, HTML, XLSX, XLSM, XLSB, ZIP, PDF, PPTX, PPTM,
POTX, POTM, DOCX, DOCM, DOTX, DOTM, CDM, TDM, PNG, GIF,
JPG, CSS, MRC.
• Microsoft Access data cant be directly uploaded through Data Manager.
Conversion File:
·   Conversion files define the mapping by dimensions from external member names
to internal member names..
·   You create one conversion file per dimension in a transformation. Each conversion file can
contain one or more sheets for different types of data transformations.
Which are true about conversion files – one correct answer
o   There can be more conversion files for a dimension.
o   There can be only one conversion file for a dimension.
o   There cane n conversion files for 1 dimesnions.
o   Conversion files are mandatory.
·   Conversion files should be named the same as the dimension for which they are being used.
·   If you want to skip some external data use the word skip in the internal column
·   For example if you want to skip
EXTERNAL = FORECAST
INTERNAL = *SKIP
The users doesn’t want to load budget data for 2009 from external file. So how you ignore it in the
conversion file – one correct answer
·   Write a MDX command.
·   Use EVCOM function.
·   External Value = *SKIP .
·   *SKIP = Internal Value.
·  
·   JAVA SCRIPT can be used in conversion files. This is important remember.
Where you can use JAVA SCRIPT – one correct answer
o   In BADI’s
o   In transformation
o   In the EVDRE function
o   In the conversion file
·   Java Script code starts with string js.
·   What is transformation Option CONVERT_INTERNAL – 2 correct answers
·   CONVERT_INTERNAL = No – Java script can be used in internal column
·   CONVERT_INTERNAL=YES – Javascript can be used in external column.
·   CONVERT_INTERNAL – Convert the external to internal format.
·   CONVERT_INTERNAL is a function module.
Transformation’s Continued:
The transformation consists of 3 parts
·   Options
·   Mapping
·   Conversion
What are the required parameters in the transformation file  ?
·   Creditpositive
·   Delimeter
·   Format
·   Header
·   Maxrejcount..etc
What are optional parameters in the transformation file ?
·   Amountdecimalpoint
·   Convertamountdim
What  is CONVERTAMOUNTDIM parameter ?
It specifies which dimension to look at for value calculations.
• You must specify a dimension conversion sheet using the Amount Conversion option.
• If there is no formula in the Formula column of the Amount conversion sheet this parameter has no
affect at all. For example, the Formula column has the following formula: Value*1.10. All accounts will
be increased by 10% during the conversion.
• Default Value for this is Account.
What is the purpose of the Amount Conversion File. – refer Above
What is the purpose of the MAXREJECTCOUNT parameter.
·   If validating records, the number of rejected records at which to stop
processing.
·   A value of -1 implies that Data Manager (DM) should keep processing no
matter how many rejected records exist.
·   The default value is 500, which can be represented by an empty string.
What is the value to be set for MAXREJECTCOUNT parameter for the DM to continue processing
irrespective of the rejected records?
·   500
·   Space
·   -1
·   > 1
What are the standard packages available? – 3 answers
·   Data Management
·   Financial Processes
·   System Administration
·   Custom Processes
Transaction Data Load
Standard Options
·   Load transaction data from BW cube to BPC cube in the backend.
·   Load transaction data – full load from BW cube to BPC cubes through data manager.
·   Load transaction data – delta load from DSO to BPC cube through data manager.
·   Using open hub generate the delta flat file for data manager to load.
·     Using flat file data source – backend BW.
·   Using UD connect data source – backend BW.
·   Using flat file in data manager.
Custom or Out of the Box Options – Which needs custom development.
·   Load transaction data – delta load from BW cube to BPC cubes through data manager.
·   Load ERP data directly to BPC using custom process types.
·   Load ERP data to BW cubes and from BW cube load the BPC using DTP,transformation,etc.
Which one is  the out of the box solution: 1 correct answer
·   Load BW cube to BPC by data manager.
·   Load by flat file in the backend.
·   Load flat file in the data manager.
·   Load delta from BW cube to BPC using data manager.
Important Web Admin Parameters:
·     TEMPLATEVERSION – Current version number of the dynamic templates in your application set.
·   For email configuration
o   SMTPPASSWORD
o   SMTPPORT
o   SMTPSERVER
o   SMTUSER
·   BPC_STATISTICS – ON/OFF values to record the BPC statistics.
·   YTDINPUT – 1 – For YTD Format – 0 – For Periodic format. Very important parameter .
·   APPROVALORG – if you want to use the workstatus feature this field is used to identify the
hierarchy like H1,H2,etc
·   LANDINGPAGEITEM – user can input a page number which already existed in content library as
web page.
Important Web Admin Parameters:
·   TEMPLATEVERSION – Current version number of the dynamic templates in your application set.
·   For email configuration
o   SMTPPASSWORD
o   SMTPPORT
o   SMTPSERVER
o   SMTUSER
·   BPC_STATISTICS – ON/OFF values to record the BPC statistics.
·   YTDINPUT – 1 – For YTD Format – 0 – For Periodic format. Very important parameter .
·   APPROVALORG – if you want to use the workstatus feature this field is used to identify the
hierarchy like H1,H2,etc
·   LANDINGPAGEITEM – user can input a page number which already existed in content library as
web page.
Some more questions:
/CPMB/ namespace is reserved for BPC objects.
• InfoArea: /CPMB/BPC (Business Planning and Consolidation)
• InfoArea: /CPMB/IOBJGEN (below /CPMB/BPC)
• InfoObject catalog (/CPMB/IOBJGEN) (Required Attributes)
What are the reporting applications ?
What are the non-reporting applications ?
Can you assign work-status codes which application : reporting or non-reporting.
What are the required dimesions for reporting application?
What is light optimization ?
What is full optimization?
Changing the BI data model is light or full optimization?
Does partitioning available in BPC cubes ?
Does BPC uses the Sap standard time dimension ?
Is it possible to change the DB parameters in BW for BPC cubes ?
What are the objects get created in the backend when BPC application is created ?
Why a multiprovider and a query got created on top of the application cube and what is the purpose ?
Can a BPC infocube can be changed without the re modeling tool in BI ?
What information does UJA_APPL table contains ?
Does MDX statements select from the cube or from the query build on the multi provider ?
What is the purpose of the web admin parameter YTDINPUT ?
What is a measure ?
What is signeddata ?
What are the 3 delivered measure ?
What is the purpose of the UJA_FORMULA table ?
Why we need UJA_FORMULA and UJA_FORMULA_APP ?
What is concurrency lock?
What is tcodeRSPLSE ?
What you maintain in tcodeRSPLSE ?
Does BPS  and Integrated planning also use RSPLSE ?
What is UJR_PARAM table used for ?
What are the 2 types of locking ?
What is the formula for calculating id record level locking or interval level locking is needed/
What is sparsitycoefficient ?
Some questions from web - Cloneskills.com.Great place to learn BPC.
SAP BPC NW 7.0 Competency Development Program
Quiz Type  -  Open Book
Total Number of Questions  -  50
Questions Expected to
Answer
-  50
Duration  -  60 Min
1   True Or False
a.  Planning InfoCubes are write optimized but Standard InfoCubes are read optimized.
b.  Consolidation InfoCubes are write optimized because the request id stays open until a
threshold is reached for example.
c.  Request id's in real time cubes can be closed by switching the cube to the Standard type.
d.  A Real Time InfoCube has two 'data' modes, but only one will ever be used by Business
Planning and Consolidation.
e.  As data comes in to the Planning InfoCube, it arrives in the 'F' table and remains there until it
is compressed into the 'E' table.
f.  SAP BusinessObjects Planning and Consolidation can also be set up against Data Store
Objects.
2   Choose the Correct Answer(s)
a.  There are two main types of InfoObjects: Catalogs and InfoAreas.
b.  BW Characteristics have three potential types of master data.
c.  A BW Dimension table is exactly the same as an Business Planning and Consolidation
Dimension.
d.  InfoCubes are made up of Fact and Dimension tables.
3   Choose the Correct Answer(s)
a.  An SAP BusinessObjects Planning and Consolidation dimension is like a BW Characteristic
b.  An SAP BusinessObjects Planning and Consolidation property is like an Attribute in BW.
c.  The SAP BusinessObjects Planning and Consolidation 'signed data' column is like a key figure
in an InfoCube.
d.  An AppSet is like a BW InfoArea.
e.  An SAP BusinessObjects Planning and Consolidation team folder is equivalent to a BW Role.
f.  An SAP BusinessObjects Planning and Consolidation InfoCube is just like an Application in
BW.
4   Fill in the Blank: BPC Application Development can be carried out from the BPC _____________,
______________. The system automatically populates BW with the related object
5   BPC equivalent of BI Objects: Fill in the Blank
a.  Characteristics , ___________________________
b.  InfoCubes , ___________________________
c.  MultiProvider , ___________________________
d.  Process Chain, __________________________
e.  Transports, ______________________________
6   What are the entire required dimension “Non Reporting–Generic” Application?
7  What is the reference Application for “Reporting–Generic” application?
8   What is common between “Non Reporting– Generic” and “Reporting– Generic” Application?
9   We can not _______________ to “Non Reporting” application?
10   Which of the following application options are common between Finance and Consolidation
Application?
a.  Currency Conversion
b.  Calculation
c.  Intercompany Booking
d.  Intercompany Elimination
e.  Validations
f.  US Elimination
g.  Opening Balance
11   True Or False: Is it possible to create an Application without a Reference Application?
12   True Or False: Is it possible to create a Dimension without a Reference Dimension?
13   ________________ allow the automated processing of data to render a consolidated set of financial
statements.
14   When you create new applications, we need to select at least one ____________ dimension. Then
the ________________ need to allow access to the desired member
15   Measure dimension used to determine application as a ________________ OR _________________
16   Most secure system store balances on a ________________ basis whether the data is
entered/stored in daily, weekly , monthly , fiscal period
17   _____________ namespace is a reserved namespace in SAP NetWeaver BI for BPC
18   BPC Dimensions are created under an Application Set with BI Technical names of InfoObjects are
generated with naming convention /CPM/XXYYYYY, Where “XX” _____________ , and “YYYYY” is a
____________________ string
19  Default Application set for BPC Excel, Admin , Word , PPT can be set through
______________________
20   True Or False
a.  Only user with System Admin rights can create a new application , Dimension ,business rules
table , work status
b.  Only user with Admin rights can create a new application , Dimension ,business rules table ,
work status
c.  Only user with Primary Admin rights can create a new application , Dimension ,business rules
table , work status
21   How to create an application set without using an existing application set?
22   ___________,______________,_________________,______________ are copied from the source
application set to the target application set based on the user choice
23  ______________________ allows us to monitor the scheduled application set copy process
24   True Or False
a.  Does not copy the Master Data and Transaction Data
b.  Creates all the new Dimension with different technical name
c.  Copies WebFolder
d.  Any error in copy function will rollback all the data that has been copied and files that has
been created
25   ______________________, _____________________ are application status , _____________ can
be obtained while processing Dimension
26  True or False:
a.  Administrator can not continue to work on the Application Set when the Application set is in
“Unavailable”
b.  Users can continue to work on the Application Set when the Application set is in
“Unavailable”
27  Which of the following tasks can be performed when the application set is in Offline
a.  Executing Data Manager Package
b.  Write back through input schedule
c.  Executing Reports
28   Fill in the Blanks: _____________ will force an update of the template files to the clients , this can
be changed in _______________, and ___________________
29   Which of the following objects we can transport?
a.  Application Set
b.  Dimension Data
c.  Application Data
30   True or False:
a.  Every AppSet has a 2 character AppSetPrefix stored in a table called UJA_APPSET_INFO
b.  This prefix can be used in the technical name of
i..  InfoArea
ii.  InfoObject
iii.  InfoObject Catalog
iv.  InfoCube
31   ___________________ is new in BPC NW 7.0 , it logs all the .NET tier to the ABAP tier.
32
which of the following are new functions available only In SAP BPC NW 7.0 and this in available only
in SAP BI Administrator workbench and __________TCODE used to execute this function
a.  UJT_CHECK_TABLE_ENTRIES
b.  UJA_COPY_APPSET
c.  UJA_DATA_CHECKER
d.  UJS_ACTVIATE_CONTENT
33
______________ Dimension does not have to be part of any application within the set , and it is
needed validate ____________in the Entity dimension
34
_____________________, and ________________________ can be specified while creating
Dimension
35   True or False
a.  Dimension properties are SAP BI Attributes
b.  Dimension names are not case sensitive
c.  Dimension properties are not case sensitive
d.  Dimension names are 20 character length
e.  Dimension property names are not limited to any character length
f.  For an existing dimension property , you can only increase the length up to 60 character ,
you can not reduce the length
g.  To reduce the property storage length , we need to create a new dimension with the
reduced length and then copy the data from the old dimension to the new one
h.  Dimension properties properties which is more then 60 character stored in BW as a short
text ,
36
______________,_______________, __________________ are 3 different type of properties , and
_____________ property technical names won’t change
37   Choose the BEST - Dimension properties are used which of the following BPC Functions
a.  Reporting
b.  Data Manager Selection
c.  Logic Formulas
d.  Member Lookups
38   True or False
a.  You can not delete an Application if it is already assigned to an Application
b.  Member sheet is a temporary storage
c.  Member sheet each time rebuild from the SAP BW Database when we open it
d.  After deleting a member from an dimension requires “re-processing” both dimension and
application
39   Under what circumstance you create same dimension with different name , Example : ACCOUNT,
ACCOUNT_L , DATASRC , DATASRC_L , etc
a.  When same dimension needed for different application with different set of Members
b.  When same dimension needed for different application with same set of Members
c.  When same dimension needed for different application with different set of properties
d.  When same dimension needed for different application with same set of properties
40   True or False
a.  Hierarchy properties does not appear in the property list in “Maintain Dimension Property”
b.  PARENT“N” property can be directly added as a column in the Dimension member sheet via
“Maintain Dimension Member”
c.  You can not have PARENT1, PARENT3 and skip PARENT2 , this will fail in the validation
d.  You can have PARENT1, PARENT3 , PARENT2 , this will not fail order does not matter
e.  We can have PARENT”N” column for each different hierarchy rollup with in the dimension
f.  A parent will have the same children if it is used across multiple hierarchies
41   How many level we have in “CONUS” and “CONSMALL” hierarchy ?
42   Which of the following functions performed when we process the Dimension?
a.  Validate Hierarchy
b.  Validate Dimension Member Formula
c.  Update Member Data in BI
d.  BI attribute Change run in BI
e.  Invalidate Server cache for Dimension member by updating version
43   Which of the following Dimension definition can not be changed through SAP BW Admin workbench
a.  Base unit of Measure
b.  Currency Attribute
c.  Auth relevant
d.  Unit of Measure for Char
44   True Or False
a.  In a Dimension , All user defined properties are defined as a Navigational attributes
b.  In a Dimension , All user Reserved properties are defined as a Display attributes
c.  In SAP BW workbench, we have change the Attribute TAB only through the BPC Admin if
there is any change, not through the BW workbench
45   Choose the “BEST Option” to load master data
a.  Direct entry into the Member Sheet
b.  Copy from an external Excel file into Member Sheet
c.  BI File load process
d.  BPC Data Manager Flat File Load
e.  Use BI techniques to load into BI Data Target and then BPC
f.  BI load process directly into BPC
46   Choose the Best Answers - If you use BI technique to load master data you will have to
a.  You will need to run the hierarchy attribute change run in BI manually as well as make sure
the caching mechanisms in SAP Business Planning and Consolidation were updated
correctly.
b.  You can call ABAP program UJA_REFRESH_DIM_CACHE using the process type
“ABAP_PROGRAM” in a process chain to update the BPC dimension cache.
47   Which of the following tasks can be performed as a background job Via process chain?
a.  Copy Application
b.  Modify Application
c.  Optimize Application
d.  Copy AppSet.
48   True or False
a.  If the Application Type is Financial or Consolidations, then Journals are also copied during
Create.
b.  One Rate application can not be referenced by multiple other applications
c.  You can report on non-reporting application data, but you can assign work status codes to
the data.
49   Netweaver restrictions for the InfoObjects in the BPC-Cube are the same as in “normal” BI cubes
_____________ characteristics per BI-dimensions and ______ possible BI-dimensions
50
There ______________, ______________are 2 type of optimization techniques to optimize the
application
Some more questions:
We differentiate our training from others by delivering role based SAP Instruction rather than SAP
Product focused Training.
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 AppSetWebFolders/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).