Sample Questions (SQ01) 1-500 Flashcards
1
Q
Can you debug the data manager package ?
A
Program: UJD_TEST_PACKAGE .You must specify the User ID .The DM package can be selected with F4 . SQ01 1 P.
2
Q
How to debug the script logic ?
A
UJKT Program UJK_SCRIPT_LOGIC_TESTER will allow you to test and debug script logic SQ01 2 P.
3
Q
START_BADI ROUND.
CODE ….
ENDBADI.
What is ROUND ?
A
Technical name of the BADI. SQ01 3 P.
4
Q
startroutine = C1 endroutine = C2
What is C1 ?
A
Badi filters. SQ01 4 P.
5
Q
DM package doesn’t need a transformation file ? True or False.
A
Process performed by setting up two Excel files: Transformation file (required) .Conversion file (optional) SQ01 5 P.
6
Q
What is CONVERT_INTERNAL = NO in a transformation file?
A
- When transformation option CONVERT_INTERNAL = NO, the external column refers to the source
value, the internal column refers to the target dimension member you want to load into the
application. When Convert_internal =YES, the external column refers to
7
Q
Where you can use the Java script . ·Script logic ·Validation ·Transformation ·Conversion file
A
Answer; Conversion File SQ01 7 P.
8
Q
Can VB script be used in Netweaver BPC ?
A
No VB script in Netweaver BPC . SQ01 8 P.
9
Q
What are 3 components of Transformation file?
A
- Transformation file is selected during the run time of the import package. Transformation definitions are in Excel files that contain one worksheet named Instructions. The file is divided into 3 parts (*OPTIONS; *MAPPING, *CONVERSION)The transformation
10
Q
What is *XDIM & *COMMIT?
A
Tip: The *COMMIT statement will end any execution scope defined by any previous *XDIM scoping statements. If your script logic needs to continue after a *COMMIT, you will need to rescope by using additional *XDIM statements. SQ01 10 P.
11
Q
What is best practice for running validation on Data Manager Variable in a logic Script?
A
11.When validating a script logic file with a DM variable, the current response in a BPC75NW SP04 system (and earlier) is to error on the line containing the ${DataManagerVariable}$. This occurs due to the fact that the DM variable is not really defined u
12
Q
Can an IIF statement be included in *REC commands?
A
- The IIF statement allows a conditional IF/Then/Else statement to be defined for MDX based syntax. The IIF statements cannot be include *REC commands, but can be used within MDX tuple expressions. Each *REC command generates a new record. SQ01 12 P.
13
Q
What is *XDimName
A
- %{DimName}_SET%:A system generated keyword is available for each dimension. This keyword holds the set of members passed to the logic engine for a given dimension (i.e. the initial scope). This keyword can be used as a replacement string anywhere in
14
Q
When are *SELECT statements executed?
A
14.The *SELECT statement will be executed before any other statements regardless of its actual position in the script logic file. SQ01 14 P.
15
Q
WHEN/IS/REC/ENDWHEN cannot be written inside ____________?
A
- WHEN/IS/REC/ENDWHEN cannot be written inside SELECTCASE/ENDSELECT . SQ01 15 P.
16
Q
What properties are not supported inside REC statements?
A
- Dynamic Properities such as HLEVEL, PARENTHn are not supported inside REC statement. SQ01 16 P.
17
Q
Where does REC belong?
A
- REC always needs to be accompained within WHEN/IS/ENDWHEN. Stand alone REC statements will not have any effects . SQ01 17 P.
18
Q
What are 5 restrictions on *REC statement? When can’t you use keyfigure/ SIGNEDDATA?
A
There are restrictions when using the *REC statement and these are:
You can’t use MDX keywords in the expression
You can’t use the GET() function
You can’t use the NOADD function
You can’t use the SIGNEDDATA key figure (OQuantity, 0Balance) – put into on
19
Q
What is LOOKUP? Limitation?
A
LOOKUP to another application within logic script. 19. Multiple LOOKUP blocks for same Application is not supported . SQ01 19 P.
20
Q
What command is used to convert the keyfigure model to account model ?
A
MVAL? Answer not provided by source. SQ01 20 P.
21
Q
Script logic calculations cannot cross applications within on Appset – True or False.
A
TRUE, Any logic that is created is model specific, SQ01 21 P.
22
Q
Script Logic is used to calc data but only for base level data in the application. True or False.
A
TRUE SQ01 22 P.
23
Q
The *REC instruction tells the program what to do once the specified criteria has been met. – True or False.
A
TRUE SQ01 23 P.
24
Q
*XDIM_MEMBERSET ACCOUNT=CASH
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET TIME = 2006.JAN
*XDIM_MEMBERSET CATEGORY = ACTUAL
*XDIM_MEMBERSET INTCO=NON_INTERCO
*START_BADI CUST_CALC_ACCT
ACCT_FROM = 10000
ACCT_TO = 10001
*END_BADI
What is CUST_CALC_ACCT
A
Technical name of the BADI. *– starts indicate SQL coding. [ ] are for MDX coding. SQ01 24 P.
25
What is RUNLOGIC keyword allow you to do?
run scripts in parralell for better performance SQ01 25 P.
26
The list of supported MDX functions is available from function module ____?
BAPI_MDPROVIDER_GET_FUNCTIONS. -- MDXLIB.Lgf SQ01 26 P.
27
Which are the on the fly calculations ?
Dimension member formulas. SQ01 27 P.
28
Which logic is stored in the database ?
Script logic. Other logics are worksheet & Dimension Member Formulas SQ01 28 P.
29
Dimesnion member formulas and worksheet logic are not stored in the database – True or False.
TRUE - dimension member formulas are generated during execution of report or input template. SQ01 29 P.
30
What do you need to use dimension member formulas ?
Formula property in the dimension. SQ01 30 P.
31
Any property with length greater than 60 is stored as a string in SAP NetWeaver BW – True or False.
True? Properties that are longer than 60 characters (in the BPC version for SAP NetWeaver) will still be accommodated, but the characters over 60 will be stored differently in BW, so the property won’t support the use of their property ID’s in programs a
32
What property is required by all currency type dimensions ?
Ø Currency Type SQ01 32 P.
33
Dimension and dimension members are case sensitive – True or False.
False, but All Caps is best practice so that they can be used in Logic. Logic is case sensitive. SQ01 33 P.
34
What does process a dimension do?
- Validate the formulas
- Validate the hierarchy
- Save it to the database. SQ01 34 P.
35
What is solve order ?
Solve Order determines the order in which dimensions, members, calculated
members, custom rollups, and calculated cells are evaluated, and the order in
which they are calculated. SQ01 35 P.
36
What is the highest priority of the solve order ?
36.What is the highest priority of the solve order ?
| Zero is the highest priority. SQ01 36 P.
37
What is the file service tcode in BW?
UJFS SQ01 37 P.
38
What is system constants file?
Is the logic file that allows you to map dimension names from the application to the standard system variables used in SAP Business Planning and Consolidation 7.5 dynamic logic. SQ01 38 P.
39
What is Mdxlib.lgf.
MDXLibrary.lgf contains base examples of dimension formulas . SQ01 39 P.
40
What is default logic file ?
Default.LGF file SQ01 40 P.
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 executab
42
What are the major 10.0 enhancements?
reporting, front-end, consolidation enhancements, BW links including security, elmination of .NET layer., enhanced data manager, books and publishing. See text p. 624 SQ01 42 P.624
43
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
44
*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(EXPRESS
?answer? SQ01 43 P.
45
```
Allocation Function?
Explain
Ø WHAT
Ø WHERE
Ø USING
Ø TOTAL
Ø FACTOR
```
*RUNALLOCATION
*FACTOR=
*DIM P_ACCT WHAT=; WHERE=; Using=;
[Total=]
*DIM
*ENDALLOCATION SQ01 44 P.
46
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_MAXME
47
What command is used to update the records in the database ?
COMMIT . SQ01 46 P.
48
Can you use data manager prompts in the script logic ? TRUE or FALSE
TRUE SQ01 47 P.
49
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
50
What are delivered measures ?
Periodic, QTD, YTD SQ01 49 P.
51
What are custom measures ?
Using ABAP program UJA_MAINTAIN_MEASURE_FORMULA SQ01 50 P.
52
Custom measures can be created using ABAp program – TRUE or FALSE.
TRUE SQ01 51 P.
53
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 refere
54
XDIM_MEMBERSET doesńt allow Properties. What are 2 work arounds?
*SELECT & XDIM_FILTER SQ01 53 P.
55
%DIMNAME_SET% is a variable which inherits the dimension member from the current view. – TRUE or FALSE .
?answer? SQ01 54 P.
56
What are 4 types of methods to read the data ?
RSDRI, MDX, AXIS, CELL - I think this is EVDRE related. SQ01 55 P.
57
What is UJSTATS tcode ?
BPC_STATISTICS SQ01 56 P.
58
How to switch on the stats and what is the web parameter ?
Application Web parameter called BPC_STATISTICS – Should be set to ON SQ01 57 P.
59
What type of query EVDRE creates – RSDRI or MDX ?
?answer? SQ01 58 P.
60
What is the purpose of the program UJO_STATISTICS_DELETE ?
Delete the stats table entries. SQ01 59 P.
61
Cell queries have been moved to Axis Queries because they are faster even though they bring back more data – TRUE or FALSE.
?answer? SQ01 60 P.
62
What is sparsity coefficient ?
no longer used SQ01 61 P.
63
CoefficientPost BPC 7.0 SP3, the Sparsity Coeffiecientis no longer used – TRUE or FALSE.
TRUE SQ01 62 P.
64
Custom suppression adds another EVDRE – TRUE o FALSE
TRUE SQ01 63 P.
65
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
66
What are the options of DRILL THROUGH?
Jump to any website
Jump to a BW query
Jump to ECC tcode SQ01 65 P.
67
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 SQ01 66 P.
68
During first cons the diff between the investment and the parents share of subs equity Is
written to goodwill . -- TRUE OR FALSE
TRUE SQ01 67 P.
69
The purchase method only adjusts the investment for market value changes in the subsidiary --TRUE OR FALSE
FALSE SQ01 68 P.
70
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 SQ01 69 P.
71
Annual Net Income of the subsidiary is split between the parent and the minority shareholders during subsequent consolidation activities .--TRUE OR FALSE
TRUE SQ01 70 P.
72
When the consolidation program is executed, it reads dim prop, cons methods and percentages in the
ownership app. TRUE OR FALSE
TRUE SQ01 80 P.
73
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 - DimList is an important property for source & target in BCF(balance carry forward) IC Elim, balancing logic, … SQ01 81 P.
74
The method assignments by entity and their percentages are read from the DHE(Dynamic Hierarchy Editor) -- TRUE OR FALSE
FALSE - Read from ownership model and components. the components that are working together to successfully accomplish a validate consolidation include a hierarchy, the ownership model, a method definition, and method assignment. SQ01 82 P.35
75
Dynamic hieracgy Editor is available in NW BPC 7.5. --TRUE OR FALSE
TRUE SQ01 83 P.
76
DHE is a user interface and data is stored in the cube ?--TRUE OR FALSE
TRUE SQ01 84 P.
77
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 SQ01 85 P.
78
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 whichmatches all of its declarations against the balance of the
TRUE SQ01 86 P.
79
The IC Matching App is a Financial Type with Currency Conversion and Intercompany Booking business rules .--TRUE OR FALSE
TRUE SQ01 87 P.
80
Intercompany Matching vs BO InterCompany
Note: Intercompany Matching versus SAP BusinessObjects InterCompany By the way, planning and consolidation intercompany matching isn’t to be confused with one of the other SAP products called SAP BusinessObjects InterCompany, which also performs intercomp
81
Running the ICDATA.LGF logic file via the corresponding ICDATA package runs intercompany reconciliation .--TRUE OR FALSE
TRUE SQ01 88 P.
82
Running the ICBOOKING.LGF via the ICBooking package runs intercompany reconciliation and posts differences .--TRUE OR FALSE
TRUE SQ01 89 P.
83
Setting up the Seller rule type in ICBooking Business Rules means that the seller will receive any variances . TRUE OR FALSE
FALSE.
S -Seller: The seller is correct, so the buyer receives the difference.
B -Buyer: The buyer is correct, so the seller receives the difference.
G-Greatest: Entity with the greatest amount receives the difference. SQ01 90 P.495
84
ICMatching postings happen at the group level. TRUE OR FALSE
False - base entity level. SQ01 91 P.
85
ICMatching postings happen at the entity level.-- TRUE OR FALSE
True - not at group level. SQ01 92 P.
86
US Elim entries happen at Group Level . TRUE OR FALSE
True This ownership data will be used to book elimination entries at each group level. SQ01 93 P.440
87
Automatic Adjust entries happen at Group or Group & Entity Level. TRUE OR FALSE
TRUE SQ01 94 P.
88
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 SQ01 95 P.
89
TRUE OR FALSE
FALSE SQ01 96 P.
90
The Plug/offset account should be balanced at Group level . TRUE OR FALSE
TRUE SQ01 97 P.
91
The Elim is written to a diff data src so that the initial value of the account is not overwritten . TRUE OR FALSE
TRUE SQ01 98 P.
92
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 - First common parent. SQ01 99 P.
93
% of Ownership = Shares Owned/Shares Outstanding*100.
% of Minority Interest = 100 –(Shares Owned/Shares Outstanding*100)
TRUE OR FALSE
TRUE SQ01 100 P.
94
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 SQ01 101 P.
95
the reverse amount is booked to a Plug account . TRUE OR FALSE
TRUE SQ01 102 P.
96
Processing a dimension will execute the following 4 steps:
* Validate Hierarchy.
* Validate Dimension member formulas.
* Update member data into BW.
* BW Attribute change run. SQ01 103 P.
97
Plug Account should be balanced at group level (only Intercompany missmatches are left).
TRUE SQ01 104 P.
98
ACCTYPE is required for account type dimensions and is used to control sign display and aggregation behavior in reporting. TRUE OR FALSE
TRUE SQ01 105 P.
99
DIMLIST# properties are used as selection criteria in business rules. TRUE OR FALSE
TRUE SQ01 106 P.
100
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 SQ01 107 P.
101
What are these symbos used for ? // * . #
// denote comments.
'*' indicates executable lines of code. SQL
No '.' at the end of statements.
'#' is used in MDX statements to denote the receiver of the calculation SQ01 107 P.
102
What is the tcode for logic debugging?
UJKT Program UJK_SCRIPT_LOGIC_TESTER will allow you to test and debug script logic SQ01 108 P.
103
What is tcode to access Netweaver Logic files?
UJFS -- might be used with system constants file SQ01 109 P.
104
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 SQ01 110 P.
105
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 SQ01 111 P.
106
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 SQ01 112 P.
107
If the source InfoCube has multiple key figures, the MVAL keyword can be used to import the data in only one data load.
TRUE SQ01 113 P.
108
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 - A popular journal control feature is the idea of limiting which dimension members can be used in journal postings by using the ENABLEJRN property. You can use this property in any dimension type, but it’s best used with the DataSource type dimensio
109
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 SQ01 115 P.
110
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 wi
TRUE SQ01 116 P.
111
"Validation:The only operators are '<>' and '='. But you can include multiple single values separated by commas.
TRUE SQ01 117 P.
112
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 r
CREDIT POSITIVE - If NO, all amounts referring to an account type (LEQ,INC) will have their signs reversed. SQ01 118 P.298
113
What is Team?
A group of users. Fairly equivalent to a NW role. One user can be designated as a team leader. Team Lead has right to manage team folder. SQ01 119 P.516
114
It is the combination of member access profiles & task profiles that
determine overall BPC access. TRUE OR FALSE
TRUE SQ01 120 P.
115
What are 8 important programs?
```
UJA_COPY_APPSET
UJBR -- UJA_APPSET_BAK_RESTORE
UJ0_STATISTICS_DELETE
UJA3_WRITE_SYS_ADMIN_NO_CHECK
UJA_REFRESH_DIM_CACHE
UJKT -- UJK_SCRIPT_LOGIC_TESTER
UJT_CHECK_TABLE_ENTRIES will allow you to check table entries for transports
MDX Test SQ01 121 P.
```
116
What are tables within BW system?
/B28/F or E -- Tables associated with cube fall under /B28/F or E namespace
UJ --Tables associated with the ABAP fall under UJ namespace
/CPMB/ -- All the BI objects would get created under /CPMB/ name space. SQ01 122 P.
117
Compare Microsoft Analysis Server table to BW tables:
Open Request – Write Back table
Fact Table – Fac2 Table
E Table – Fact Table SQ01 123 P.
118
You can find the tables through their technical names in SE16 tcode. -- TRUE OR FALSE
TRUE -- SE16 and view table TSTC - this table holds all the tcodes available in BW SQ01 124 P.
119
What is SE16 & TSTC?
SE16 and view table TSTC - this table holds all the tcodes available in BW SQ01 125 P.
120
Describe Light and Full Optimization. What is different between the two?
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 NetW
121
data remodel is done in full optimization .--TRUE OR FALSE
TRUE SQ01 126 P.
122
Compression is done in Lite and Full optimization. --TRUE OR FALSE
TRUE SQ01 127 P.
123
BPC 7.5 SP05 patch 1 increased formatting performance by 40% --TRUE OR FALSE
TRUE SQ01 128 P.
124
You can change the BPC dimensions in the backend with BW.--TRUE OR FALSE
FALSE SQ01 129 P.
125
Cell queries have been moved to Axis Queries because they are faster even though they bring back more data.--TRUE OR FALSE
TRUE SQ01 130 P.
126
If multiple EVDRE’s are needed, the first EVDRE should be RSDRI in order to build the rows.--TRUE OR FALSE
TRUE SQ01 131 P.
127
Work Status is set up from the Administrators at both the application set and application level. --TRUE OR FALSE
TRUE SQ01 132 P.
128
Work Status is set only athe application level .--TRUE OR FALSE
FALSE SQ01 133 P.
129
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 SQ01 134 P.
130
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 SQ01 135 P.
131
Work Status:You can define only one hierarchy for each application within an application set.--TRUE OR FALSE
TRUE SQ01 136 P.
132
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 SQ01 137 P.
133
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 SQ01 138 P.
134
Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver. --TRUE OR FALSE
TRUE SQ01 139 P.
135
There is a reporting function EVLCK available as well. This function provides a read only comment retrieval for Work Status.--TRUE OR FALSE
TRUE SQ01 140 P.
136
Script logic statements are case-insensitive.--TRUE OR FALSE
test says TRUE, but I think this is FALSE. Seen cases where if dimension is not in all caps it does not recognize. SQ01 141 P.
137
You cannot use MDX keywords in *REC.--TRUE OR FALSE
TRUE SQ01 142 P.
138
REC always needs to be accompanied by WHEN / IS / ENDWHEN. Stand-alone REC statements do not have any effect.--TRUE OR FALSE
TRUE SQ01 143 P.
139
*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 loop
140
What is a limitation of SELECT statement?
The SELECT statement is fairly limited, as it only supports the equal sign (=) , not equal to (<>) and cannot be used to combine multiple filtercriteria with AND or OR keywords. SQ01 145 P.
141
How many nestings of SELECTCASE can you have?
SELECTCASE structures currently CANNOT be nested. SQ01 146 P.
142
Which has much better performance? WHEN/ENDWHEN OR *SELECTCASE?
WHEN/ENDWHEN which has a much better performance then *SELECTCASE. SQ01 147 P.
143
What is the syntax for dimension member formulas?
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 functio
144
What is default SOLVE_ORDER for measures? For members?
The SAP Business Planning and Consolidation default Solve_Order is
equal to 3 for measures and 5 for members. SQ01 148 P.
145
What is the Spread funcion?
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 n
146
What is Trend function?
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 p
147
What is weighted function?
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 ce
148
How is the comment feature enabled for both methods?
The comment feature must be turned on at the Application level for both methods. SQ01 161 P.
149
What is EVCOM?
Add a comment to a cell. SQ01 162 P.
150
```
Comments are stored in which of the following?
Ø Cube
Ø DSO
Ø Real time cube
Ø Table
```
Table - is that why can't use a copy package to copy them? SQ01 163 P.
151
Which reporting commands update the data base:
- EVDRE
- EVGTS
- EVCOM
- EVBT
EVDRE & EVCOM SQ01 164 P.
152
To use the excel popup feature for comments, you need to turn that on via th workbook options.--TRUE OR FALSE
TRUE SQ01 165 P.
153
What are system reports?
```
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 SQ01 166 P.
```
154
What are the fields of a distribution template?
Answer needs to be updated for BPC 10.0
• 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 fi
155
Validations configuration is performed in transaction UJ_VALIDATION.--TRUE OR FALSE
TRUE SQ01 168 P.
156
One driver dimension for each application for validation. --TRUE OR FALSE
True -- application = Model. SQ01 169 P.
157
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. SQ01 170 P.
158
What is the relationship of Rules & Members? #:#
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). SQ01 171 P.
159
You can turn validations on or off by application.TRUE OR FALSE
TRUE SQ01 172 P.
160
What is EVUSR? What is BPC 10.0 equivalent?
The EvUSR (User ID) function returns the name of the user who is logged on to the system. EPMuser () SQ01 173 P.
161
What is EVAST? What is BPC 10.0 equivalent?
174.The EvAST (Application set) function returns the name of the current application set. EPMEnvDatabaseID SQ01 174 P.
162
What is EVAPP?
The EvAPP (Application) function returns the current application name. SQ01 175 P.
163
What is EVDES?
The EvDES (Description) function returns the description of a specified member. SQ01 176 P.
164
What is EVDIM?
The EvDIM (Dimension) function retrieves a dimension name of the specified type from the database. SQ01 177 P.
165
What is EVPRO?
The EVPRO function returns the value of a specified property for a specified member. SQ01 178 P.
166
What is EVTRI?
The EvRTI function returns the time and date of the last data refresh. SQ01 179 P.
167
What is EVCOM?
The EvCOM function references another cell and sends its value, a textual comment, to the database when specified. SQ01 180 P.
168
What is EVHOT?
The EvHOT (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 adhoc analysis. SQ01 181 P.
169
What is 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. SQ01 182 P.
170
What does Send & Refresh do?
The Send function references another cell and sends its value to the database when you select Send and Refresh Schedules. SQ01 183 P.
171
What is EVTIM?
The EvTIM (time period offset) function specifies an offset from a given time period. SQ01 184 P.
172
How did you set the current view in BPC 7.5?
You can double click on the EVCVW output to set the current view. EVDRE templates use the EVCVW function in the page key range. SQ01 185 P.
173
What is EVBET?
EVBET is used to calculate variances in conjunction with the ACCTYPE property. Use EVPRO to pull in the account type property. EVBET performs a variance calculation based on the acctype value. For example, if revenue actual is greater than plan, the vari
174
What is the AVAILABLEFLAG?
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) SQ01 188 P.
175
What is YTDINPUT?
YTDINPUT This parameter controls whether data is input in year-todate 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 YT
176
Deleting & leaving blank required and optional parameters
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. SQ01 190 P.
177
```
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.
```
Leave it blank to accept the default SQ01 191 P.
178
What is TOPDOWN?
You can set work status to top-down in the TOPDOWN field in the Application Parameters. SQ01 192 P.
179
What are work status locks?
Work Status locks can allow you to lock down documents that have had the Application Context specified. SQ01 193 P.
180
What is LANDINGPAGEITEM? BPC 7.5
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). SQ01 194 P.
181
What is AS_IS? What can it be combined with? When use it?
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. For Co
182
What are END, AVG, COPYLC, OPEND, AS_IS, OPEAVG ?
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
183
What are Equity Method, Purchase Method, & Proportional Method?
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 E
184
```
A owns 80% of B company, 70% of C and 40 % of D.
Which company can use the quity method.
B
B & C
D
A
```
A company can use the equity method. SQ01 199 P.
185
What do properties used in the dynamic hierarchy editor for Ownership begin with?
Org - The properties that begin with 'Org' all relate to the dynamic hierarchy editor. SQ01 200 P.
186
What are 2 ways to enter Ownership data?
Ownership data can be entered via the Dynamic Hierarchy Editor or via input templates. SQ01 201 P.
187
There are five possible adjustment types: But typically this is blank except for Equity and Proportionate.
```
10.0
Blank --Purchase method.
Equity -- Equity method.
Proportional -- Proportional method.
Leaving -- Divestitures.
```
```
7.5
• Generic
• Equity
• Proportional
• New (acquisitions)
• Leaving (divestitures) SQ01 202 P.
```
188
In 7.5, what was MS equivalent of "Groups"?
"Consolview". In the NetWeaver release, the 'Groups' dimension is typically used whereas the Microsoft release referred to it as the 'Consolview' dimension. SQ01 203 P.
189
Are businss rules like Automatic Adjustment broken down by model or environment?
The business rules are broken down into Appset and Application sections for Automatic Adjustments SQ01 204 P.
190
Where is the destination datasource assigned to the method? What is in the automatic adjustment details?
In the Appset, the Rules, Methods, and Formulas are defined. 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
191
What is a requirment for IC Elimination entries?
must be in same group. Share a common parent. 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 p
192
The adjustment types include the same 5 rule types.
```
10.0
Blank --Purchase method.
Equity -- Equity method.
Proportional -- Proportional method.
Leaving -- Divestitures.
```
```
7.5
• Generic
• Equity
• Proportional
• New (acquisitions)
• Leaving (divestitures) SQ01 207 P.
```
193
What are 4 consolidation methods in 10.0?
10. 0 These are different types of consolidation methods such as the 86-Purchase Method, 70-Proportional Method, 90-Holding Method, and 30-Equity Method.
7. 5 The consolidation method types include: New, Holding, Global,Proportional, Equity, Leaving @ the b
194
How do commit instructions impact performance?
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 communicatio
195
BPC supports compounded info objects . TRUE OR FALSE
FALSE there is no concept of compounding in a BPC InfoObject. The is compounding in BW. If you have a compound InfoObject, this means that there is a superior InfoObject that controls the core InfoObject
Compounding is the addition of another InfoObj
196
BPC doesn’t support compounded info objects.You have to write proper transformation .--TRUE OR FALSE
Answer says false, but thought this was TRUE. SQ01 211 P.
197
What % of consolidation are Proportionate, Full, Holding done?
1 SQ01 ck P.
198
What are four data packages available?
Standard Data Loading Packages
Financial Packages
Administrative Packages
Misc Packages SQ01 212 P.
199
What is the Import Hierarchy package?
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 writi
200
The Master data BADI is based on the table level .--TRUE OR FALSE
TRUE SQ01 214 P.
201
The Transaction data BADI is based on the package level -- True or False?
TRUE SQ01 215 P.
202
What is different about packages vs package links?
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. SQ01 216 P.
203
What are the options available for transaction data load ?
Merge and Replace options are both available . SQ01 217 P.
204
How many driver dims per application is allowed while setting up validations? What is code for validations?
One driver dim per application is allowed while setting up validations using UJ_VALIDATIONS. SQ01 218 P.
205
The driver dim can only be the account dim while setting up validations.--TRUE OR FALSE
FALSE SQ01 219 P.
206
If two applications are using the account dim , the validation will be set across applications.--TRUE OR FALSE
TRUE SQ01 220 P.
207
```
All config in UJ_VALIDATION is _____Specific
Application
App Set
Dimension
DSO
```
AppSet = Environment 10.0 SQ01 221 P.
208
```
Which of the following are used in setting up UJ_VALIDATIONS?
A. Value ranges
B. Use non existing members
C. Only = sign
D. You can include multiple values.
```
?answer? SQ01 222 P.
209
It is possible to turn validations on/off by Journals, Manual Planning and Data Manager.--TRUE OR FALSE
TRUE SQ01 223 P.
210
Which of the following is true with regards to validations(7.5) Controls (10.0)?
A. All validations config can be transported
B. Validations integrate with Activity Audit
C. Authorisation is controlled by access to task profiles
D. last changed date and t
Answer: A,B,D. C- work status determines acess for Controls? SQ01 224 P.
211
It is possible to log the process of copying and deleting an Appset.--TRUE OR FALSE
FALSE SQ01 225 P.
212
All changes regarding activation and de-activation of audits is logged into the system--TRUE OR FALSE
TRUE SQ01 226 P.
213
An Application set is equivalent to a MS Analysis Services Database.--TRUE OR FALSE
TRUE SQ01 227 P.
214
An Application is equivalent to a table in a relational database--TRUE OR FALSE
TRUE SQ01 228 P.
215
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 . SQ01 229 P.
216
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
Custom menus aren’t migrated; instead, they are replaced with the workspaces and
activities options in BPC V10.0. SQ01 230 P.
217
```
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
```
Export dim SQ01 231 P.
218
```
Processing a dim in the MS version will execute the following steps.
A. Create info objects
B. Save to the server
C. Validate the Formulas
D. Validate the hierarchies
```
C & D -- validate the formulas and hierarchies. SQ01 232 P.
219
You can schedule processing of dimensions in the MS Version .--TRUE OR FALSE
TRUE SQ01 233 P.
220
Duplicate dim types are allowed in one application.--TRUE OR FALSE
FALSE. Note:Duplicates are allowed if it is user defined dimesnions. SQ01 234 P.
221
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 SQ01 235 P.
222
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. SQ01 236 P.
223
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 SQ01 237 P.
224
Index Defragmentation has no effect on FACT Tables.--TRUE OR FALSE
FALSE Note:ID can update all indices and statistics to receive a faster access to the data. ID has an effect on FACT tables . SQ01 238 P.
225
The BPC DM is an instance of the MS Analysis Integration Services.--TRUE OR FALSE
TRUE SQ01 239 P.
226
Data Manager can handle meta data.--TRUE OR FALSE
FALSE. Note: Only Master data and Transaction data. Meta data is what is stored locally for reporting. SQ01 240 P.
227
Clear package creates an additional record with a reverse sign and is eliminated upon compression to achieve the deleted effect.--TRUE OR FALSE
TRUE SQ01 241 P.
228
Worksheet Logic does not require a call to the server.-TRUE OR FALSE
TRUE SQ01 242 P.
229
Worksheet Logic doesn’t update the database.--TRUE OR FALSE
TRUE SQ01 243 P.
230
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 SQ01 244 P.
231
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 SQ01 255 P.
232
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 SQ01 256 P.
233
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 . SQ01 257 P.
234
There are no dynamic template wizard available for the EVDRE function .--TRUE OR FALSE
TRUE SQ01 258 P.
235
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 SQ01 259 P.
236
You cannot build a static report using EVDRE.--TRUE OR FALSE
FALSE SQ01 260 P.
237
```
The ________ option controls the sending of data by EVDRE .
Workbook
Esubmit
Eanalyze
Etools
```
workbook SQ01 261 P.
238
Where do you set the layout as input schedule or report?
Workbook options – Input schedule or Report. SQ01 262 P.
239
Refresh option recreates the sturcture of the report and then refreshes the cells.--TRUE OR FALSE
FALSE. Note: Expand All does this. SQ01 263 P.
240
What is the difference between EXPANDALL and REFRESH ?
EXPANDALL expands and refreshes, while refresh only refreshes the cells. SQ01 264 P.
241
EXPANDALL is more time consuming than REFRESH.--TRUE OR FALSE
TRUE SQ01 265 P.
242
The member for each dim is tied to the CV from the Page Key Range using the EVCVW function.--TRUE OR FALSE
TRUE SQ01 266 P.
243
The _________ allows you to select the members from a member lookup
dialog box by double clicking on the cell that contains the formula
EVCOM
EVMBR
EVCVW
EVITM
EVMBR = EPMMemberSelector (10.0) SQ01 267 P.
244
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. SQ01 268 P.
245
You can base the suppression option on a diff region of data than the one being retrieved.--TRUE OR FALSE
TRUE SQ01 269 P.
246
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. SQ01 270 P.
247
Time is a flat dimension .--TRUE OR FALSE
FALSE Note: Times ia hierachial dimension . Category is pretty flat. SQ01 271 P.
248
In BPC you can assign task profiles directly to users.--TRUE OR FALSE
TRUE SQ01 272 P.
249
In BPC you can assign task profiles to Team and assign users to the team.--TRUE OR FALSE
TRUE SQ01 273 P.
250
Drag and drop reporting provides an alternative method for creating reports and does not use the EVDRE Functions .--TRUE OR FALSE
FALSE SQ01 274 P.
251
In EVDRE , Report is pulled by Page Key Range and not by Current View.--TRUE OR FALSE
TRUE SQ01 275 P.
252
BW has detailed level data and BPC is executive data.--TRUE OR FALSE
TRUE SQ01 276 P.
253
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 SQ01 277 P.
254
```
The dimension type that is required for effecting currency
translations is
Currency Type
Flow Type
Entity Type
Rate Type
```
Currency Type SQ01 278 P.
255
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. SQ01 279 P.
256
```
A step is re-opened? What is the next step status?
Open
Re-open
Pending
Delayed
```
Answer: Delayed . SQ01 280 P.
257
```
What is BW object equivalent to a BPC cube?
Info cube
Info object
DSO
Info area
Table
```
InfoCube SQ01 281 P.
258
```
Where are the archived reports stored in BW?
Cube
SAO
Write DSO
Real Time cube
Tables
```
Answer: Tables SQ01 281 P.
259
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. SQ01 282 P.
260
```
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 (Ownership, Consolidation, Rate Models) SQ01 283 P.
261
IC Matching is required for consolidation setup.--TRUE OR FALSE
FALSE SQ01 284 P.
262
What are the 3 apps required for Legal consolidation
Ownership, Rate, Legal SQ01 285 P.
263
Ownership and Rate for non-reporting type apps.--TRUE OR FALSE
TRUE SQ01 286 P.
264
Rate is like equivalent to TCURR in ECC system.--TRUE OR FALSE
TRUE SQ01 287 P.
265
```
Which of these transformation file options is unique for NW setup?
SELECTION
MAXREJECTCOUNT
VALIDATION
SELECT
```
SELECTION SQ01 288 P.
266
What is not possible through work-status?
To lock a BPF – Business Process Workflow SQ01 289 P.
267
What is the name of the program to check the appset consistency ?
UJA_APP_DATA_CHECKER SQ01 290 P.
268
```
Transaction data is described by
Infocube
Dimension
Appset
Dimension Members
Calculated KF’s
```
Answer: Dimension Members SQ01 291 P.
269
The required dim types for reporting,generic is A, C, E, T .--TRUE OR FALSE
True: Account, Category, Entity, Time SQ01 292 P.
270
During optimization the records are moved from the F-fact table to the E-fact table. True or False
TRUE SQ01 293 P.
271
SAP BPC does not have the facility of partitioning/portioning.--TRUE OR FALSE
TRUE SQ01 294 P.
272
```
You can access the "Modify Work Status option thru the __________menu.
Edata
Esubmit
Eanalyse
Etools
```
eSubmit (7.5)
| 10.0 -- Data Input / Save Data / "change work status" SQ01 295 P.
273
The copy package can copy from several senders to one receiver.--TRUE OR FALSE
FALSE Note: Always 1:1 relationship. SQ01 296 P.
274
Compounding is supported in the /CPMB namespace.--TRUE OR FALSE
False. there is no concept of compounding in a BPC InfoObject. Compounding is the addition of another InfoObject that is required for the purposes of defining another
InfoObject. SQ01 297 P.
275
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. SQ01 298 P.
276
A user can be both a system admin and primary admin .--TRUE OR FALSE
TRUE SQ01 299 P.
277
Default logic references system constants which allow you to use different dim names .-- True or False.
TRUE SQ01 300 P.
278
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 SQ01 301 P.
279
Validation must be run to clear the validation account .TRUE OR FALSE
TRUE SQ01 302 P.
280
The designated validation account is specified in work status config
(MS only) .TRUE OR FALSE
TRUE SQ01 303 P.
281
Every time the validation is run, the validation account is incremented by 1 so the user knows how many times the validation was run . True or false
FALSE SQ01 304 P.
282
The *REC instruction tells the program what to do once the specified criteria has been met .
TRUE SQ01 305 P.
283
Each *REC instruction generates one new record to post to the data base TRUE OR FALSE
true. instruction tells the program what to do after the specified criteria has been met. Each REC instruction generates one new record to post to the database. Each source record can generate as many records as desired, even pointing to the same destina
284
Script logic calculations cannot cross applications within on Appset .TRUE OR FALSE
FALSE SQ01 307 P.
285
Script Logic is used to calc data but only for base level data in the application. TRUE OR FALSE
TRUE SQ01 308 P.
286
You use journals to record and make adjustments to the database.--TRUE OR FALSE
TRUE SQ01 309 P.
287
How many journal templates are in an Application/Model?
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 model/application. Application set = Environment (10.0) SQ01 310 P.
288
```
The Ownership Account contains which of the following?
Percentages
Methods
Parent Positions
Entity
Rates
```
Answer: Percentages,Methods and positions. Note: R_RATE & R_Entity are their own dimensions. SQ01 311 P.
289
Ownership data is collected and stored by entity and intco. TRUE OR FALSE
TRUE SQ01 312 P.
290
In the ownership cube percentages and methods are stored by Entity. TRUE OR FALSE
TRUE SQ01 313 P.
291
Any user with "manage template task " can save and update objects to the company folder or team folder .TRUE OR FALSE
TRUE SQ01 314 P.
292
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 SQ01 315 P.
293
One can decide to store data in YTD or on a Periodic basis setting the AppSet Parameters .TRUE OR FALSE
TRUE SQ01 316 P.
294
What is the BW equivalent of Environment/App set?
InfoArea SQ01 317 P.
295
Which dimensions appear in the Context/CurrentView?
All dimensions in the application appear in the current view SQ01 318 P.
296
Selection for multiple single values or ranges in Context/CurrentView is allowed?
No. Multiple single values or ranges are not allowed - Current View . SQ01 319 P.
297
Is the Context/Current view user dependent?
The Current View is user dependent, therefore you will only be able to view information that your member access profile allows. SQ01 320 P.
298
What is the workbook option for read only or save data?
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'." SQ01 321 P.
299
Offline Mode/Park n Go lock down the report or input schedule and the current view data.TRUE OR FALSE
TRUE SQ01 322 P.
300
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 SQ01 323 P.
301
What are the 10 dimension types?
A C D E G I R S T U - Account, Category, AuditTrail, Entity, Group(Scope), Intercompany, Currency, Subtables(Flow), Time, UserDefined SQ01 324 P.
302
What is the new dimension in 7.5?
Group SQ01 325 P.
303
4. Which business rules are used in the consolidation monitor?
Note: There are 3 correct answers to this question.
a) Account-based calculations
b) US eliminations
c) Eliminations and adjustments
d) Currency translation
e) Global definitions
c,d,e, --- Eliminations & Adjustments, Currency Translation, Global Definitions SQ01 ck P.
304
Which business rules are contained in Global Definitions?
Methods, Method-based multipliers SQ01 ck P.
305
What is a Method business rule?
These are different types of consolidation methods such as the 86-Purchase Method, 70-Proportional Method, 90-Holding Method, and 30-Equity Method. SQ01 ck P.432
306
What is a Method-based Multiplier business rule?
This table contains rules that are used to select entity source values and apply percentages to those values to ultimately book new data records. SQ01 ck P.432
307
What is IFRS and US GAAP? Which is more specific GAAP or IFRS ?
GAAP is more specific . One of the major differences lies in the conceptual approach: U.S. GAAP is rule-based, whereas IFRS is principle-based. The inherent characteristic of a principles-based framework is the potential of different interpretations for
308
BPC allows periodic or YTD data storage while BCS is always periodic. TRUE OR FALSE
True. BCS is an older version of BPC. SQ01 327 P.
309
What is the soft limit on dimensions in the MS version per Model/Application?
The Microsoft versions have a soft limit of 20 dimensions per Application .
SQ01 328 P.
310
How many key figures are allowed for an InfoCube?
InfoCubes used for Business Planning and Consolidation only contain one key figure. SQ01 329 P.
311
How do you manage Request IDs? What is the threshold?
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.
The data storage for the BPC mo
312
What are the corresponding Fact Tables between MS & NW?
MS -- BW/NW
Open Request – Write Back table
Fact Table – Fac2 Table
E Table – Fact Table SQ01 331 P.
313
What are the MS Fact tables?
Open Request, Fact Table, E table. SQ01 ck P.
314
What are the BW Fact tables?
Write Back, Fac2, Fact table SQ01 ck P.
315
What happens when a model is created?
underlying infocube, multiprovider, and query are created. SQ01 332 P.
316
Why is a multiprovider created when BPC model is created ?
to support the interface between the EPM add-in reporting and the InfoCube itself SQ01 333 P.137
317
Why is a query created when a BPC model is created ?
?not sure?. to support the interface between the EPM add-in reporting and the InfoCube itself SQ01 334 P.
318
What can / can't be done with non-reporting application data?
Can (report) Cannot(assign work status, define business rules).
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.
SQ01 335 P
319
When you create an application you reference an application and business rules ? TRUE OR FALSE
TRUE SQ01 336 P.
320
What are the components of BPC Security?
Users, Teams, Data Access Profile(7.5=member access profile), Task profile SQ01 337 P.
321
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 SQ01 338 P.
322
```
If the carry forward business planning function isn't working, it may be because the following web application parameter is not set.
CARRYFORWARD
OPENING BALANCE
COPY OPENING
BALANCE CARRYOVER
```
COPY_OPENING.LGF SQ01 339 P.
323
What is COPY_OPENING.LGF?
Runs a balance carry forward business rule (COPY_OPENING). SQ01 CK P.387
324
What are 3 logic scripts that run intercompany reconciliation?
ICBOOKING.LGF ICDATA.LGF ICELIM.LGF SQ01 CK P.387
325
What are two libraries and what do they contain?
MDXLIB.LGF SYSTEM_LIBRARY.LGF - one is MDX specific and one is basic set of keywords. SQ01 CK P.387
326
How do you run a validation rule?
run package VALIDATION.LGF. SQ01 CK P.387
327
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
Answer: 2 are correct answers . Answer not provided. My guess is the first two. SQ01 340 P.
328
Define the following: DIMLIST#, GROUP, ELIMACC, FORMULA.
’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. S
329
What do properties used in the dynamic hierarchy editor for Ownership begin with?
Org - The properties that begin with 'Org' all relate to the dynamic hierarchy editor. SQ01 342 P.
330
Can you delete a dimension when it is being used by a Model?
no SQ01 343 P.
331
How are these dimensions referenced by other dimensions? C, A, E, I
Category & Time – year common
Account & Account – Rate Type property
Entity & Currency – Local currency property
Intercompany & Entity – Entity values SQ01 344 P.
332
What is CALC? What are 2 other system generated properties?
a system generated property that indicates calculated members. 2 other system are HIR, Description. SQ01 345 P.
333
How are hierarchies stored in NW?
Hierarchies are stored as SAP NetWeaver BW Hierarchies. SQ01 346 P.
334
How are hierarchies stored in MS version?
Hierarchies are stored as a separate dimension in MS version. SQ01 347 P.
335
What is SCALING?
SCALING is a property of account used to display values in thousandsfor example in formula based reports. =EPMScaleData() SQ01 348 P.
336
What are the 4 account types?
AST, LEQ, INC, EXP SQ01 349 P.
337
Is it possible to create custom account types?
No SQ01 350 P.
338
Check the signs for the account types stored in DB and reporting ?
Account type. Can be INC for Income, EXP for Expense, AST for Asset, and LEQ for Liabilities and Equity. The account type can’t be blank. This is a critical property because it controls the signage of the transactional data that is uploaded. It’s used to
339
What does processing a dimension do?
* Validate Dimension member formulas.
* Validate Hierarchy .
* Update member data into BW.
* BW Attribute change run. SQ01 352 P.
340
```
Which 2 functions can be used using script logic and business rules? 2 answers are correct.
A. Carry Forward
B. Validation
C. Automatic ajustments
D. Currency Translation
```
Answer : A & D SQ01 353 P.
341
What are 2 categories for business rules? Name 5 business rules.
Global Definitions & Consolidations. (there are more). CCEMM Methods, Method-based multipliers, currency translation, Eliminations & Adjustments, Carry-Forward. Both MM are Global Definitions. The others are Consolidations. SQ01 ck P.
342
In MS, what would prevent the work status from advancing in regards to "validation"?
In microsoft the work status cannot be advanced if the ’validation’ account as defined in the application work status has a non zero value. SQ01 354 P.
343
```
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 SQ01 355 P.
344
```
When you load the data to the BPC info provider you want to delete the existing data and reload the new data. What options do you select?
Merge and replace the date
Append the date
Delete and do a full load
Replace and clear
Merge the data
```
Replace and Clear SQ01 356 P.
345
What is Distribution & Collection?
Distribute worksheets via excel or pdf. Collect input schedules. Sets reports into Offline mode before saving. SQ01 357 P.
346
Only reports can be distributed and collected and not the Input Schedules ?
TRUE OR FALSE
FALSE SQ01 358 P.
347
What are the Out of the Box solution for loading the master data load?
A. Load Master Data from SAP ERP directly into BPC, version for SAP NetWeaver .
B. Load Master Data from SAP NetWeaver BI Characteristics Directly Using Data Manager
C. Flat file by DM
Answer; A & B -- Why not all 4? Others require configuration? SQ01 359 P.
348
What are the Out of the Box solution for loading the transaction data load ?
A. Load transaction data from SAP NetWeaver BI using an Open Hub destination that provides flat files to data manager (Delta Load)
B. Load transaction data from SAP NetWeaver BI
Answer: A & B SQ01 360 P.
349
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 SQ01 361 P.
350
What is new dimension type G?
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 . SQ01 362 P.
351
MS uses 'stored proceddures'. What does NW use?
Stored procedures are used on the Microsoft product but not in NW.NW uses process chains and programs. SQ01 363 P.
352
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 SQ01 364 P.
353
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 SQ01 365 P.
354
```
What are the required dimensions to create the BPF instances ?
Time
Time and category
Category
Entity,category and Time
```
time SQ01 366 P.
355
What is the opening step for BPF process?
there is none. SQ01 367 P.
356
```
When an BPF action is completed or status changed who gets notified ?
Owner
Reviewer
Manager
Admin
```
Owner because it is completed. Reviewer has already seen.
The owner of an activity receives an e-mail notification when the activity is open to perform, approved/rejected by reviewer, and reopened.
The responsible reviewer for an activity receives an e-
357
What is required dimension for BPF? What is best practice to define an instance?
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 . SQ01 369 P.
358
The first step of the BPF always opens regardless of the opening criteria.TRUE OR FALSE
TRUE SQ01 370 P.
359
What is the Reopen setting for BPF?
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. SQ01 371 P.
360
What is BPF Opening Criteria? What is All? What is Matched?
All or Matched, then if want, "Allow Reopen". All(only when all predecessors are complete for all process contexts), Matched(activity can be started for a specific context if predecessor for same context is complete) See Admin in BPC/create new templat
361
What are 3 valid drill through calls?
Any URL, Any BEX Query, Any ECC tcode SQ01 373 P.
362
At what level is Data Audit captured?
Application level=Model 10.0 SQ01 374 P.
363
At what level is Activity audit captured?
AppSet = Environment 10.0 SQ01 375 P.
364
What do you have to do when a new Model is created?
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
365
When is packaging not used? Why is packing used?
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). SQ01 377 P.
366
Where do you specify the hierarchy for which you want to track the work status of deliverables?
You specify the hierarchy for which you want to track the work status of deliverables in the APPROVALORG field on the Setting Application Parameters . SQ01 378 P.
367
Is email notification equally available in 7.5 MS & NW?
Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver. SQ01 379 P.
368
What controls access to Models?
Member Access Profile, Tasks. -- or money and booze :-) SQ01 380 P.
369
What is a limitation of dimension property?
Size cannot be decreased. SQ01 381 P.
370
What is the required DIM for inter-company setup?
Intercompany or C_Account ? Unsure? SQ01 382 P.
371
What can you do while creating a BPF?
Matched opening criteria, owner…? SQ01 383 P.
372
There is a problem in currency translation. Where would you look?
Property MD in Rate. MD property (If the currency is used in the Rate model, then this property is required. This defines whether the currency exchange rate for that currency is used to multiply or divide with the local amount.) SQ01 384 P.109
373
BPF. A step is re-opened. What is the next step status?
Delayed (previous activity reopened). If an activity is reopened, the Status is changed to Reopen and that status is available for others to see. Activities must be reopened in sequence. SQ01 385 P.
374
What is BW object equivalent to a BPC cube?
InfoObject SQ01 386 P.
375
Where are the archived reports stored in BW?
Answer: Tables SQ01 387 P.
376
What can you do in web admin interface?
Dimensions & Models, Security, Rules, BPF, Features
Rules BCLM (Business Rules, Controls Logic Scripts,Member Formulas )
BPF(Process Template, Process Instance)
Features (Audit, Context Defaults, Document Types, Drill-Through, Journals, Work Status,) SQ01
377
Which of these would require additional programming while loading data?
Open hub data load SQ01 389 P.
378
Where do you set up the data audit for transactional data? App level or Appset level and where( web-admin/BPC client)
Answer: Web Admin Parameters at application level. SQ01 390 P.
379
An application is not shown while logging into excel. What is wrong?
Member Access is not given. SQ01 396 P.
380
What are the reporting applications/models ?
Financial, Consolidation, Standard SQ01 398 P.
381
What are the non-reporting applications/models?
exchange rates, ownership, generic -- Drivers & Rates is umbrella. SQ01 399 P.
382
Can you assign work-status codes which application
reporting or non-reporting. Work status creates stricter access that data access by limiting activities permitted such as (Data Manager, Journal, Manual Entry, Comments, Documents) SQ01 400 P.
383
What are the required dimesions for reporting application?
Financial(A C E R T), Consolidation (A C D E G I R S T), Standard (A C E T) SQ01 401 P.
384
What doe light optimization do?
closes open request, compresses without zero-elimination and indexes the cube, updates database statistics for the BW InfoCube. SQ01 402 P.
385
What does Full optimization do?
Sames as light. Plus it checks to see if data model can be improved. SQ01 403 P.
386
What are the full optimization checks?
dimension tables have <20% size of Fact table, moves data to shadow cube, compress, index,…NEW technical name. SQ01 ck P.
387
Changing the BI data model is light or full optimization?
full SQ01 404 P.
388
Does BPC uses the Sap standard time dimension ?
No, not yet in 10.0 either. SQ01 406 P.
389
Is it possible to change the DB parameters in BW for BPC cubes ?
Yes, but the parameters are wiped on a full optimization. Ex: roll-up, query cache, db performance SQ01 407 P.
390
What are the objects get created in the backend when BPC application is created ?
InfoProvider, query, MultiProvider SQ01 408 P.
391
Why is a multiprovider and a query created on top of the application cube and what is the purpose ?
for the local client SQ01 409 P.
392
Can a BPC infocube can be changed without the re modeling tool in BI ?
Yes, there is no remodeling tool in BPC. SQ01 410 P.
393
What information does UJA_APPL table contain?
The technical name of the InfoProviders SQ01 411 P.
394
Does MDX statements select from the cube or from the query built on the multi provider ?
MDX statements are performed against query which is on top of the MultiProvider. SQ01 412 P.
395
What is the purpose of the web admin parameter YTDINPUT ?
YTDINPUT This parameter controls whether data is input in year-todate 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 YT
396
What is a measure ?
Periodic, QTD, YTD SQ01 414 P.
397
What is signeddata ?
sign of data stored /Inc LEQ SQ01 415 P.
398
What are the 3 delivered measure ?
Periodic, QTD, YTD SQ01 416 P.
399
What is the purpose of the UJA_FORMULA table ?
create custom measures. There are tables for custom measures. Need to update both tables. SQ01 417 P.
400
Why do we need UJA_FORMULA and UJA_FORMULA_APP ?
create custom measures. There are tables for custom measures. Need to update both tables. SQ01 418 P.
401
What is concurrency lock?
locking of transaction data when 1 or more users save to same location at same time. DURING SAVE DATA.
Concurrency locking prevents users from saving data to the same region of the cube at the same time. ALL mechanisms that write data into a cube (for e
402
What is tcode RSPLSE ?
Lock management SQ01 420 P.
403
What you maintain in tcode RSPLSE ?
Lock management SQ01 421 P.
404
Does BPS and Integrated planning also use RSPLSE ?
answer? SQ01 422 P.
405
What is UJR_PARAM table used for ?
code for changing save data "Package Size". UJR_PARAM OR transaction code UJR0 SQ01 423 P.
406
What are the 2 types of locking ?
answer? SQ01 424 P.
407
What is the formula for calculating id record level locking or intervallevel locking is needed/
answer? SQ01 425 P.
408
What is sparsity coefficient ?
no longer used. SQ01 426 P.
409
BPC Data Manager packages are technically executed as a BW process chain. TRUE OR FALSE
TRUE SQ01 427 P.
410
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 cu
?ANSWER? SQ01 428 P.
411
# 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 Dimensi
?answer? SQ01 429 P.
412
# 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 Conso
?ANSWER? SQ01 430 P.
413
Fill in the Blank: BPC Application Development can be carried out from the BPC _____________, ______________. The system automatically populates BW with the related object
Model Wizard? SQ01 431 P.
414
BPC equivalent of BI Objects: Fill in the Blank
a. Characteristics , ___________________________
b. InfoCubes , ___________________________
c. MultiProvider , ___________________________
d. Process Chain, __________________________
e. Transports, ________
```
master data/properties
Model
Environment
Data Package
Transformation? SQ01 432 P.
```
415
What are the required dimensions for “Non Reporting –Generic” Application?
Account, Category, Entity, Time SQ01 433 P.
416
What is the reference Application for “Reporting–Generic”application?
Drivers & Rates (10.0) SQ01 434 P.
417
What is common between “Non Reporting– Generic” and “Reporting– Generic” Application? Standard vs Generic Report.
A, C, E, T Account, Category, Entity, Time SQ01 435 P.
418
We can not _______________ to “Non Reporting” application?
?answer? SQ01 436 P.
419
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
only ACETR in Reporting, therefore. A,B,E are possible. Nothing with I,G,S dimensions. SQ01 437 P.
420
Is it possible to create an Model without a Reference Model?
Yes. Create a new model with wizard, don't need to reference an existing model. SQ01 438 P.
421
Is it possible to create a Dimension without a Reference Dimension?
Yes. SQ01 439 P.
422
________________ allow the automated processing of data to render a consolidated set of financial statements.
scripts ? SQ01 440 P.
423
When you create new applications, we need to select at least one ____________ dimension. Then the ________________ need to allow access to the desired member
secured, security? SQ01 441 P.
424
Measure dimension used to determine application as a ________________ OR _________________
periodic or YTD? SQ01 442 P.
425
Most secure system store balances on a ________________ basis whether the data is entered/stored in daily, weekly , monthly , fiscal period
balances could be YTD. Most systems are periodic. SQ01 443 P.
426
_____________ namespace is a reserved namespace in SAP NetWeaver BI for BPC
/B28/F or E -- Tables associated with cube fall under /B28/F or E namespace
UJ --Tables associated with the ABAP fall under UJ namespace
/CPMB/ -- All the BI objects would get created under /CPMB/ name space. SQ01 444 P.
427
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.
/CPMB/[SHELL ID + MODEL ID]AD or text or package?? SQ01 445 P.
428
Default Application set for BPC Excel, Admin , Word , PPT can be set through ______________________
options? SQ01 446 P.
429
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
A. Primary.
What are task rights of System Administrator?1 - manage environments 2 - Manage Security 3-Use system when offline
What are task rights of Secondary Administrator?Manage dimensions, Edit Content of Public Folder
What are task rights of Primary
430
How to create an application set without using an existing application set?
choose not to reference an existing in the wizard. SQ01 448 P.
431
___________,______________,_________________,______________ are copied from the source application set to the target application set based on the user choice
reports, input forms, journal template(option), control definitions (option), and data packages copy over to the new model. Source data(no), data (yes). SQ01 449 P.
432
______________________ allows us to monitor the scheduled application set copy process
Process monitor? SQ01 450 P.
433
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 cr
A. False, B.? , C. true(if this means reports), d. true. SQ01 451 P.
434
______________________, _____________________ are application status , _____________ can be obtained while processing Dimension
?answer? SQ01 452 P.
435
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”
A. False. can use offline. B. False. SQ01 453 P.
436
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
reports can be run, but data incorrect. Others are unavailable. SQ01 454 P.
437
Fill in the Blanks: _____________ will force an update of the template files to the clients , this can be changed in _______________, and ___________________.
?answer? Version, "Set template version"(current version for dynamic templates) & "change status" (offline or online) SQ01 455 P.
438
Which of the following objects we can transport?
a. Application Set
b. Dimension Data
c. Application Data
transaction data is not tranported. Master Data is tranportable. SQ01 456 P.
439
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
True? /CPMB/[SHELL ID + MODEL ID]AD or text or package?? ShellID(2 char) ModelID(3char) SQ01 457 P.
440
___________________ is new in BPC NW 7.0 , it logs all the .NET tier to the ABAP tier.
no .Net layer in MS or NW. SQ01 458 P.39
441
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. U
?answer? SQ01 459 P.
442
______________ Dimension does not have to be part of any application within the set , and it is needed validate ____________in the Entity dimension
?answer? SQ01 459 P.
443
_____________________, and ________________________ can be specified while creating Dimension.
?answer? SQ01 460 P.
444
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 le
?answer? SQ01 461 P.
445
______________,_______________, __________________ are 3 different type of properties , and _____________ property technical names won’t change
?answer? SQ01 461 P.
446
# 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
reporting SQ01 462 P.
447
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 r
?answer? SQ01 463 P.
448
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 differ
?answer? SQ01 464 P.
449
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,
?answer? SQ01 465 P.
450
How many level we have in “CONUS” and “CONSMALL” hierarchy ?
?ANSWER? SQ01 466 P.
451
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 v
?answer?all but e? SQ01 467 P.
452
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
TRUE SQ01 468 P.
453
True Or False
a. In a Dimension , All user defined properties aredefined 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 throug
TRUE SQ01 469 P.
454
# 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 B
?answer? F. BI load process directly into BPC SQ01 470 P.
455
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 up
?answer? SQ01 471 P.
456
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.
?answer? Optimize application SQ01 472 P.
457
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
?answer? SQ01 473 P.
458
Netweaver restrictions for the InfoObjects in the BPC-Cube are the same as in “normal” BI cubes _____________ characteristics per Bidimensions and ______ possible BI-dimensions.
?answer? SQ01 474 P.
459
There are 2 type of optimization techniques to optimize the application.
?ANSWER? SQ01 475 P.
460
In the Context of BPC, Explain actual data with example?
?ANSWER? SQ01 476 P.
461
In the Context of BPC, Explain plan data with example?
?ANSWER? SQ01 477 P.
462
In the Context of BPC, Explain forecast data with example?
?ANSWER? SQ01 478 P.
463
In the Context of BPC, Explain outlook data with example?
?ANSWER? SQ01 479 P.
464
In the Context of BPC, Explain budget data with example?
?ANSWER? SQ01 480 P.
465
In the Context of BPC, Explain GL data with example, and explain the use of GL data in BPC?
?ANSWER? SQ01 481 P.
466
In the Context of BPC, Explain COPA data with example, and explain the use of COPA data in BPC?
?ANSWER? SQ01 482 P.
467
What the “ACTUAL” Transaction data required for GPM (Gross Margin Planning) for a company like Wal-Mart?
?ANSWER? SQ01 483 P.
468
What the “ACTUAL” Transaction data required for Sales for a company like Wal-Mart?
?ANSWER? SQ01 484 P.
469
What the “ACTUAL” Transaction data required for P&L Planning for a company like Wal- Mart?
?ANSWER? SQ01 485 P.
470
What the “ACTUAL” Transaction data required for Balance Sheet Planning for a company like Wal-Mart?
?ANSWER? SQ01 486 P.
471
What the “ACTUAL” Transaction data required for Cash Flow
?ANSWER? SQ01 487 P.
472
What the “ACTUAL” Transaction data required for COGS planning for a company like Wal- Mart?
?ANSWER? SQ01 488 P.
473
What the “ACTUAL” Transaction data required for HCM planning for a company like Wal- Mart?
?ANSWER? SQ01 489 P.
474
What the “ACTUAL” Transaction data required for Legal Consolidation for a company like Wal-Mart?
?ANSWER? SQ01 490 P.
475
What the “ACTUAL” Transaction data required for COI for a company like Wal-Mart?
?ANSWER? SQ01 491 P.
476
What is Full P&L for a company like Wal-Mart?
?ANSWER? SQ01 492 P.
477
Explain Flow dimension with example?
?ANSWER? SQ01 493 P.
478
Explain Monthly, Quarterly and Half Month Closing Proces
?ANSWER? SQ01 494 P.
479
Explain Local, Transaction, Report, and Group Currency?
?ANSWER? SQ01 495 P.
480
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 Entit
?ANSWER? SQ01 496 P.
481
In the Context of BPC, Explain cost allocation, activity based costing, fixed cost, variable cost and product costing?
?ANSWER? SQ01 497 P.
482
In the Context of BPC, What are Equity, Minority Interest, US GAPP, and UK GAPP?
?ANSWER? SQ01 498 P.
483
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
?ANSWER? SQ01 499 P.
484
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
?ANSWER? SQ01 500 P.
485
What is the difference between Management and Statuary Reporting; also explain with example for a company like Wal-Mart?
?ANSWER? SQ01 501 P.
486
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
?ANSWER? SQ01 502 P.
487
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
?ANSWER? SQ01 502 P.
488
What is the difference between Legal and Profit Center Consolidation?
?ANSWER? SQ01 503 P.
489
Explain the consolidation proces in details the tasks that are performed during consolidation?
?ANSWER? SQ01 504 P.
490
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 exist
checker SQ01 505 P.
491
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 T
?ANSWER? SQ01 506 P.
492
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.
?ANSWER? SQ01 507 P.
493
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
?ANSWER? SQ01 508 P.
494
The _______________ is an important tool to log to different application sets and to set the default set.
?ANSWER? SQ01 509 P.
495
Which of the following steps are executed When you create a new AppSet
a. Copy the AppSet WebFolders/Data within File Service
b. Creates a copy of all NW BW Objects (different technical names)
c. Moves all data to copied AppSet from source AppSet (both tr
?answer? SQ01 510 P.
496
____________________ 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.
?answer? SQ01 511 P.
497
_____________________ program can be used to check the transport entries of an AppSet.
UJA_APP_DATA_CHECKER - after a transport is run or UJT_CHECK_TABLE_ENTRIES will allow you to check table entries for transports. SQ01 512 P.
498
____________________ program can be used to check the consistency for an AppSet.
UJT_CHECK_TABLE_ENTRIES will allow you to check table entries for transports SQ01 513 P.
499
Which dimensions are required in every Model?
ACET SQ01 514 P.
500
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 cop
?answer? SQ01 515 P.
