BPC420 NW Administration L07 - L22 Flashcards
(495 cards)
1
Q
A
2
Q
What is Lesson 07?
A
Creating Dimensions BPC420 P.85
3
Q
LO Create dimensions & Members
A
See Questions. BPC420 P.85
4
Q
LO Create properties & hieararchies
A
See Questions. BPC420 P.85
5
Q
What is the related BW object for Dimension Property?
A
Integration between dimensions and InfoObjects of type characteristic BPC420 P.85
6
Q
What is a dimension?
A
dimension is a collection of related members, which represent one aspect of a business, i.e. accounts, products, currency. BPC420 P.85
7
Q
How are dimensions managed?
A
Define members, create hierarchies, assign properties BPC420 P.85
8
Q
Do dimensions belong to only one model?
A
dimensions can be added to one or more models. BPC420 P.85
9
Q
Are Dimension IDs case sensitve? Unique?
A
no, yes BPC420 P.87
10
Q
What are the dimension ID guidelines?
A
no special char, 16 char length, No number at position1, no reserved names (app, AppAccess, formula,…. List p 87) BPC420 P.87
11
Q
What are dimension description guidelines?
A
255 char max BPC420 P.88
12
Q
What does type allow?
A
Allows you to organize dta within model based on type BPC420 P.88
13
Q
What is referential integrity?
A
validates properties of dimension with the IDs of a different dimension, completes during processing. BPC420 P.88
14
Q
What are the different dimension types?
A
A, C, D, E, G, I, R, S, T, U Account, Category, Audit, Entity, Group, Intercompany, Currency, Subtables, Time, User defined. BPC420 P.88
15
Q
Can an environment have multiple dimensions of one type?
A
Yes, however only one of each of the required types. BPC420 P.88
16
Q
Which dimension types are required for a model?
A
A, C, D, E, R, T - BPC420 P.88
17
Q
What is A-Account?
A
chare og accounts and measures, stat keys BPC420 P.88
18
Q
What is C-Category?
A
Budget, Forecast, actual BPC420 P.88
19
Q
What is D - Audit?
A
Data source, used to segregate input data BPC420 P.88
20
Q
What is E-Entity?
A
business units, cost center, geographic entity, profit cneter, legal company, region BPC420 P.88
21
Q
What is G-Group?
A
Group provides multiple currencies for a group member. Uses single entity structure to report consolidated results in multiple group currencies. BPC420 P.89
22
Q
What do you need to know about using R & G?
A
Consolidation Model (R & G). Ownership Model (only G when referred from consolidation model. Cannot have R & G in the same ownership model). BPC420 P.89
23
Q
What is I- intercompany?
A
contains the intercompany codes for entities, for legal consolidation intercompany matching and elimination. BPC420 P.89
24
Q
What is R-Currency?
A
All environments must contain, not each model. NOTE: Reporting Model with Currency must have REPORTING property, not required for non-reporting model. BPC420 P.89
25
What is S-Subtables?
Used to break down account activity or flow. (Opening, Additions, Deletions, Transfers, Ending Balances). BPC420 P.89
26
What is Subtables important for?
writing business rules that require currency translation amounts to be calculated by account. BPC420 P.89
27
Whati is T-Time ?
custom time or weekly, monthly, quarterly BPC420 P.89
28
What is U-User?
Any User-defined dimension for planning process. U1, U2, … BPC420 P.89
29
Tell about predefined properties?
based on dimension type, a dimension contains pre-defined properties. Add new Properties as desired. BPC420 P.89
30
Why would one flag "allow dimension formulas"?
to allow creation of member formulas BPC420 P.90
31
What are two ways to open up the structure of a dimension?
"Edit Structure" in toolbar or hyperlink BPC420 P.90
32
What do properties do?
define behavior of dimension members BPC420 P.91
33
What are some powerful features of properties?
member lookup, formulas, data manager selections, reporting, filtering, BPC420 P.91
34
What are 3 ways to use properties for a region?
1-filter & sort 2-logic 3-defined report format BPC420 P.91
35
What are rules for Properties?
not case sensitive, unique, ID 20 char max, no special char, no number in position1, not a reserved word, BPC420 P.91
36
What is max length of Property ID?
20 char BPC420 P.91
37
What is max length of Property name?
40 char BPC420 P.91
38
What are the required dimension types?
A, C, D, E, R, T - BPC420 P.91
39
What properties can be modified or removed?
system-generated properties cannot be removed or modified. Othes may be. BPC420 P.92
40
What are some system-generated properties?
ACCTYPE, RATETYPE, SCALING BPC420 P.92
41
What properties are generated for all dimension types, but not displayed?
Description, CALC, HIR BPC420 P.93
42
What is CALC?
indicates whether calculated by formul or is at parent level. BPC420 P.93
43
What is HIR?
stores the hierarchy IDs associated with the member, H1, H2,.. BPC420 P.93
44
What are 2 reserved IDs?
SOLVE\_ORDER , FORMULA BPC420 P.93
45
What is SOLVE\_ORDER?
a property that defines the order of calculation when calculated members intersect calculated members BPC420 P.93
46
What is FORMULA property?
optional property that allows you to define dimension member formulas BPC420 P.93
47
What is max chars for dimension member?
32 in 10.0, 20 in 7.5 BPC420 P.95
48
What special characters are allowed in Dimension member ids?
\_ & - (underscore & hyphen) BPC420 P.95
49
What is Delete & Revert?
only available if the changes are not confirmed to the dimension members BPC420 P.98
50
What is the command to change oder of appearance?
"Apply Hierarchy order" - requires that Hiearchy is set up BPC420 P.98
51
What does the "display" option do in list view?
view property header by name or by ID BPC420 P.99
52
What does the "display" option do in hierarchy view?
display member id, description, or both. BPC420 P.99
53
What type of object is a dimension in BW?
InfoObject of type Characteristic BPC420 P.99
54
What does the "maintain" button in BW show you?
data in InfoProvider, what does it look like? 2 green squares BPC420 P.123
55
In BW where is the "maintain hierarchies" button?
On the hierarchy tab of the InfoProvider BPC420 P.123
56
How do you get to view the hieararchy in BW?
InfoProvider, Hierarchy tab, click "maintain Hiearachies" button, double-click yellow bar BPC420 P.123
57
In BW what does the "Expand Branch" icon look like?
Two triangles pointed down. Shows full hiearachy. BPC420 P.123
58
What is Lesson 08?
Creating Models BPC420 P.126
59
LO - Discuss the Creation of a Model
See Questions. BPC420 P.126
60
LO - Explain Model Page features
See Questions. BPC420 P.126
61
LO - Outline the do's and don'ts in BW InfoProviders created in BPC
See Questions. BPC420 P.126
62
LO- Describe delivered Measure Formulas and define Custom Measures
See Questions. BPC420 P.126
63
How do you create a model?
Use the six step wizard BPC420 P.128
64
What are the two main types of model?
Reporting (Standard, Financial, Consoldiation) & "Drivers and Rates" (Exchange Rates, Ownership, Generic) BPC420 P.128
65
What are the six types of model?
Reporting (Standard, Financial, Consoldiation) & "Drivers and Rates" (Exchange Rates, Ownership, Generic) BPC420 P.128
66
What are the 2 Data Entry modes for a model?
Periodic or YTD BPC420 P.128
67
What is general setting for data entry mode?
Periodic BPC420 P.128
68
When is YTD data entry mode used?
model with foreign currency conversion. Balances are accumulated/YTD BPC420 P.128
69
Describe a Standard model
No special requirements, no default business intelligenc/Logic. Create logic as needed. BPC420 P.128
70
What are the required dimensions for a standard model?
A, C, E, T Account, Category, Entity, Time BPC420 P.128
71
Describe a Financial Model
Perform management and legal consolidation functions,Supports these business rules(currency conversion, account transformation, interompany bookings, US eliminations, carry-forward, validations), choose a rate model. BPC420 P.128
72
What are the required dimensions for a Financial model?
A, C, E, T, R Account, Category, Entity, Time, Currency BPC420 P.128
73
Describe a Consolidation Model
Complicated legal consolidation (complex organization structures involving full, partial, minority ownership and consolidation methods. Must reference an ownership model: Supports/Uses business rules (Currency conversion, account transformation, intercompany bookings, US eliminations, carry-forward rules, validations, automatic adjustments) BPC420 P.128
74
What are the required dimensions for a Conolidation model? 9
A, C, D, E, G, I, R, S, T Account, Category, Audit, Entity, Group, Intercompany, Currency, Subtables, Time, BPC420 P.128
75
what are three reporting model types?
Reporting (Standard, Financial, Consoldiation) & "Drivers and Rates" (Exchange Rates, Ownership, Generic) BPC420 P.128
76
What are three Driver & rate model types?
Reporting (Standard, Financial, Consoldiation) & "Drivers and Rates" (Exchange Rates, Ownership, Generic) BPC420 P.128
77
What do reporting models hold?
financial data BPC420 P.128
78
All models require which 4 dimension types?
A,C, E,T - Account, category, entity, time BPC420 P.128
79
What is the special business rule in consoldiations not in standard?
Automatic Adjustments BPC420 P.128
80
What are the additional required dimensions for consolidation?
D, G, I, R, S, Audit, Group, Intercompany, Currency, Subtables, BPC420 P.128
81
What is the synonym for subtable?
Flow BPC420 P.128
82
What is a benefit of copying a model?
reports, input forms, journal template(option), control definitions (option), and data packages copy over to the new model. BPC420 P.130
83
Will Source Data transfer when copying a model?
source data no, data yes, BPC420 P.130
84
Can you have duplicated diminsion types in a model?
no, exception is user defined which are unique by U1, U2, … BPC420 P.130
85
When copying a model, where are business rules activated?
in "Business Rules" view. BPC420 P.137
86
What are control definitions?
Financial and Consolidation type BPC420 P.137
87
What are 5 features of a model availabe to enable?
Work status, Data Audit, Journal templates, Comments, "Use as Source of Data" BPC420 P.137
88
What is "Use as Source of Data"?
enables the ODBO clients to retreive data from the model, Excelsius, EPM Connector, GRC Process controls integration BPC420 P.137
89
What is "change type" for a model?
allows a change withint type (Reporting or "Drivers & Rates") BPC420 P.137
90
When changing a model type, can you change dimensions?
Yes, add or remove. BPC420 P.139
91
What does light optimization do?
closes open request, compresses without zero-elimination and indexes the cube, updates database statistics for the BW InfoCube. BPC420 P.139
92
What does Full optimization do?
Sames as light. Plus it checks to see if data model can be improved. BPC420 P.139
93
What are the full optimization checks?
dimension tables have \<20% size of Fact table, moves data to shadow cube, compress, index,…NEW technical name. BPC420 P.139
94
What is a BW consequence of full optimization?
INfoCubes will be lost. 1 Data Transfer Processes (DTPs) to/from the cube 2 Aggregates or Business Intelligence Accelerator (BIA) Indexes will be lost. New technical name. BPC420 P.140
95
Do both optimizations take the system offline?
Yes BPC420 P.140
96
Manage dimensions in BW or BPC?
Do all infocube changes in BPC. Not possible to link from BW to BPC admin. Do not manage BPC items from RSA1. BPC420 P.140
97
In which table are dimensions to an application stored?
UJA\_DIM\_APPL BPC420 P.140
98
What changes CAN be made in BW for BPC properties?
"InfoProvider Properties"(Query cache, roll up, DB performance)- will be lost if underlying technical infoProvider is changed. Full Optimization will remove the DB Performance settings. BPC420 P.141
99
Is partitioning available?
not yet because BPC is not using standard SAP time dimension. BPC420 P.142
100
What is created when an application/model is created?
InfoProvider, MultiProvider, Query, BPC420 P.142
101
Where can you find the technical name of the InfoProviders?
UJA\_APPL BPC420 P.142
102
Is a new InfoArea created for each AppSet/Environment?
Yes BPC420 P.142
103
What is the naming convention of InfoProvider?
/CPMB/I BPC420 P.143
104
What is the naming convention of MultiProvider?
/CPMB/M BPC420 P.143
105
Whatis the naming convention of Query?
/!!O BPC420 P.143
106
Why can dimensions be removed from a model in BPC and not BW?
the BW remodeling toolbox is not required, so we can do this. BPC420 P.143
107
What about the MultiProvider and full optimization?
MultiProvider will automatically point to new InfoProvider. Query & MultiProvider created. BPC420 P.143
108
What is BW part of a BPC query?
MDX statements are performed against query which is on top of the MultiProvider. BPC420 P.143
109
What is the BW equivalent of measures?
calculated key figures BPC420 P.144
110
How many key figures in an InfoProvider?
1…but it is possible to report on multiple "measures". BPC420 P.144
111
What are the three measures delivered with BPC?
Periodic, QTD, YTD BPC420 P.144
112
Does it matter if data is stored as Periodic or YTD for the three measures?
no matter whether periodic or YTD, periodic, QTD, and YTD are available for reporting. BPC420 P.144
113
What are some example custom measures?
Week to Date, Month to Date, Rolling 12 month total, … BPC420 P.144
114
Where is the measure table?
UJA\_Formula BPC420 P.144
115
What do you need to modify the measure table?
write MDX formulas. Use variables in place of technical names. Must do for BOTH PER & YTD. BPC420 P.144
116
What does MDX stand for?
Multidimensional Expressions -- typically deal with SIGN transformations and TIME calculations for each account type. BPC420 P.145
117
What do you need to do if you update UJA\_Formula?
need to manually update UJA\_FORMULA\_APP as well for each model/application. BPC420 P.145
118
What is the reason you can't use a BW InfoProvider to create Models?
The configuration of logic, business rules, Audit, Comments, work status,… BPC420 P.145
119
What is Lesson 09?
Describing the Security Model BPC420 P.153
120
LO Discuss the BPC security concept?
See Questions. BPC420 P.153
121
LO Recognize security conflicts
See Questions. BPC420 P.153
122
What is Event & Notification function?
create messages and alerts in App or emails. Can contain hyperlinks. Security addresses. BPC420 P.153
123
What is Content Lifecycle Management (CLM)?
tool that support distribution of content across systems. Security addresses. BPC420 P.155
124
What is the BW transaction for Manage Users & Roles?
SU01 & PFCG..ABAP user management mechanisms BPC420 P.155
125
What are the steps to assign security? Which step is optional?
1 - BW User & Role, 2 - Single Sign On(SSO), 3- User Setup 4 - Assign Team (optional), 5 - Task Profile 6 - Data Access Profile BPC420 P.155
126
What are the Admin Team types? 3
Primary (full admin, ?no dimension access?), Secondary (public folder & dimension access), System Admin (full admin & dimension access) BPC420 P.155
127
What kind of security reporting is available?
"Enable Auditing of Administration Activity" BPC420 P.155
128
What is an Emergency User?
when normal access is not available, log on as SysAdmin or other user with Admin rights. BPC420 P.155
129
What about SSO & EPM products?
SSO is available, must use same DNS (Domain Name System) BPC420 P.157
130
What is no longer supported for security?
Windows Active Directory & "CMS" BPC420 P.157
131
Which security object is in BW?
Task profile. Other are in BPC ABAP tables. BPC420 P.157
132
What are task rights of System Administrator?
1 - manage environments 2 - Manage Security 3-Use system when offline BPC420 P.157
133
What are task rights of Secondary Administrator?
Manage dimensions, Edit Content of Public Folder BPC420 P.157
134
What are task rights of Primary Administrator?
All Tasks (….) BPC420 P.157
135
What is the limit on Task Profiles?
none, task security is cumulative BPC420 P.160
136
What are the possible values for "Assigned to" concerning task profiles?
"All Teams" or "Some teams only" -- seems outdated. BPC420 P.167
137
What are the user types required?
"Individual", "dialog" users for admin related tasks & CLM(Content Lifecycle Management), "Internet" user used by Adobe Flex client users. "Technical" uses are not required. BPC420 P.168
138
What are Sarbanes-Oxley options?
challenge users for pw. Can store Pw on client machined (Admin can disble for enhanced SO compliance). BPC420 P.169
139
How is pw saving on client machine disabled?
in BW transaction SPRO / IMG true=enhanced BPC420 P.169
140
If a technical users is set up, what should be the type?
communciation. "technical" users not required nor recommended. BPC420 P.170
141
What roles are required in BW?
Static: /POA/BUI\_FLEX\_CLIENT, /POT/BUI\_UM\_USER (NOT environment related) Dynamic: "task" and "data access" BPC420 P.171
142
Can a "team Lead" be established in team security?
Yes BPC420 P.173
143
What is a "team lead" used for?
Research BPC420 P.180
144
What drives security conflict resolution?
Data Access: Write, Read Only, Denied. Write is least restrictive. "Less restrictive" profile wins. BPC420 P.180
145
What authority do child members have?
Child members always have access level of parent unless otherwise specified. BPC420 P.181
146
How does hierarchy factor in with a secured dimension?
Ignore H1, H2… BPC420 P.182
147
What is Lesson 10?
Define Parameters BPC420 P.189
148
LO Discuss the functional parameters and configuration parameters
See Questions. BPC420 P.189
149
LO Describe how to customize parameters
See Questions. BPC420 P.189
150
What are administration parameters?
Administration parameters are used to change or enhance the functionality and configuration of BPC scenario BPC420 P.189
151
What are the three types of administration parameters?
Functional, Configuration, & System BPC420 P.189
152
What is a functional parameter?
Set by the user in UI of Admin workspace. EX: APPROVALORG, work status options, Model options (comment) BPC420 P.190
153
What is a configuration parameter?
From BW SPRO / IMG --mainly technical parameters that are set once in IMG. EX: ALLOW\_FILE\_SIZE BPC420 P.190
154
What is a system parameter?
set by system, mainly flags, cannot be set by user through and Admin UI. EX: AVAILABLEFLAG BPC420 P.190
155
Which 3 tables contain sytem parameters?
UJA\_PARAM (cross environment) & UJA\_PARAM\_APP (Environment & Model level), UJA\_USER\_DEF (a few) BPC420 P.190
156
What are the 3 parameters within Configuration parameters?
Global, Environment, Model BPC420 P.192
157
What are 2 important Configuration - Environment parameters?
ALLOW\_FILE\_SIZE - max 100MB user file upload size, ALLOW\_EXTENSIONS - defines permitted files for upload. BPC420 P.193
158
What does the IMG activity "documentation" & "activity" button look like?
See book. BPC420 P.193
159
What is an importatant Configuration - Model parameter?
BPC\_STATISTICS (monitor system performance) BPC420 P.193
160
Which 2 tables are useful for monitoring performance?
UJ0\_STAT\_HDR & UJ0\_STAT\_DTL BPC420 P.193
161
How do you enable monitoring of system performance?
BPC\_STATISTICS (monitor system performance) BPC420 P.193
162
What is Lesson 11?
Using the EPM Add-in BPC420 P.199
163
LO Create an EPM add-in connection
See detail questions BPC420 P.200
164
LO Describe the features of the EPM add-in ribbon
See detail questions BPC420 P.200
165
LO Define default values for dimensions with the EPM Context Bar
See detail questions BPC420 P.200
166
LO Build a simple report
See detail questions BPC420 P.200
167
What are 7 features of EPM Retrieval?
CADCCPI - Create Reports, analyze data, dynamic formatting, calculations, charts, print and share, Integration. BPC420 P.200
168
What are 4 features of BPC only?
1 Data Input 2 Planning functions 3 Distribution & Collection 4 Data Manager BPC420 P.200
169
What are 5 connection types?
SSAS (SQL Server Analysis Services), BW , ODBO (Old DB OLAP), XMLA (xml for analysis), WS (Web Services) BPC420 P.201
170
What are the command display options?
Reports, Data Analysis, Data Input, Tools, Data Manager BPC420 P.209
171
What are the options under Reports Group?
open, save, edit report, new report, report actions, view formats, refresh. BPC420 P.212
172
What are the options under Data Analysis Group?
Expand, collapse, Keep, exclude. BPC420 P.212
173
What are the options under Data Group?
save data (save, refresh, validate, change work status), comments, planning, journals. BPC420 P.212
174
What are the Collaboration options?
Book Publication(publish pre calculated workbooks to the web), Distribution (and collection), Portal Publication(publish to a BI launchpad). BPC420 P.212
175
What are options under Tools group?
drill through, quick links, offline mode, insert function, options, More (freeze data refresh, acessmemeber properties…) BPC420 P.212
176
What are 2 ways to adjust the EPM Context & Pane?
Drag and drop, dropdown arrow. BPC420 P.212
177
Where are default context members set?
Context Options BPC420 P.NA
178
What is Lesson 12?
Data Manager BPC420 P.248
179
Explain the Data Manager Package tool and the issues related to it
See detail questions BPC420 P.248
180
What is required for Data Manager Connection?
only possible via a Webservice connection, not "Local" connection, not ODBO. See image p 248 BPC420 P.249
181
Does default logic automatically run when you import data?
most of the time BPC420 P.249
182
What is Data Manager
import, copy or move data within and across models, export. Supports mapping and complex transformations. BPC420 P.249
183
What is in the Data Manager group?
Run package or package links, view package, package links and schedule status, upload, download, preview, organize package or links, create & manage transformation files, create & manage conversion files, "More" button (clear prompt values or change the dedicated connection). BPC420 P.250
184
Run Admin Packages
can view and run packages set to type "admin" BPC420 P.251
185
Edit Packages
edit, create, delete, change package type. Add transformation and conversion files BUT not edit them. BOTH admin and user type packages. BPC420 P.251
186
Edit Transformation files
edit, create, delete, BPC420 P.251
187
Edit Conversion files
edit, create, delete, BPC420 P.251
188
Cancel any user packages
NW only. Cancel other user packages. BPC420 P.251
189
Edit package schedules for any users
view or change schedules for any package. Detailed logs may contain sensitive data, thus this type of task is required. BPC420 P.251
190
Run Packages
run packages that have security folder rights for BPC420 P.251
191
Edit Package Links
edit, create, delete, BPC420 P.251
192
Upload Data
upload a data file BPC420 P.251
193
Download Data
ability to download and preview. BPC420 P.251
194
What are the three types of packages within Data Manager?
Data Management, Financial Processes, System Administration note: packages are shared across all environments and models. BPC420 P.252
195
What is special about NW data packages?
They are technically Process Chains. BPC420 P.252
196
What is a process chain?
defined beginning and end, sequence of processes, BPC420 P.252
197
What are dynamic packages?
designed to work without modification BPC420 P.252
198
Where can you modify packages to behave differently or to perform additional functions?
"Organize Package Lis" BPC420 P.253
199
Where can process chain templates be displayed and edited?
ABAP transaction RSPC BPC420 P.254
200
How are delivered process chains activated?
note: delivered process chains must be activated. version changes from "delivered" to "active". BPC420 P.254
201
What is the delivered package to start a data load from ERP to BW?
"BPC trigger BW Process Chain" -- and then from BW to BPC, package link BPC420 P.255
202
What are the custom process types?
IF\_RSPC\_EXECUTE, IF\_RSPC\_GET\_VARIANT,IF\_RSPC\_MAINTAIN, IF\_RSPC\_TRANSPORT BPC420 P.255
203
Which process type can be omitted in a custom, but not delivered ?
transport BPC420 P.255
204
What is needed for the custom process type?
static method SET\_PC\_TYPE to set the name, a logical code, class must inherit from cl\_ujd\_actor or its derived class, does not need to overload base class methods, interface IF\_UJD\_TASK. BPC420 P.255
205
How can you retract both master & transaction data?
BADI BPC420 P.256
206
How do you initiate delta initialization?
Organize Delta Initialization on "Data Manager" tab. "trigger a full load at first run" is a flag option. BPC420 P.256
207
From which BW objects is data loaded?
DSO (Data Store Objects) full or delta load. BPC420 P.256
208
Which objects support full or delta load?
both Delta & full(standard cube, standard DSO, write-optimized DSO). Full Only(virtual & MultiProvider. BPC420 P.256
209
How can data packages impact performance?
data in temporary tables. "dump" BPC420 P.257
210
What is Data Manager Maintenance Program?
SE38 & UJD\_BACKEND\_DATA\_MAINTENANCE, retrieves and displays all obsolete data entries that can be deleted to improve performance. ! BPC420 P.257
211
What are 4 tasks with packages?
run or shedule, Organize packages into a list, view package status, view schedule status. BPC420 P.257
212
What are 3 things to keep in mind about data manager packages?
links are model specific, execute in sequence and stops at first failure, only run packages that user has permissions BPC420 P.260
213
What is Lesson 13?
Data Loads BPC420 P.262
214
Explain the configuration of flat file uploads
See detail questions BPC420 P.262
215
Describe the set up of Uploads from BW
See detail questions BPC420 P.262
216
Install Master Data Upload, hierarchy upload, transaction data upload
See detail questions BPC420 P.262
217
What is a tranformation file?
1 worksheet, named instructions, sets up rules for reading data from external source BPC420 P.262
218
What are three parts of a transformation file?
Options (definitions for various options), Mapping (defines how data is mapped to BPC database), Conversion (which conversion sheet to use with dimensions) BPC420 P.267
219
What is a conversion file?
maps member names from external(left) to internal dimension(right) structures, multiple sheets so multiple transformations can access the same workbook, you can have one conversion file per dimension. BPC420 P.267
220
How are BADIs related to transformation files?
start\_routine, end\_routine jump to ABAP, routines are defined in BW within BADI implementation. BPC420 P.267
221
What is the transaction code for Badi?
UJD\_routine BPC420 P.267
222
Where does the BADI filter go in the transformaiton file?
Options section BPC420 P.267
223
What is \*COL(A)?
defines a dimension for a field in the data file when there's no header row. BPC420 P.268
224
What is \*COL(A, B:C)?
defines a dimension for a subset of a field of a data file BPC420 P.268
225
What is \*NEWCOL(A)?
function creates a new field with the given value BPC420 P.268
226
Dimension=\*MVAL(keyfigure-type1|dim\_mem1||keyfiguretype2|dim\_mem2||keyfiguretype3|dim\_mem3)
can be used to do a data transfer from a key figure model to an account model BPC420 P.268
227
\*Str(string)
function adds text string to the members of a column BPC420 P.268
228
\*If (Condition1 then Action1;Condition2 thenAction2;Default Action)
Condition1 - If this evaluates to "True," map using Action1 Condition2 - If Condition1 is "False" and Condition2 is "True," map using Action2 Default Action
– If both Condition1 and Condition2 are "False", map using this Default Action Condition1 and Condition 2 can contain multiple items that are added together (using the plus (+) sign) BPC420 P.269
229
What is the conversion syntax?
Dimension Name = [COMPANY]WorkbookName[!SheetName] -note: items in brackets are optional. BPC420 P.269
230
What are best practices for conversion files?
one file per dimension, same name as dimension, BPC420 P.270
231
How do you ignore external data?
\*skip in the internal column BPC420 P.270
232
How do you set javascript to run on internal or external column?
convert\_internal= No (js in internal), Yes (js in external) BPC420 P.270
233
What do you preced Java script with?
js: BPC420 P.270
234
Can you use javascript with If statements?
yes BPC420 P.271
235
js:%external%.substring(0,2)
return a Long containing the number of characters in a string BPC420 P.271
236
js:%external%.length
return the length of the string contained in external BPC420 P.271
237
js:%external%.replaces("apples","oranges")
return a string where a substring has been replaced… BPC420 P.271
238
How do you revalue during upload? Revaluation
use the formula column that is executed during upload. BPC420 P.271
239
What is CONVERTAMOUNTVVDIM?
points to the formula column for dimension BPC420 P.272
240
What are three data upload packages?
Append, Import, Import Append (contains 2 overwriting possibilities) BPC420 P.274
241
For data package how is the target determined?
uses current connection BPC420 P.274
242
when do you use \*MVAL?
?combine multiple key figures into account dimension? when key account model and target model is always an account model
ZKEYFIGURE=\*MVAL(0BALANCE|\*NEWCOL(ZBALANCE)||0QUANTITY|\*NEWCOL(ZQUANTITY))
Dimension=\*MVAL(keyfigure1|member1||keyfigure2|member2||keyfig3|member3||...). BPC420 P.275
243
what is the process chain for importing master data?
/CPMB/IMPORT\_IOBJ\_MASTER BPC420 P.278
244
What are the two operators for "set selection"?
= , BT (between) BPC420 P.278
245
What is option with "Import Text Node"?
Y, and level. So node and two levels down is level=2. BPC420 P.278
246
What is level=0? Data package
only the specified member ID will be returned as a tree which only has one node. BPC420 P.279
247
What if level is blank/unspecified? Data package.
whole sub-tree is selected by taking the member ID as root. BPC420 P.279
248
Write Mode: Overwrite
master data that has no data will be deleted, rest is overwritten BPC420 P.279
249
Update Mode:
master data will be overwritten if the id is the same, new master data will be added. BPC420 P.279
250
What if Internal format is selected for data package?
no conversion routine is used during the import process. BPC420 P.279
251
What is External format is set?
related ABAP conversion routine will be used, if one is maintained on the source InfoOjbect from BW transaction RSD1. BPC420 P.280
252
What is Javascript replace method?
js: %external%.replace("-","\_") BPC420 P.280
253
What is JavaScript split and join?
js:%external%.split(' ').join('') -- remove spaces from master data BPC420 P.280
254
What is process chain for importing hierarchy?
/CPMB/IMPORT\_IOBJ\_HIER. BPC420 P.281
255
Can you import partial hierarchy?
Yes, use levels BPC420 P.281
256
What is source and target for hierarchy?
UJN\_S\_HIER\_NODE is used as both the source structure and target structure in transformation file mapping. BPC420 P.282
257
Is ParentH\* format required?
Yes BPC420 P.283
258
When preparing hierarchy what must be done?
replace - with \_, remove blanks, parenth\* BPC420 P.283
259
What is another option for space replace for hierarchy upload?
js:%external%.toString().replace(/\s+/g,“”) BPC420 P.283
260
In which section of a transformation file do you write code for removing blanks?
\*Mapping BPC420 P.290
261
What is a text node?
only exists in a hierarchy BPC420 P.300
262
Lesson 14: Creating Basic Logic Scripts & Online Execution
Lesson 14: Creating Basic Logic Scripts & Online Execution BPC420 P.365
263
What is online execution of logic?
running in default logic instead of Data Manager packages. Users execute by themselves. BPC420 P.367
264
Describe the concept of logic scripts
Describe the concept of logic scripts BPC420 P.367
265
Identify Logic Script Commands
Identify Logic Script Commands BPC420 P.367
266
Recognize the Golden Rule for Logic Scripts
Recognize the Golden Rule for Logic Scripts BPC420 P.367
267
What are 4 primary types of Logic? 2 additional?
Worksheet, Member Formulas (use sparingly), Scipts, Business Rules -- Dimension formulas, Microsoft MDX(multidimensional expressions) language BPC420 P.369
268
What is worksheet based logic?
exists in worksheets only BPC420 P.369
269
What are member formulas?
powerful formulas mostly for account dimension members. BPC420 P.369
270
What are dimension formulas?
defined at environment level, valid across all models BPC420 P.369
271
What is a logic script?
calculate, but only at base level members BPC420 P.369
272
What is a business rule?
table based logic - only for management & legal consolidations. Don't have to understand scripting. BPC420 P.369
273
Which business rules are delivered with BPC?
Account transformation, currency conversion, intercompany booking, carry-forward rules, US elminations, validations, automatic adjustments BPC420 P.369
274
What are a few things to know about logic?
1- MDX fairly intuitive, easy to deliver, but poor performance and don't scale well, 2-link to ABAP from logic script editor 3 - script statements are case sensitive 4 - use SQL or MDX. BPC420 P.370
275
What are 4 benefits of script logic?
real-time calculations, data manager - option to run in batch from data manager, flexible (enables you to share formulas across models where dimension is used), powerful (tool for calculations). BPC420 P.371
276
How do you navigate to Logic?
Rules / Logic Scripts BPC420 P.371
277
What are 2 types of Logic?
default, other BPC420 P.371
278
what is default logic?
automatically executed on every write back to the model. BPC420 P.371
279
What are two files for each logic script?
.LGF(ASCII file), .LGX (compiled, not stored in BPC) BPC420 P.371
280
What are three components of Script Logic?
Scoping (data manager, input schedule, scope control- what's the data?), Body/Code (what do with data? - \*if statements, \*REC, [#] based MDX statements, \*WHEN/\*IS/\*ENDWHEN, Allocation Logic), Write (\*Commit, write the record to Fact table). BPC420 P.371
281
What is Calcaccount.lgf?
prepare cash flow; run Account Calculation Business Rule BPC420 P.372
282
What is Consolidation.lg?
run legal consolidation business rule BPC420 P.372
283
What is Copy\_Opening.lgg?
run a balance carry forward business rule BPC420 P.372
284
What is FX\_Trans.lgf?
run currency conversion? BPC420 P.372
285
What is ICBooking.lgf?
run intercompany reconciliation and difference posting BPC420 P.372
286
What is ICData.lgf?
run intercompany reconciliation BPC420 P.372
287
What is ICElim.lgf?
run intercompany reconciliation BPC420 P.372
288
What is MDXlib.lgf?
library of MDX financial functions BPC420 P.372
289
What is System\_Constants.lgf?
stores constant values for use in scripts BPC420 P.372
290
What is System\_Library.lgf?
basic examples of keywords BPC420 P.372
291
What is Validation.lgf?
run a validation rule BPC420 P.372
292
What is scope with logic on save?
scope of query is non-calculated accounts, only specific members sent to BPC420 P.373
293
What is scope with logic invoked via Data Manager package?
1 Prompted Dimensions: only selected members 2 Nonspecified dimensions = all members 3 Currency LC if not specified. BPC420 P.373
294
What is a program for debugging script logic?
UJK\_SCRIPT\_LOGIC\_TESTER - transaction code SE38 (ABAP Editor) BPC420 P.373
295
What are steps for using logic tester?
1 - input environment, model, dimensions, 2 - specify script or paste into lowe left editor bax BPC420 P.374
296
What are 3 run options on logic tester?
validate, execute, execute (simlulate) BPC420 P.376
297
What is \*WHEN?
trigges use of SQL syntax, used to narrow scope further BPC420 P.376
298
Wha tis \*WHEN \* \*IS \*?
entire section BPC420 P.376
299
\*WHEN ACCOUNT \*IS "SalesUnits"
Sales Units account BPC420 P.376
300
how do you differentiate numeric from text in logic?
use quotes for text Ex: \*IS "AVG" vs \*IS 10 BPC420 P.376
301
What if \*IS is used without an operator?
= equal is assumed BPC420 P.376
302
What is limitation with \<\>?
can only follow with one number. \*IS \<\> 2,3,4 is invalid. BPC420 P.376
303
What operators are not supported?
AND, OR, NOT, \*IS dimension.property BPC420 P.376
304
how many levels allowed for WHEN/ENDWHEN?
as many as desired BPC420 P.376
305
What is \*REC in logic?
generate a new record BPC420 P.377
306
What are the paramters of REC() ?
specify what to modify in the original record, generate as many records as want BPC420 P.377
307
What is FACTOR?
multiplies source by facor BPC420 P.377
308
What is EXPRESSION?
apply an arithmetic operator ( + - / \*) BPC420 P.377
309
What does second part of record statement do?
tells the value where to post BPC420 P.377
310
What is code to \*1.25 and post to XYZ?
\*REC(FACTOR=1.25, ACCOUNT="XYZ") OR \*REC(EXPRESSION=%VALUE%\*1.25, ACCOUNT="XYZ") BPC420 P.377
311
What is a limitation of REC?
1 - can't use MDX keywords. 2 - CAN only use + - / \* or () parentheses for tuple & priorities of the operations 3 - Can't use SIGNEDDATA or any measure in a WHEN statement to write a condition on a measure value 4 - WHEN / IS/ REC / ENDWHEN cannot be used in SELECTCASE / ENDSELECT BPC420 P.377
312
What ideal case for \*COMMIT?
use one and use sparingly as there is a performance impact. BPC420 P.379
313
What is \*XDIM\_MEMBERSET?
1- tells the logic which dimension members to run on, can be hard coded, 2-can be variable (%IC\_MBRS%), 3 CANNOTot be combined with Properties. BPC420 P.379
314
What is the syntax for \*XDIM\_MEMBERSET?
\*XDIM\_MEMBERSET {dimension name} = {member set} Ex: \*XDIM\_MEMBERSET INTCO = Non\_Interco BPC420 P.379
315
If you want to use calculated members what do you have to do before another formula can use?
\*COMMIT to database BPC420 P.379
316
How & why is \*XDIM\_ADDMEMBERSET used?
1 - only \<\> or = allowed. 2 - cannot do = bas(member), member. Must use add memberset. Can do each independently. See p 380. 3 - can do - member, member, member 4 - can do bas(member) BPC420 P.380
317
What is \*XDIM\_MAXMEMBERS? Example?
chunks the run, ex: \*XDIM\_MAXMEMBERS P\_ACCT=5, goes to end of file while pulling 5 at a time. - better to process in chunks to prevent dumps. BPC420 P.381
318
DIM {dimension} = {member}; WHERE = BAS({member});
ex: DIM TIME WHAT = 2009.JAN; WHERE = BAS (2009.TOTAL) -- assumes the whole year forecast is initially loaded in 2009.Jan allocates the data equally to each period. NOTE: would be used with DIM CATEEGOR WHAT = FCST\_LOAD; WHERE = FORECAST; as part of an allocation. BPC420 P.381
319
\*FOR / \*NEXT
loops BPC420 P.381
320
\*XDIM\_FILTER
1 - filters the existing scope. \*XDIM\_FILTER {dimension name} = {members set}. Can use properties(1 or more). Ex: \*XDIM\_FILTER ENTITY = [entity].properties("EUROPE"="Y") 2 - removes duplicates 3 - only returns base members BPC420 P.382
321
\*SELECT
1 - runs against sql tables and creates a list of members. Ex: \*SELECT(%IC\_MBRS%, "ID", "INTCO", "[GROUP]="NoInp"") 2 - limited to = or \<\> . No AND or OR. BPC420 P.383
322
\*SELECTCASE & IIF
- have the same impact on performance, selectcase is shorter. 2- can be used with properties. Ex: SELECTCASE [P\_ACCT].CURRENTMEMBER.PROPERTIES("SELECTION") 3 - cannot be nested. BPC420 P.383
323
What is the MDX IIF equivalent of \*SELECTCASE [ACCOUNT].CURRENTMEMBER.PROPERTIES("CALC") ?
=IIF([ACCOUNT].CURRENTMEMBER. PROPERTIES(“CALC”)=Y,1,IIF([ACCOUNT]. CURRENTMEMBER.PROPERTIES(“ CALC”)=N,1,null)) BPC420 P.384
324
Which is a much better performer? \*SELECTCASE or WHEN/ENDWHEN?
WHEN/ENDWHEN BPC420 P.384
325
\*ADD
1 - allows you to automatically cumulate a set of members. Ex: \*ADD %ACC%=[KPI1],[KPI2],.. [KPI5]= %ACC% 2 - Better performance than MDX formula. 3- can only carry one MDX formula BPC420 P.385
326
TMVL Parameter
TMVL(offset, base\_period) 2 - only integers 3 - neg or pos 4 - $CURPER$ data manager prompt is possible 5 - nested TMVL not supported. ( TMVL(-1, TMVL(-3,2009.JAN))). BPC420 P.385
327
Where can TMVL be used?
1 - FACTOR/EXPRESSION within REC 2 - inside FOR/NEXT loop 3 - In IS conditions inside WHEN/ENDWHEN 4 - \*XDIM\_MEMBERSET as well. BPC420 P.385
328
What is an implied keyword?
available for each dimension %DIMNAME\_SET%, %INTCO\_SET% or %TIME\_SET%. 2 - reads Context BPC420 P.386
329
What is keyword SET?
refers to the context for the value BPC420 P.386
330
What is keyword DIM?
syntax: %{DimType}\_DIM% BPC420 P.386
331
What are valid types of DIM
1-Returns the technical name of all delivered dimensions. ACCOUNT, CATEGORY, TIME, ENTITY, INTCO, CURRENCY, AUDITRAIL. Will not return for UserDefined dimensions. BPC420 P.386
332
How can a value outside scope be grabbed? (3)
Expand the scope, use \*LOOKUP/\*ENDLOOKUP, use \*DESTINATION\_APP BPC420 P.387
333
\*LOOKUP/\*ENDLOOKUP
1- used with FACTOR, EXPRESSION, or WHEN 2 - across models 3 - only one \*LOOKUP per \*COMMIT block. 4 - only one measure 5 -multiple lookup blocks not supported. 6- FOR/NEXT can be used inside lookup to read multiple values BPC420 P.387
334
\*FOR/NEXT & LOOKUP
1- FOR/NEXT can be used inside lookup to read multiple values 2 - Run time values & properties can be passed as read only. Ex: \*DIM RATE:INPUTCURRENCY=ENTITY.CURRENCY BPC420 P.387
335
\*DESTINATION\_APP
1 - write the results of calculations to a different model/application. 2- therefore, can add, remove, or rename (\*RENAME\_DIME P\_ACCT=P\_ACCTDETAIL) dimensions to conform with destination model. BPC420 P.387
336
\*SKIP\_DIM with DESTINATION\_APP
skip dimensions in destination BPC420 P.388
337
\*ADD\_DIM with DESTINATION\_APP
is used to indicate which member to use for the dimensions that do not exist in the source application. BPC420 P.388
338
How to avoid re-writing logic?
Update the Constants file at Enviroment level BPC420 P.389
339
What are 2 scenarios for configuring Constants for logic?
1 -Environment level 2 - Configuration of Constants at Model level. BPC420 P.391
340
Stay away from MDX logic
though it is intuitive and let's you access calculated/parent members, it is always slower than SQL. Only use in dimension member formulas (and not even recommended there). BPC420 P.391
341
How can you code A = B+C?
\*XDIM\_MEMBERSET ACCOUNT = B,C \*WHEN \* \*IS\* \*REC(ACCOUNT=A) \*ENDWHEN BPC420 P.391
342
How many records load in memory?
as few as possible BPC420 P.391
343
Logic rule regarding structure?
keep as compact as possible. BPC420 P.391
344
What 3 actions does \*COMMIT trigger?
read records, generate records, send records to db -- use as few COMMIT stmts as possible. BPC420 P.392
345
which is better reducing data pulled in memor or reducing COMMITs?
reducing COMMITs BPC420 P.392
346
what is better way to execute logic? Default or Data Packages
Data Packages much better compared to "online execution" / default logic. BPC420 P.393
347
Avoid Save & Refresh when creating input forms
Better to have parents and values calculated on-screen that to require a refresh to see the updated value.! BPC420 P.393
348
What is UJFS transaction code?
file service for locating logic files in BW BPC420 P.393
349
Which has better performance, \*WHEN/\*ENDWHEN or \*SELECTCASE or IIF?
\*WHEN/\*ENDWHEN BPC420 P.393
350
What are the golden rules for logic scripts?
1- avoid MDX, 2 - Load minimal data in memory 3 - Keep logic compact 4 - Minimize COMMITs 5 - Only add to default logic calculations needed in real-time 6 - Avoid Save & Refresh data (input forms and calculated members) 7 - BPC420 P.390
351
Lesson 15: Create Logic Script & Execute
Lesson 15: Create Logic Script & Execute BPC420 P.450
352
LO Describe the central execution of logic scripts
central execution is to run from data packages with prompts. Online is default logic. BPC420 P.450
353
LO Define How to adapt Packages for Central Execution
copy and modify BPC420 P.450
354
LO Explain how to execute a logic script from a button
Sub Button()
Application.Run APIName, MethodName, LinkName, Arg1, Arg2, Arg3
End Sub
with:
• APIName = EPMExecuteAPI
• MethodName = DataManagerRunPackage
• LinkName (Not used but Necessary) = “”
• Arg1 = Package Name
• Arg2 = Package Group
• Arg3 = Team ID (= “” means Company) BPC420 P.450
355
LO Illustrate how to create a prompt for variable values
ex: PROMPT(TEXT, %VAR\_KPIT%, "INPUT VARIABLE VALUE FOR KPI1 AS ABSOLUTE VALUTE",) BPC420 P.450
356
What is %USER%? %APPSET%? %APP?
returns current user, appset, app BPC420 P.451
357
What is syntax for a button? !know cold
Sub Button()
Application.Run APIName, MethodName, LinkName, Arg1, Arg2, Arg3
End Sub
with:
• APIName = EPMExecuteAPI
• MethodName = DataManagerRunPackage
• LinkName (Not used but Necessary) = “”
• Arg1 = Package Name
• Arg2 = Package Group
• Arg3 = Team ID (= “” means Company) BPC420 P.453
358
What are pre-requisites to creating butons?
add developer tab , enable macro settings BPC420 P.453
359
What do you put in front/behind variable for prompting?
$ signs before and after ex: $VAR\_KPI1$ BPC420 P.454
360
What is syntax for package prompting? Know cold.
ex: PROMPT(TEXT, %VAR\_KPIT%, "INPUT VARIABLE VALUE FOR KPI1 AS ABSOLUTE VALUTE",) BPC420 P.455
361
Lesson: 16 Define Logic Scripts for Allocation
Lesson: 16 Define Logic Scripts for Allocation BPC420 P.483
362
Discuss the concept of allocation in BPC
See detail questions BPC420 P.483
363
Define the logic elements for allocation
See detail questions BPC420 P.483
364
Execute an allocation
See detail questions BPC420 P.483
365
Allocation
1 sender to multiple receives 2 frequent top down use 3 complex allocations with very limited instructions BPC420 P.484
366
Where is definition of allocation engine?
standard logic scripts BPC420 P.484
367
What are the special commands for allocation?
WHAT, WHERE, FACTOR, USING, TOTAL, COUNT -- what, where are only 2 required. Others are optional. BPC420 P.484
368
How do you read the allocation script?
vertically, each vertical line represents the data selection BPC420 P.484
369
How is time managed in allocation?
run separately for each month(base level). Time is referenced when executing. EXCEPT \*DIM TIME row BPC420 P.484
370
When do you use \*DIM TIME row in allocation?
allocate one year's data to refre to prior year data BPC420 P.484
371
What is WHAT in allocation?
source(base members) BPC420 P.485
372
What is WHERE in allocation?
target BPC420 P.485
373
What is USING in allocation?
allocation factor BPC420 P.485
374
What is TOTAL in allocation?
sum, very useful when calculating a percentag USING/total BPC420 P.485
375
What is FACTOR?
1- 2 is times 2- Using (what is multiplied by using) 3- USING/TOTAL 4- 1/COUNT (divided evenly amount dimension members referred to BPC420 P.485
376
\>\>\>\>
keyword to reference defintions used to the right BPC420 P.485
377
\<\<\<\<
keyword to reference defintions used to the left BPC420 P.485
378
What are the WHAT options?
Member (DIM Region WHAT=US), [property]="property value" (\*DIM Product\_Group=[Fruit]="apples", BAS, same as "WHERE", \<\> member (note: base level). BPC420 P.485
379
What is not allowed in WHAT?
blank or [ALL], must be base member to use \<\>. BPC420 P.485
380
What are possible WHERE options?
Member (DIM Region WHERE=US), [property]="property value" (\*DIM Product\_Group=[Fruit]="apples", BAS, same as "WHERE", Blank or [ALL] (NOTE: blank or all is same result). BPC420 P.486
381
What is different between WHERE & WHAT?
WHERE can use blank or all. Can also use \*APP (ability to write to a different application). BPC420 P.486
382
Examples of USING / FACTOR options
-1\*USING/100 USING/TOTAL 1+USING USING-1 … BPC420 P.487
383
What if FACTOR is omitted? Allocation
defaults to 1 BPC420 P.487
384
What if the arithmetic expression is omitted? Allocation
default is multiplication BPC420 P.487
385
Other allocation considerations?
Do not use "\>0", USING and TOTAL must have same definition, do not use parents in USING, BAS(Parent) is allowed, don't use parents with \<\>. BPC420 P.488
386
What are some allocation uses?
top down, or aggregate children to a new category. Ex p 490 Asia. BPC420 P.490
387
What is \*DIM DOT(R)?
identify dimension type BPC420 P.491
388
Lesson 17: Logic Scripts & ABAP
Lesson 17: Logic Scripts & ABAP BPC420 P.509
389
Discuss Function modules in BPC
assign a function module BPC420 P.509
390
Describe the integration between ABAP & BPC
use ABAP to code business logic and then make a reference from the Logic Script Editor to BAdI filter. Decide online or central execution. BPC420 P.509
391
BAdI & ABAP
use ABAP to code business logic and then make a reference from the Logic Script Editor to BAdI filter. Decide online or central execution. BPC420 P.509
392
What is BAdI based on?
ABAP (Advanced business Application Programming) BPC420 P.509
393
Are BAdI's effective?
BADI's are a very effective way to handle very specific use cases that are not covered by the standard product effectively. BPC420 P.509
394
START\_BADI/END\_BADI
also calles ABAP programming written using UG\_CUSTOM\_LOGIC BADI (transaction code SE19) BPC420 P.510
395
What is syntax for BADI?
\*START\_BADI = =…\*END\_BADI ….filter value of your BADI implementation is the name providedin UJ\_CUSTOM\_LOGIC\_BADI BPC420 P.510
396
What are the optional Parameters of BADI?
Query & Write. Query (performs default query, ON or OFF; set to off if you want to perform your own query. Write(Default is ON for writing to db.) BPC420 P.510
397
In which section of a transformation file does a BADI go?
Options BPC420 P.518
398
What 2 pieces of information are important for ABAP-LOGIC SCRIPT integration?
1 technical name (of the filter value of the BADI) 2 business logic (implmented with ABAP coding) BPC420 P.518
399
If you create your own BADI what do you enter as the Enhancement Spot?
UJD\_ROUTINE BPC420 P.518
400
What is ZDAVY in ABAP?
message class, error message text BPC420 P.518
401
Lesson 18: Introducing Member Formulas
Lesson 18: Introducing Member Formulas BPC420 P.532
402
Identify the possibility of on the fly calculation
use excel or member formulas(with caution) BPC420 P.532
403
Create Member Formulas
See detail questions BPC420 P.532
404
What is MDX formula syntax?
1 upper or lower case 2 enclose all ids in brackets [] 3 fully qualify member ids, except for account dimension. [DIMENSIONNAME].[PARENTH1].[MEMBERNAME] BPC420 P.532
405
When are dimension member formulas calculated?
at run time, refresh or save BPC420 P.532
406
What is a member formula prerequisite?
enable on the dimension BPC420 P.535
407
What operatorts are supported by member formulas?
addition (+), subtraction (-), multiplication (\*) and division (/), as are the MDX keywords BPC420 P.535
408
What is caution with member formulas?
using a high number of dimension member formulas, and/or using dimension member formulas in models with very large data volumes, can cause significant performance degradation. BPC420 P.535
409
What is solve order for member formula?
\>3 is recommendation. determines the order in which dimensions, members, calculated members, custom rollups, and calculated cells are evaluated, and the order in which they are calculated. The lower the parameter value to higher the priority. Hint: The SOLVE\_ORDER parameter should be larger than 3, because BO PC uses SOLVE\_ORDER 3 for the BO PC measure formula: PERIODIC, YTD, QTD. So if you do not set the SOLVE\_ORDER parameter greater than 3, unexpected value may be returned. BPC420 P.535
410
What is formula collision?
two formulas collide. Solve order determines whicn one dominates BPC420 P.535
411
What are pros & cons of member formulas?
Pro: speed, consistency Con: lack flexibility, shared by all models, retrieval performance BPC420 P.535
412
how are solver order numbers derived like 5 or 100 in member formulas?
user sets them. Start with \>3 as 3 is for measures. http://scn.sap.com/thread/1477159 BPC420 P.535
413
Lesson 19: Create a Planning Business Process Flows
Lesson 19: Create a Planning Business Process Flows BPC420 P.555
414
Create a BPF
See detail questions BPC420 P.555
415
Run a BPF
See detail questions BPC420 P.555
416
What are the benefits of BPF?
– Helps with coordination
– Web based User Interface / Launchpad
– Status and tracking
– Guided navigation
– E-mail notifications
– Steps can be reopened
– Steps can be reviewed by higher authorities
– Built in Monitor
– Delivered detailed reports
– Work Status integration
– Real time simulations in build mode
– Users can save workspaces during execution BPC420 P.555
417
What are costs of BPF?
- Has to be designed and configured – Has to be maintained – Has to be supported by the help desk – Users cannot be forced to use the Business Process Flow user interface BPC420 P.557
418
BPF Process Template
- A sequential grouping of activities to complete a process BPC420 P.557
419
BPF Activities
- The activities for which the logged-on user can perform BPC420 P.557
420
BPF Activity Regions
- The members that an activity is executed by BPC420 P.557
421
BPF Process Instance
- An iteration of a business process flow template that is in active use BPC420 P.557
422
BPF Process monitor
- Users who can monitor the instances of a template BPC420 P.557
423
BPF Performer
- A User(s) or Team assigned to a Dimension. Performers can complete or submit (for approval) activities for example. BPC420 P.557
424
BPF Reviewer
- A User(s) or Team assigned to a Dimension. Reviewers approve or reject submitted activities. BPC420 P.557
425
BPF Workspace
- A tab in the Web Interface with links to activities BPC420 P.557
426
BPF Hyperlink
- A link in a workspace which defines the action that occurs when chosen BPC420 P.557
427
What is the context for each BPF workspace?
Each BPF workspace has it's own context BPC420 P.558
428
how many users can access a BPF activity?
multiple BPC420 P.560
429
What is BPF Opening Criteria?
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 template. BPC420 P.560
430
What are BPF "Process Settings"?
contain the general properties of the template. BPC420 P.562
431
What does the square next to the Activity do?
copy activity or move up and down. BPC420 P.563
432
What is a BPF driving dimension?
This dimension is used to determine the granularity of the activity and to determine the Performers. For example, if you want to run an activity once per region, use the Entity dimension because it has a hierarchy by region. BPC420 P.564
433
What is BPF member?
Select the members of the Driving Dimension. For example, choose the US parent so that it is children (regions) will determine the granularity of the activity. BPC420 P.564
434
What is require reviewer in BPF?
reviewer must approve or reject BPC420 P.564
435
What is a BPF reviewer?
Select the property that defines the Reviewer for each member of the Driving Dimension. You can select the Reviewer property or any other property for this. BPC420 P.565
436
What are 3 ways to add contents to the Activity Workspace?
Add: hyperlink, Content, New Report. BPC420 P.565
437
What are BPF related actions?
guided navigation via hyperlinks. BPC420 P.566
438
What are 3 version types in BPF?
Draft, deployed, Inactive. Inactive versions can't be used. BPC420 P.566
439
What is DRAFT in BPF?
draft is default for new template, can be edited or deleted. BPC420 P.566
440
What is Deployed in BPF?
draft templates can be "deployed". An "Instance" can be created for it. BPC420 P.566
441
What are version limits in BPF?
for a given template, only 1 draft, 1 deployed, multiple inactive. BPC420 P.566
442
What is a BPF instance?
Instance of a template that will be used and archived. BPC420 P.567
443
What are the steps in the BPF "instance " wizard?
Process, Owner, Context, Assignments, Start (select the process, select the owner, select the context, check assignments, Review & Start) note: takes a snapshot. BPC420 P.568
444
What activities are available in an "instance" BPF?
start, suspend/resume, change assignment, reset, archive, finalize. BPC420 P.569
445
What is "change assignment" in an "instance" BPF?
Process Owner and Activity Owners can be changed by selecting the Change Assignment option BPC420 P.569
446
What is "reset" in an "instance" BPF?
To reset an instance back to the first activity BPC420 P.569
447
Who can "finalize" an "instance" BPF?
You can finalize a process instance if you are the process instance Owner BPC420 P.569
448
How can you report on an archived instance?
if Audit of BPF activity is turned on BPC420 P.569
449
What is an S-type template? C-type?
S-type (system) templates, which cannot be modified. A copy of each system template can be created and customized according to the business needs. These are C-type (customized) templates. BPC420 P.569
450
Owners & reviewers & email notification BPF
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-mail notification when the activity is ready for review. BPC420 P.569
451
Which program is used to generate email notificaitons in BPF?
UJB\_MAINTAIN\_EMAIL\_TMPL. The table where the templates are stored is: UJB\_EMAIL10 - BPC: Business Process Flow Email Template Table. New e-mail templates can be created via the SMARTFORM transaction code. BPC420 P.569
452
What does a BPF email notification include?
• The Process • The Context • The action, such as: The following activity has been reopened. • The activity and the owner • A link to the activity BPC420 P.569
453
What is BPF integration with work status, task profile, data access profile?
permissions need to be set to allow access. Integrated with BPF. BPC420 P.569
454
What are the work state options?
• All - All users are allowed to perform the activity • Locked - Users are Locked out of that activity • Owner - Only the Owner can perform the activity • Manager - Only the Manager can perform the activity BPC420 P.569
455
What does status controlled by determine?
determines who can change the work state. In the example below, the Manager can advance the work state to Approved and back to Reviewed. BPC420 P.569
456
What are the Work status interface methods?
methods that users can save data or documents
to the data base. They are defined as follows:
• Data Manager - running data manager packages
• Journals - posting journal entries
• Manual - manually entering and saving data
• Documents - posting document attachments
• Comments - saving comments to the data base BPC420 P.569
457
For BPF Administration, what are two processes?
process template, process instances BPC420 P.569
458
Lesson 20: Validating Master Data
Lesson 20: Validating Master Data BPC420 P.609
459
Estimate the Validation Concept
driver dimension rules are another way to validate data loads in addition to transformation files. BPC420 P.609
460
Describe the customizing for Validation
set up in bw see detail questions BPC420 P.609
461
Why does one use master data validation?
control special combinations of data selections; are only allowed during loading or saving. -- prevent loading of incorrect combinations. BPC420 P.610
462
What is the transaction code for master data validations?
UJ\_VALIDATION BPC420 P.611
463
How many driver dimensions are permitted in a model?
only one. However, several rules can be applied to the driver dimension. Rules on the dimension apply to all models that use the dimension. BPC420 P.611
464
How is an AND condition created with driver dimension rules?
two rules that collide BPC420 P.612
465
Master Data Validation and driver dimension rules
driver dimension rules are another way to validate data loads in addition to transformation files. BPC420 P.613
466
What members can be used in driver dimension rules?
range of member, members not yet created(errors, but continue). BPC420 P.613
467
Can you compy a driver dimension validation configuration to another environment?
Yes BPC420 P.613
468
What happens if you delete a dimension?
The dimension driver validation configuration is deleted with it. BPC420 P.613
469
Dimension driver validations turn on/off on which objects?
environment, model, journal, manual planning, Data manager. BPC420 P.613
470
What are three validation switches in driver dimension validations?
journal, manual planning, Data manager. All packages for Data manager. Both web and excel for planning. BPC420 P.613
471
How is driver dimension authorization controlled?
transaction authorizations S\_TRANS object BPC420 P.613
472
How can changes in driver dimensions be tracked?
"Audit Module" - stored in underlying validation tables (UFV\*) BPC420 P.613
473
Lesson 21: Configure Audits
Lesson 21: Configure Audits BPC420 P.625
474
How do you track changes in data and configuration?
Audit BPC420 P.625
475
What is a benefit of Audit tool?
To comply with statutory regulations and SOX (Sarbanes-Oxley) requirements, it has to be ensured that all security changes as well as changes to the configuration are tracked. This enables external auditors to perform the audit as well as giving them confidence into the system. BPC420 P.626
476
At what levels is auditing available?
Activity & Data audition are the 2 categories: admin & user tasks at environment; transaction data at model level. BPC420 P.626
477
What can be tracked using Audit?
track changes for the following activities, showing the previous and new values as
well as the IP address and machine name associated to the user making a change:
• Administration activities, including:
– Security-related changes, such as adding, changing, and deleting users,
teams, task profiles and member access profiles.
– Create, modify, delete, and copy operations for models and dimensions;
dimension processing; create and delete operations for dimension
members; changes made to property or hierarchy values for a dimension
member; delete and copy operations on environments and on drivers
for driver based calculations.
– Changes to environment and model setup options, global configuration
settings and KPI definitions for automated performance analysis,
document types and subtypes, activity audit settings, and data audit
settings.
• User activities, such as setting data locks.
• Business Process Flow activities, such as adding, deleting, and modifying
business process flows, and saving business process flows to new names.
• User activities in business rules management BPC420 P.627
478
How would a data package be involved in Audit?
Use a data package to archive activity BPC420 P.627
479
What are two ways to archive?
settings in tool & data package "archive activity". BPC420 P.630
480
Where can you view failed audit log updates?
SLG1 transaction code BPC420 P.630
481
Does a user get notification is audit-run is failing?
no BPC420 P.630
482
What are filters to see failed audit logs?
Object = UJ, SubObject=UJU BPC420 P.630
483
Where are audit tables & Audit Archive tables?
Audit Tables: /1CPMB/appset\_prefix+appl\_prefix+AD Audit Archive Tables: /1CPMB/appset\_prefix+appl\_prefix+AD\_A BPC420 P.629
484
What is the purpose of security audit reports?
The purpose of the security audit reports is to show a summary of the users, teams, and profiles that exist for a particular environment. It does not show any security-related activity (for that purpose, you can use activity auditing and the administration audit report, with the appropriate filters). All users can access their own security report. BPC420 P.631
485
What are the general security reports available?
• Data changes • Comments • Work status • Administration Activity. BPC420 P.631
486
What are the options once security report displays?
edit, refresh, print, export BPC420 P.632
487
Whatis work status?
Work status is a feature that allows you to lock regions of data from being overwritten. You define “work states” (for example, Locked, Submitted, or Approved) so users can control input to specific data regions and input methods (for example, to prevent the Data Manager being used to update data). BPC420 P.635
488
Lesson 22: Concurrency Locking
Lesson 22: Concurrency Locking BPC420 P.646
489
LO Define How Concurrency locking works
locking of transaction data when 1 or more users save to same location at same time.
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 example,
manual user planning in Excel/Web, Data Manager, Journals, and so on) must go through a concurrency lock check before data can be saved to the cube. There are
no exceptions, and it can not be bypassed in any circumstances. This process is initiated only when the user tries to Save Data. The locking process works per
data package. Locks are obtained only during the write-back process. A lock cannot persist at the time of read. BPC420 P.646
490
What is Concurrency locking?
locking of transaction data when 1 or more users save to same location at same time.
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 example,
manual user planning in Excel/Web, Data Manager, Journals, and so on) must go through a concurrency lock check before data can be saved to the cube. There are
no exceptions, and it can not be bypassed in any circumstances. This process is initiated only when the user tries to Save Data. The locking process works per
data package. Locks are obtained only during the write-back process. A lock cannot persist at the time of read. BPC420 P.646
491
What is default size of data package save?
40,000 records. When a save is above 40,000 records it starts creating data packages for saving. BPC420 P.646
492
What is code for changing save data "Package Size"?
UJR\_PARAM OR transaction cod UJR0 BPC420 P.646
493
What happens if there are locked records?
save will fail, cannot "unsave" BPC420 P.647
494
What is a component that does not post delta values?
journals don't post delta, so not packages creates since package size is always 99,999,999 records. BPC420 P.647
495
How is data saved?
delta records saved to the cube so packages can be run again. BPC420 P.647
