BPC420 NW Administration L07 - L22 Flashcards Preview

EPM BPC 10.0 > BPC420 NW Administration L07 - L22 > Flashcards

Flashcards in BPC420 NW Administration L07 - L22 Deck (495):
1

2

What is Lesson 07?

Creating Dimensions BPC420 P.85

3

LO Create dimensions & Members

See Questions. BPC420 P.85

4

LO Create properties & hieararchies

See Questions. BPC420 P.85

5

What is the related BW object for Dimension Property?

Integration between dimensions and InfoObjects of type characteristic BPC420 P.85

6

What is a dimension?

dimension is a collection of related members, which represent one aspect of a business, i.e. accounts, products, currency. BPC420 P.85

7

How are dimensions managed?

Define members, create hierarchies, assign properties BPC420 P.85

8

Do dimensions belong to only one model?

dimensions can be added to one or more models. BPC420 P.85

9

Are Dimension IDs case sensitve? Unique?

no, yes BPC420 P.87

10

What are the dimension ID guidelines?

no special char, 16 char length, No number at position1, no reserved names (app, AppAccess, formula,…. List p 87) BPC420 P.87

11

What are dimension description guidelines?

255 char max BPC420 P.88

12

What does type allow?

Allows you to organize dta within model based on type BPC420 P.88

13

What is referential integrity?

validates properties of dimension with the IDs of a different dimension, completes during processing. BPC420 P.88

14

What are the different dimension types?

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

Can an environment have multiple dimensions of one type?

Yes, however only one of each of the required types. BPC420 P.88

16

Which dimension types are required for a model?

A, C, D, E, R, T - BPC420 P.88

17

What is A-Account?

chare og accounts and measures, stat keys BPC420 P.88

18

What is C-Category?

Budget, Forecast, actual BPC420 P.88

19

What is D - Audit?

Data source, used to segregate input data BPC420 P.88

20

What is E-Entity?

business units, cost center, geographic entity, profit cneter, legal company, region BPC420 P.88

21

What is G-Group?

Group provides multiple currencies for a group member. Uses single entity structure to report consolidated results in multiple group currencies. BPC420 P.89

22

What do you need to know about using R & G?

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

What is I- intercompany?

contains the intercompany codes for entities, for legal consolidation intercompany matching and elimination. BPC420 P.89

24

What is R-Currency?

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