Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

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

BPC420 NW Administration L07 - L22 Flashcards

1
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Lesson 07?

A

Creating Dimensions BPC420 P.85

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

LO Create dimensions & Members

A

See Questions. BPC420 P.85

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

LO Create properties & hieararchies

A

See Questions. BPC420 P.85

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the related BW object for Dimension Property?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How are dimensions managed?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Do dimensions belong to only one model?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Are Dimension IDs case sensitve? Unique?

A

no, yes BPC420 P.87

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are dimension description guidelines?

A

255 char max BPC420 P.88

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does type allow?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is referential integrity?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Which dimension types are required for a model?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is A-Account?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is C-Category?

A

Budget, Forecast, actual BPC420 P.88

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is D - Audit?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is E-Entity?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is I- intercompany?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What is S-Subtables?

A

Used to break down account activity or flow. (Opening, Additions, Deletions, Transfers, Ending Balances). BPC420 P.89

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What is Subtables important for?

A

writing business rules that require currency translation amounts to be calculated by account. BPC420 P.89

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Whati is T-Time ?

A

custom time or weekly, monthly, quarterly BPC420 P.89

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What is U-User?

A

Any User-defined dimension for planning process. U1, U2, … BPC420 P.89

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Tell about predefined properties?

A

based on dimension type, a dimension contains pre-defined properties. Add new Properties as desired. BPC420 P.89

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Why would one flag “allow dimension formulas”?

A

to allow creation of member formulas BPC420 P.90

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What are two ways to open up the structure of a dimension?

A

“Edit Structure” in toolbar or hyperlink BPC420 P.90

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What do properties do?

A

define behavior of dimension members BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

What are some powerful features of properties?

A

member lookup, formulas, data manager selections, reporting, filtering, BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What are 3 ways to use properties for a region?

A

1-filter & sort 2-logic 3-defined report format BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What are rules for Properties?

A

not case sensitive, unique, ID 20 char max, no special char, no number in position1, not a reserved word, BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

What is max length of Property ID?

A

20 char BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

What is max length of Property name?

A

40 char BPC420 P.91

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

What are the required dimension types?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What properties can be modified or removed?

A

system-generated properties cannot be removed or modified. Othes may be. BPC420 P.92

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

What are some system-generated properties?

A

ACCTYPE, RATETYPE, SCALING BPC420 P.92

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

What properties are generated for all dimension types, but not displayed?

A

Description, CALC, HIR BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

What is CALC?

A

indicates whether calculated by formul or is at parent level. BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

What is HIR?

A

stores the hierarchy IDs associated with the member, H1, H2,.. BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

What are 2 reserved IDs?

A

SOLVE_ORDER , FORMULA BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

What is SOLVE_ORDER?

A

a property that defines the order of calculation when calculated members intersect calculated members BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

What is FORMULA property?

A

optional property that allows you to define dimension member formulas BPC420 P.93

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

What is max chars for dimension member?

A

32 in 10.0, 20 in 7.5 BPC420 P.95

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

What special characters are allowed in Dimension member ids?

A

_ & - (underscore & hyphen) BPC420 P.95

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

What is Delete & Revert?

A

only available if the changes are not confirmed to the dimension members BPC420 P.98

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

What is the command to change oder of appearance?

A

“Apply Hierarchy order” - requires that Hiearchy is set up BPC420 P.98

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

What does the “display” option do in list view?

A

view property header by name or by ID BPC420 P.99

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

What does the “display” option do in hierarchy view?

A

display member id, description, or both. BPC420 P.99

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

What type of object is a dimension in BW?

A

InfoObject of type Characteristic BPC420 P.99

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

What does the “maintain” button in BW show you?

A

data in InfoProvider, what does it look like? 2 green squares BPC420 P.123

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

In BW where is the “maintain hierarchies” button?

A

On the hierarchy tab of the InfoProvider BPC420 P.123

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

How do you get to view the hieararchy in BW?

A

InfoProvider, Hierarchy tab, click “maintain Hiearachies” button, double-click yellow bar BPC420 P.123

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

In BW what does the “Expand Branch” icon look like?

A

Two triangles pointed down. Shows full hiearachy. BPC420 P.123

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

What is Lesson 08?

A

Creating Models BPC420 P.126

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

LO - Discuss the Creation of a Model

A

See Questions. BPC420 P.126

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

LO - Explain Model Page features

A

See Questions. BPC420 P.126

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

LO - Outline the do’s and don’ts in BW InfoProviders created in BPC

A

See Questions. BPC420 P.126

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

LO- Describe delivered Measure Formulas and define Custom Measures

A

See Questions. BPC420 P.126

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

How do you create a model?

A

Use the six step wizard BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q

What are the two main types of model?

A

Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q

What are the six types of model?

A

Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
66
Q

What are the 2 Data Entry modes for a model?

A

Periodic or YTD BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
67
Q

What is general setting for data entry mode?

A

Periodic BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
68
Q

When is YTD data entry mode used?

A

model with foreign currency conversion. Balances are accumulated/YTD BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
69
Q

Describe a Standard model

A

No special requirements, no default business intelligenc/Logic. Create logic as needed. BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
70
Q

What are the required dimensions for a standard model?

A

A, C, E, T Account, Category, Entity, Time BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
71
Q

Describe a Financial Model

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
72
Q

What are the required dimensions for a Financial model?

A

A, C, E, T, R Account, Category, Entity, Time, Currency BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
73
Q

Describe a Consolidation Model

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
74
Q

What are the required dimensions for a Conolidation model? 9

A

A, C, D, E, G, I, R, S, T Account, Category, Audit, Entity, Group, Intercompany, Currency, Subtables, Time, BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
75
Q

what are three reporting model types?

A

Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
76
Q

What are three Driver & rate model types?

A

Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
77
Q

What do reporting models hold?

A

financial data BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
78
Q

All models require which 4 dimension types?

A

A,C, E,T - Account, category, entity, time BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
79
Q

What is the special business rule in consoldiations not in standard?

A

Automatic Adjustments BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
80
Q

What are the additional required dimensions for consolidation?

A

D, G, I, R, S, Audit, Group, Intercompany, Currency, Subtables, BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
81
Q

What is the synonym for subtable?

A

Flow BPC420 P.128

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
82
Q

What is a benefit of copying a model?

A

reports, input forms, journal template(option), control definitions (option), and data packages copy over to the new model. BPC420 P.130

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
83
Q

Will Source Data transfer when copying a model?

A

source data no, data yes, BPC420 P.130

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
84
Q

Can you have duplicated diminsion types in a model?

A

no, exception is user defined which are unique by U1, U2, … BPC420 P.130

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
85
Q

When copying a model, where are business rules activated?

A

in “Business Rules” view. BPC420 P.137

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
86
Q

What are control definitions?

A

Financial and Consolidation type BPC420 P.137

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
87
Q

What are 5 features of a model availabe to enable?

A

Work status, Data Audit, Journal templates, Comments, “Use as Source of Data” BPC420 P.137

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
88
Q

What is “Use as Source of Data”?

A

enables the ODBO clients to retreive data from the model, Excelsius, EPM Connector, GRC Process controls integration BPC420 P.137

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
89
Q

What is “change type” for a model?

A

allows a change withint type (Reporting or “Drivers & Rates”) BPC420 P.137

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
90
Q

When changing a model type, can you change dimensions?

A

Yes, add or remove. BPC420 P.139

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
91
Q

What does light optimization do?

A

closes open request, compresses without zero-elimination and indexes the cube, updates database statistics for the BW InfoCube. BPC420 P.139

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
92
Q

What does Full optimization do?

A

Sames as light. Plus it checks to see if data model can be improved. BPC420 P.139

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
93
Q

What are the full optimization checks?

A

dimension tables have <20% size of Fact table, moves data to shadow cube, compress, index,…NEW technical name. BPC420 P.139

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
94
Q

What is a BW consequence of full optimization?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
95
Q

Do both optimizations take the system offline?

A

Yes BPC420 P.140

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
96
Q

Manage dimensions in BW or BPC?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
97
Q

In which table are dimensions to an application stored?

A

UJA_DIM_APPL BPC420 P.140

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
98
Q

What changes CAN be made in BW for BPC properties?

A

“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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
99
Q

Is partitioning available?

A

not yet because BPC is not using standard SAP time dimension. BPC420 P.142

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
100
Q

What is created when an application/model is created?

A

InfoProvider, MultiProvider, Query, BPC420 P.142

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
101
Q

Where can you find the technical name of the InfoProviders?

A

UJA_APPL BPC420 P.142

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
102
Q

Is a new InfoArea created for each AppSet/Environment?

A

Yes BPC420 P.142

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
103
Q

What is the naming convention of InfoProvider?

A

/CPMB/I BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
104
Q

What is the naming convention of MultiProvider?

A

/CPMB/M BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
105
Q

Whatis the naming convention of Query?

A

/!!O BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
106
Q

Why can dimensions be removed from a model in BPC and not BW?

A

the BW remodeling toolbox is not required, so we can do this. BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
107
Q

What about the MultiProvider and full optimization?

A

MultiProvider will automatically point to new InfoProvider. Query & MultiProvider created. BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
108
Q

What is BW part of a BPC query?

A

MDX statements are performed against query which is on top of the MultiProvider. BPC420 P.143

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
109
Q

What is the BW equivalent of measures?

A

calculated key figures BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
110
Q

How many key figures in an InfoProvider?

A

1…but it is possible to report on multiple “measures”. BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
111
Q

What are the three measures delivered with BPC?

A

Periodic, QTD, YTD BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
112
Q

Does it matter if data is stored as Periodic or YTD for the three measures?

A

no matter whether periodic or YTD, periodic, QTD, and YTD are available for reporting. BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
113
Q

What are some example custom measures?

A

Week to Date, Month to Date, Rolling 12 month total, … BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
114
Q

Where is the measure table?

A

UJA_Formula BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
115
Q

What do you need to modify the measure table?

A

write MDX formulas. Use variables in place of technical names. Must do for BOTH PER & YTD. BPC420 P.144

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
116
Q

What does MDX stand for?

A

Multidimensional Expressions – typically deal with SIGN transformations and TIME calculations for each account type. BPC420 P.145

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
117
Q

What do you need to do if you update UJA_Formula?

A

need to manually update UJA_FORMULA_APP as well for each model/application. BPC420 P.145

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
118
Q

What is the reason you can’t use a BW InfoProvider to create Models?

A

The configuration of logic, business rules, Audit, Comments, work status,… BPC420 P.145

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
119
Q

What is Lesson 09?

A

Describing the Security Model BPC420 P.153

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
120
Q

LO Discuss the BPC security concept?

A

See Questions. BPC420 P.153

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
121
Q

LO Recognize security conflicts

A

See Questions. BPC420 P.153

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
122
Q

What is Event & Notification function?

A

create messages and alerts in App or emails. Can contain hyperlinks. Security addresses. BPC420 P.153

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
123
Q

What is Content Lifecycle Management (CLM)?

A

tool that support distribution of content across systems. Security addresses. BPC420 P.155

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
124
Q

What is the BW transaction for Manage Users & Roles?

A

SU01 & PFCG..ABAP user management mechanisms BPC420 P.155

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
125
Q

What are the steps to assign security? Which step is optional?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
126
Q

What are the Admin Team types? 3

A

Primary (full admin, ?no dimension access?), Secondary (public folder & dimension access), System Admin (full admin & dimension access) BPC420 P.155

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
127
Q

What kind of security reporting is available?

A

“Enable Auditing of Administration Activity” BPC420 P.155

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
128
Q

What is an Emergency User?

A

when normal access is not available, log on as SysAdmin or other user with Admin rights. BPC420 P.155

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
129
Q

What about SSO & EPM products?

A

SSO is available, must use same DNS (Domain Name System) BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
130
Q

What is no longer supported for security?

A

Windows Active Directory & “CMS” BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
131
Q

Which security object is in BW?

A

Task profile. Other are in BPC ABAP tables. BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
132
Q

What are task rights of System Administrator?

A

1 - manage environments 2 - Manage Security 3-Use system when offline BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
133
Q

What are task rights of Secondary Administrator?

A

Manage dimensions, Edit Content of Public Folder BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
134
Q

What are task rights of Primary Administrator?

A

All Tasks (….) BPC420 P.157

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
135
Q

What is the limit on Task Profiles?

A

none, task security is cumulative BPC420 P.160

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
136
Q

What are the possible values for “Assigned to” concerning task profiles?

A

“All Teams” or “Some teams only” – seems outdated. BPC420 P.167

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
137
Q

What are the user types required?

A

“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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
138
Q

What are Sarbanes-Oxley options?

A

challenge users for pw. Can store Pw on client machined (Admin can disble for enhanced SO compliance). BPC420 P.169

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
139
Q

How is pw saving on client machine disabled?

A

in BW transaction SPRO / IMG true=enhanced BPC420 P.169

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
140
Q

If a technical users is set up, what should be the type?

A

communciation. “technical” users not required nor recommended. BPC420 P.170

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
141
Q

What roles are required in BW?

A

Static: /POA/BUI_FLEX_CLIENT, /POT/BUI_UM_USER (NOT environment related) Dynamic: “task” and “data access” BPC420 P.171

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
142
Q

Can a “team Lead” be established in team security?

A

Yes BPC420 P.173

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
143
Q

What is a “team lead” used for?

A

Research BPC420 P.180

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
144
Q

What drives security conflict resolution?

A

Data Access: Write, Read Only, Denied. Write is least restrictive. “Less restrictive” profile wins. BPC420 P.180

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
145
Q

What authority do child members have?

A

Child members always have access level of parent unless otherwise specified. BPC420 P.181

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
146
Q

How does hierarchy factor in with a secured dimension?

A

Ignore H1, H2… BPC420 P.182

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
147
Q

What is Lesson 10?

A

Define Parameters BPC420 P.189

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
148
Q

LO Discuss the functional parameters and configuration parameters

A

See Questions. BPC420 P.189

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
149
Q

LO Describe how to customize parameters

A

See Questions. BPC420 P.189

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
150
Q

What are administration parameters?

A

Administration parameters are used to change or enhance the functionality and configuration of BPC scenario BPC420 P.189

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
151
Q

What are the three types of administration parameters?

A

Functional, Configuration, & System BPC420 P.189

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
152
Q

What is a functional parameter?

A

Set by the user in UI of Admin workspace. EX: APPROVALORG, work status options, Model options (comment) BPC420 P.190

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
153
Q

What is a configuration parameter?

A

From BW SPRO / IMG –mainly technical parameters that are set once in IMG. EX: ALLOW_FILE_SIZE BPC420 P.190

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
154
Q

What is a system parameter?

A

set by system, mainly flags, cannot be set by user through and Admin UI. EX: AVAILABLEFLAG BPC420 P.190

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
155
Q

Which 3 tables contain sytem parameters?

A

UJA_PARAM (cross environment) & UJA_PARAM_APP (Environment & Model level), UJA_USER_DEF (a few) BPC420 P.190

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
156
Q

What are the 3 parameters within Configuration parameters?

A

Global, Environment, Model BPC420 P.192

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
157
Q

What are 2 important Configuration - Environment parameters?

A

ALLOW_FILE_SIZE - max 100MB user file upload size, ALLOW_EXTENSIONS - defines permitted files for upload. BPC420 P.193

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
158
Q

What does the IMG activity “documentation” & “activity” button look like?

A

See book. BPC420 P.193

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
159
Q

What is an importatant Configuration - Model parameter?

A

BPC_STATISTICS (monitor system performance) BPC420 P.193

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
160
Q

Which 2 tables are useful for monitoring performance?

A

UJ0_STAT_HDR & UJ0_STAT_DTL BPC420 P.193

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
161
Q

How do you enable monitoring of system performance?

A

BPC_STATISTICS (monitor system performance) BPC420 P.193

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
162
Q

What is Lesson 11?

A

Using the EPM Add-in BPC420 P.199

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
163
Q

LO Create an EPM add-in connection

A

See detail questions BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
164
Q

LO Describe the features of the EPM add-in ribbon

A

See detail questions BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
165
Q

LO Define default values for dimensions with the EPM Context Bar

A

See detail questions BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
166
Q

LO Build a simple report

A

See detail questions BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
167
Q

What are 7 features of EPM Retrieval?

A

CADCCPI - Create Reports, analyze data, dynamic formatting, calculations, charts, print and share, Integration. BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
168
Q

What are 4 features of BPC only?

A

1 Data Input 2 Planning functions 3 Distribution & Collection 4 Data Manager BPC420 P.200

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
169
Q

What are 5 connection types?

A

SSAS (SQL Server Analysis Services), BW , ODBO (Old DB OLAP), XMLA (xml for analysis), WS (Web Services) BPC420 P.201

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
170
Q

What are the command display options?

A

Reports, Data Analysis, Data Input, Tools, Data Manager BPC420 P.209

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
171
Q

What are the options under Reports Group?

A

open, save, edit report, new report, report actions, view formats, refresh. BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
172
Q

What are the options under Data Analysis Group?

A

Expand, collapse, Keep, exclude. BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
173
Q

What are the options under Data Group?

A

save data (save, refresh, validate, change work status), comments, planning, journals. BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
174
Q

What are the Collaboration options?

A

Book Publication(publish pre calculated workbooks to the web), Distribution (and collection), Portal Publication(publish to a BI launchpad). BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
175
Q

What are options under Tools group?

A

drill through, quick links, offline mode, insert function, options, More (freeze data refresh, acessmemeber properties…) BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
176
Q

What are 2 ways to adjust the EPM Context & Pane?

A

Drag and drop, dropdown arrow. BPC420 P.212

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
177
Q

Where are default context members set?

A

Context Options BPC420 P.NA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
178
Q

What is Lesson 12?

A

Data Manager BPC420 P.248

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
179
Q

Explain the Data Manager Package tool and the issues related to it

A

See detail questions BPC420 P.248

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
180
Q

What is required for Data Manager Connection?

A

only possible via a Webservice connection, not “Local” connection, not ODBO. See image p 248 BPC420 P.249

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
181
Q

Does default logic automatically run when you import data?

A

most of the time BPC420 P.249

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
182
Q

What is Data Manager

A

import, copy or move data within and across models, export. Supports mapping and complex transformations. BPC420 P.249

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
183
Q

What is in the Data Manager group?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
184
Q

Run Admin Packages

A

can view and run packages set to type “admin” BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
185
Q

Edit Packages

A

edit, create, delete, change package type. Add transformation and conversion files BUT not edit them. BOTH admin and user type packages. BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
186
Q

Edit Transformation files

A

edit, create, delete, BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
187
Q

Edit Conversion files

A

edit, create, delete, BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
188
Q

Cancel any user packages

A

NW only. Cancel other user packages. BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
189
Q

Edit package schedules for any users

A

view or change schedules for any package. Detailed logs may contain sensitive data, thus this type of task is required. BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
190
Q

Run Packages

A

run packages that have security folder rights for BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
191
Q

Edit Package Links

A

edit, create, delete, BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
192
Q

Upload Data

A

upload a data file BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
193
Q

Download Data

A

ability to download and preview. BPC420 P.251

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
194
Q

What are the three types of packages within Data Manager?

A

Data Management, Financial Processes, System Administration note: packages are shared across all environments and models. BPC420 P.252

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
195
Q

What is special about NW data packages?

A

They are technically Process Chains. BPC420 P.252

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
196
Q

What is a process chain?

A

defined beginning and end, sequence of processes, BPC420 P.252

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
197
Q

What are dynamic packages?

A

designed to work without modification BPC420 P.252

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
198
Q

Where can you modify packages to behave differently or to perform additional functions?

A

“Organize Package Lis” BPC420 P.253

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
199
Q

Where can process chain templates be displayed and edited?

A

ABAP transaction RSPC BPC420 P.254

200
Q

How are delivered process chains activated?

A

note: delivered process chains must be activated. version changes from “delivered” to “active”. BPC420 P.254

201
Q

What is the delivered package to start a data load from ERP to BW?

A

“BPC trigger BW Process Chain” – and then from BW to BPC, package link BPC420 P.255

202
Q

What are the custom process types?

A

IF_RSPC_EXECUTE, IF_RSPC_GET_VARIANT,IF_RSPC_MAINTAIN, IF_RSPC_TRANSPORT BPC420 P.255

203
Q

Which process type can be omitted in a custom, but not delivered ?

A

transport BPC420 P.255

204
Q

What is needed for the custom process type?

A

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
Q

How can you retract both master & transaction data?

A

BADI BPC420 P.256

206
Q

How do you initiate delta initialization?

A

Organize Delta Initialization on “Data Manager” tab. “trigger a full load at first run” is a flag option. BPC420 P.256

207
Q

From which BW objects is data loaded?

A

DSO (Data Store Objects) full or delta load. BPC420 P.256

208
Q

Which objects support full or delta load?

A

both Delta & full(standard cube, standard DSO, write-optimized DSO). Full Only(virtual & MultiProvider. BPC420 P.256

209
Q

How can data packages impact performance?

A

data in temporary tables. “dump” BPC420 P.257

210
Q

What is Data Manager Maintenance Program?

A

SE38 & UJD_BACKEND_DATA_MAINTENANCE, retrieves and displays all obsolete data entries that can be deleted to improve performance. ! BPC420 P.257

211
Q

What are 4 tasks with packages?

A

run or shedule, Organize packages into a list, view package status, view schedule status. BPC420 P.257

212
Q

What are 3 things to keep in mind about data manager packages?

A

links are model specific, execute in sequence and stops at first failure, only run packages that user has permissions BPC420 P.260

213
Q

What is Lesson 13?

A

Data Loads BPC420 P.262

214
Q

Explain the configuration of flat file uploads

A

See detail questions BPC420 P.262

215
Q

Describe the set up of Uploads from BW

A

See detail questions BPC420 P.262

216
Q

Install Master Data Upload, hierarchy upload, transaction data upload

A

See detail questions BPC420 P.262

217
Q

What is a tranformation file?

A

1 worksheet, named instructions, sets up rules for reading data from external source BPC420 P.262

218
Q

What are three parts of a transformation file?

A

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
Q

What is a conversion file?

A

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
Q

How are BADIs related to transformation files?

A

start_routine, end_routine jump to ABAP, routines are defined in BW within BADI implementation. BPC420 P.267

221
Q

What is the transaction code for Badi?

A

UJD_routine BPC420 P.267

222
Q

Where does the BADI filter go in the transformaiton file?

A

Options section BPC420 P.267

223
Q

What is *COL(A)?

A

defines a dimension for a field in the data file when there’s no header row. BPC420 P.268

224
Q

What is *COL(A, B:C)?

A

defines a dimension for a subset of a field of a data file BPC420 P.268

225
Q

What is *NEWCOL(A)?

A

function creates a new field with the given value BPC420 P.268

226
Q

Dimension=*MVAL(keyfigure-type1|dim_mem1||keyfiguretype2|dim_mem2||keyfiguretype3|dim_mem3)

A

can be used to do a data transfer from a key figure model to an account model BPC420 P.268

227
Q

*Str(string)

A

function adds text string to the members of a column BPC420 P.268

228
Q

*If (Condition1 then Action1;Condition2 thenAction2;Default Action)

A

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
Q

What is the conversion syntax?

A

Dimension Name = [COMPANY]WorkbookName[!SheetName] -note: items in brackets are optional. BPC420 P.269

230
Q

What are best practices for conversion files?

A

one file per dimension, same name as dimension, BPC420 P.270

231
Q

How do you ignore external data?

A

*skip in the internal column BPC420 P.270

232
Q

How do you set javascript to run on internal or external column?

A

convert_internal= No (js in internal), Yes (js in external) BPC420 P.270

233
Q

What do you preced Java script with?

A

js: BPC420 P.270

234
Q

Can you use javascript with If statements?

A

yes BPC420 P.271

235
Q

js:%external%.substring(0,2)

A

return a Long containing the number of characters in a string BPC420 P.271

236
Q

js:%external%.length

A

return the length of the string contained in external BPC420 P.271

237
Q

js:%external%.replaces(“apples”,”oranges”)

A

return a string where a substring has been replaced… BPC420 P.271

238
Q

How do you revalue during upload? Revaluation

A

use the formula column that is executed during upload. BPC420 P.271

239
Q

What is CONVERTAMOUNTVVDIM?

A

points to the formula column for dimension BPC420 P.272

240
Q

What are three data upload packages?

A

Append, Import, Import Append (contains 2 overwriting possibilities) BPC420 P.274

241
Q

For data package how is the target determined?

A

uses current connection BPC420 P.274

242
Q

when do you use *MVAL?

A

?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
Q

what is the process chain for importing master data?

A

/CPMB/IMPORT_IOBJ_MASTER BPC420 P.278

244
Q

What are the two operators for “set selection”?

A

= , BT (between) BPC420 P.278

245
Q

What is option with “Import Text Node”?

A

Y, and level. So node and two levels down is level=2. BPC420 P.278

246
Q

What is level=0? Data package

A

only the specified member ID will be returned as a tree which only has one node. BPC420 P.279

247
Q

What if level is blank/unspecified? Data package.

A

whole sub-tree is selected by taking the member ID as root. BPC420 P.279

248
Q

Write Mode: Overwrite

A

master data that has no data will be deleted, rest is overwritten BPC420 P.279

249
Q

Update Mode:

A

master data will be overwritten if the id is the same, new master data will be added. BPC420 P.279

250
Q

What if Internal format is selected for data package?

A

no conversion routine is used during the import process. BPC420 P.279

251
Q

What is External format is set?

A

related ABAP conversion routine will be used, if one is maintained on the source InfoOjbect from BW transaction RSD1. BPC420 P.280

252
Q

What is Javascript replace method?

A

js: %external%.replace(“-“,”_”) BPC420 P.280

253
Q

What is JavaScript split and join?

A

js:%external%.split(‘ ‘).join(‘’) – remove spaces from master data BPC420 P.280

254
Q

What is process chain for importing hierarchy?

A

/CPMB/IMPORT_IOBJ_HIER. BPC420 P.281

255
Q

Can you import partial hierarchy?

A

Yes, use levels BPC420 P.281

256
Q

What is source and target for hierarchy?

A

UJN_S_HIER_NODE is used as both the source structure and target structure in transformation file mapping. BPC420 P.282

257
Q

Is ParentH* format required?

A

Yes BPC420 P.283

258
Q

When preparing hierarchy what must be done?

A

replace - with _, remove blanks, parenth* BPC420 P.283

259
Q

What is another option for space replace for hierarchy upload?

A

js:%external%.toString().replace(/\s+/g,“”) BPC420 P.283

260
Q

In which section of a transformation file do you write code for removing blanks?

A

*Mapping BPC420 P.290

261
Q

What is a text node?

A

only exists in a hierarchy BPC420 P.300

262
Q

Lesson 14: Creating Basic Logic Scripts & Online Execution

A

Lesson 14: Creating Basic Logic Scripts & Online Execution BPC420 P.365

263
Q

What is online execution of logic?

A

running in default logic instead of Data Manager packages. Users execute by themselves. BPC420 P.367

264
Q

Describe the concept of logic scripts

A

Describe the concept of logic scripts BPC420 P.367

265
Q

Identify Logic Script Commands

A

Identify Logic Script Commands BPC420 P.367

266
Q

Recognize the Golden Rule for Logic Scripts

A

Recognize the Golden Rule for Logic Scripts BPC420 P.367

267
Q

What are 4 primary types of Logic? 2 additional?

A

Worksheet, Member Formulas (use sparingly), Scipts, Business Rules – Dimension formulas, Microsoft MDX(multidimensional expressions) language BPC420 P.369

268
Q

What is worksheet based logic?

A

exists in worksheets only BPC420 P.369

269
Q

What are member formulas?

A

powerful formulas mostly for account dimension members. BPC420 P.369

270
Q

What are dimension formulas?

A

defined at environment level, valid across all models BPC420 P.369

271
Q

What is a logic script?

A

calculate, but only at base level members BPC420 P.369

272
Q

What is a business rule?

A

table based logic - only for management & legal consolidations. Don’t have to understand scripting. BPC420 P.369

273
Q

Which business rules are delivered with BPC?

A

Account transformation, currency conversion, intercompany booking, carry-forward rules, US elminations, validations, automatic adjustments BPC420 P.369

274
Q

What are a few things to know about logic?

A

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
Q

What are 4 benefits of script logic?

A

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
Q

How do you navigate to Logic?

A

Rules / Logic Scripts BPC420 P.371

277
Q

What are 2 types of Logic?

A

default, other BPC420 P.371

278
Q

what is default logic?

A

automatically executed on every write back to the model. BPC420 P.371

279
Q

What are two files for each logic script?

A

.LGF(ASCII file), .LGX (compiled, not stored in BPC) BPC420 P.371

280
Q

What are three components of Script Logic?

A

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
Q

What is Calcaccount.lgf?

A

prepare cash flow; run Account Calculation Business Rule BPC420 P.372

282
Q

What is Consolidation.lg?

A

run legal consolidation business rule BPC420 P.372

283
Q

What is Copy_Opening.lgg?

A

run a balance carry forward business rule BPC420 P.372

284
Q

What is FX_Trans.lgf?

A

run currency conversion? BPC420 P.372

285
Q

What is ICBooking.lgf?

A

run intercompany reconciliation and difference posting BPC420 P.372

286
Q

What is ICData.lgf?

A

run intercompany reconciliation BPC420 P.372

287
Q

What is ICElim.lgf?

A

run intercompany reconciliation BPC420 P.372

288
Q

What is MDXlib.lgf?

A

library of MDX financial functions BPC420 P.372

289
Q

What is System_Constants.lgf?

A

stores constant values for use in scripts BPC420 P.372

290
Q

What is System_Library.lgf?

A

basic examples of keywords BPC420 P.372

291
Q

What is Validation.lgf?

A

run a validation rule BPC420 P.372

292
Q

What is scope with logic on save?

A

scope of query is non-calculated accounts, only specific members sent to BPC420 P.373

293
Q

What is scope with logic invoked via Data Manager package?

A

1 Prompted Dimensions: only selected members 2 Nonspecified dimensions = all members 3 Currency LC if not specified. BPC420 P.373

294
Q

What is a program for debugging script logic?

A

UJK_SCRIPT_LOGIC_TESTER - transaction code SE38 (ABAP Editor) BPC420 P.373

295
Q

What are steps for using logic tester?

A

1 - input environment, model, dimensions, 2 - specify script or paste into lowe left editor bax BPC420 P.374

296
Q

What are 3 run options on logic tester?

A

validate, execute, execute (simlulate) BPC420 P.376

297
Q

What is *WHEN?

A

trigges use of SQL syntax, used to narrow scope further BPC420 P.376

298
Q

Wha tis *WHEN * *IS *?

A

entire section BPC420 P.376

299
Q

*WHEN ACCOUNT *IS “SalesUnits”

A

Sales Units account BPC420 P.376

300
Q

how do you differentiate numeric from text in logic?

A

use quotes for text Ex: *IS “AVG” vs *IS 10 BPC420 P.376

301
Q

What if *IS is used without an operator?

A

= equal is assumed BPC420 P.376

302
Q

What is limitation with <>?

A

can only follow with one number. *IS <> 2,3,4 is invalid. BPC420 P.376

303
Q

What operators are not supported?

A

AND, OR, NOT, *IS dimension.property BPC420 P.376

304
Q

how many levels allowed for WHEN/ENDWHEN?

A

as many as desired BPC420 P.376

305
Q

What is *REC in logic?

A

generate a new record BPC420 P.377

306
Q

What are the paramters of REC() ?

A

specify what to modify in the original record, generate as many records as want BPC420 P.377

307
Q

What is FACTOR?

A

multiplies source by facor BPC420 P.377

308
Q

What is EXPRESSION?

A

apply an arithmetic operator ( + - / *) BPC420 P.377

309
Q

What does second part of record statement do?

A

tells the value where to post BPC420 P.377

310
Q

What is code to *1.25 and post to XYZ?

A

*REC(FACTOR=1.25, ACCOUNT=”XYZ”) OR *REC(EXPRESSION=%VALUE%*1.25, ACCOUNT=”XYZ”) BPC420 P.377

311
Q

What is a limitation of REC?

A

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
Q

What ideal case for *COMMIT?

A

use one and use sparingly as there is a performance impact. BPC420 P.379

313
Q

What is *XDIM_MEMBERSET?

A

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
Q

What is the syntax for *XDIM_MEMBERSET?

A

*XDIM_MEMBERSET {dimension name} = {member set} Ex: *XDIM_MEMBERSET INTCO = Non_Interco BPC420 P.379

315
Q

If you want to use calculated members what do you have to do before another formula can use?

A

*COMMIT to database BPC420 P.379

316
Q

How & why is *XDIM_ADDMEMBERSET used?

A

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
Q

What is *XDIM_MAXMEMBERS? Example?

A

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
Q

DIM {dimension} = {member}; WHERE = BAS({member});

A

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
Q

*FOR / *NEXT

A

loops BPC420 P.381

320
Q

*XDIM_FILTER

A

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
Q

*SELECT

A

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
Q

*SELECTCASE & IIF

A
  • 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
Q

What is the MDX IIF equivalent of *SELECTCASE [ACCOUNT].CURRENTMEMBER.PROPERTIES(“CALC”) ?

A

=IIF([ACCOUNT].CURRENTMEMBER. PROPERTIES(“CALC”)=Y,1,IIF([ACCOUNT]. CURRENTMEMBER.PROPERTIES(“ CALC”)=N,1,null)) BPC420 P.384

324
Q

Which is a much better performer? *SELECTCASE or WHEN/ENDWHEN?

A

WHEN/ENDWHEN BPC420 P.384

325
Q

*ADD

A

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
Q

TMVL Parameter

A

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
Q

Where can TMVL be used?

A

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
Q

What is an implied keyword?

A

available for each dimension %DIMNAME_SET%, %INTCO_SET% or %TIME_SET%. 2 - reads Context BPC420 P.386

329
Q

What is keyword SET?

A

refers to the context for the value BPC420 P.386

330
Q

What is keyword DIM?

A

syntax: %{DimType}_DIM% BPC420 P.386

331
Q

What are valid types of DIM

A

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
Q

How can a value outside scope be grabbed? (3)

A

Expand the scope, use *LOOKUP/*ENDLOOKUP, use *DESTINATION_APP BPC420 P.387

333
Q

*LOOKUP/*ENDLOOKUP

A

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
Q

*FOR/NEXT & LOOKUP

A

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
Q

*DESTINATION_APP

A

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
Q

*SKIP_DIM with DESTINATION_APP

A

skip dimensions in destination BPC420 P.388

337
Q

*ADD_DIM with DESTINATION_APP

A

is used to indicate which member to use for the dimensions that do not exist in the source application. BPC420 P.388

338
Q

How to avoid re-writing logic?

A

Update the Constants file at Enviroment level BPC420 P.389

339
Q

What are 2 scenarios for configuring Constants for logic?

A

1 -Environment level 2 - Configuration of Constants at Model level. BPC420 P.391

340
Q

Stay away from MDX logic

A

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
Q

How can you code A = B+C?

A

*XDIM_MEMBERSET ACCOUNT = B,C *WHEN * *IS* *REC(ACCOUNT=A) *ENDWHEN BPC420 P.391

342
Q

How many records load in memory?

A

as few as possible BPC420 P.391

343
Q

Logic rule regarding structure?

A

keep as compact as possible. BPC420 P.391

344
Q

What 3 actions does *COMMIT trigger?

A

read records, generate records, send records to db – use as few COMMIT stmts as possible. BPC420 P.392

345
Q

which is better reducing data pulled in memor or reducing COMMITs?

A

reducing COMMITs BPC420 P.392

346
Q

what is better way to execute logic? Default or Data Packages

A

Data Packages much better compared to “online execution” / default logic. BPC420 P.393

347
Q

Avoid Save & Refresh when creating input forms

A

Better to have parents and values calculated on-screen that to require a refresh to see the updated value.! BPC420 P.393

348
Q

What is UJFS transaction code?

A

file service for locating logic files in BW BPC420 P.393

349
Q

Which has better performance, *WHEN/*ENDWHEN or *SELECTCASE or IIF?

A

*WHEN/*ENDWHEN BPC420 P.393

350
Q

What are the golden rules for logic scripts?

A

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
Q

Lesson 15: Create Logic Script & Execute

A

Lesson 15: Create Logic Script & Execute BPC420 P.450

352
Q

LO Describe the central execution of logic scripts

A

central execution is to run from data packages with prompts. Online is default logic. BPC420 P.450

353
Q

LO Define How to adapt Packages for Central Execution

A

copy and modify BPC420 P.450

354
Q

LO Explain how to execute a logic script from a button

A

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
Q

LO Illustrate how to create a prompt for variable values

A

ex: PROMPT(TEXT, %VAR_KPIT%, “INPUT VARIABLE VALUE FOR KPI1 AS ABSOLUTE VALUTE”,) BPC420 P.450

356
Q

What is %USER%? %APPSET%? %APP?

A

returns current user, appset, app BPC420 P.451

357
Q

What is syntax for a button? !know cold

A

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
Q

What are pre-requisites to creating butons?

A

add developer tab , enable macro settings BPC420 P.453

359
Q

What do you put in front/behind variable for prompting?

A

$ signs before and after ex: $VAR_KPI1$ BPC420 P.454

360
Q

What is syntax for package prompting? Know cold.

A

ex: PROMPT(TEXT, %VAR_KPIT%, “INPUT VARIABLE VALUE FOR KPI1 AS ABSOLUTE VALUTE”,) BPC420 P.455

361
Q

Lesson: 16 Define Logic Scripts for Allocation

A

Lesson: 16 Define Logic Scripts for Allocation BPC420 P.483

362
Q

Discuss the concept of allocation in BPC

A

See detail questions BPC420 P.483

363
Q

Define the logic elements for allocation

A

See detail questions BPC420 P.483

364
Q

Execute an allocation

A

See detail questions BPC420 P.483

365
Q

Allocation

A

1 sender to multiple receives 2 frequent top down use 3 complex allocations with very limited instructions BPC420 P.484

366
Q

Where is definition of allocation engine?

A

standard logic scripts BPC420 P.484

367
Q

What are the special commands for allocation?

A

WHAT, WHERE, FACTOR, USING, TOTAL, COUNT – what, where are only 2 required. Others are optional. BPC420 P.484

368
Q

How do you read the allocation script?

A

vertically, each vertical line represents the data selection BPC420 P.484

369
Q

How is time managed in allocation?

A

run separately for each month(base level). Time is referenced when executing. EXCEPT *DIM TIME row BPC420 P.484

370
Q

When do you use *DIM TIME row in allocation?

A

allocate one year’s data to refre to prior year data BPC420 P.484

371
Q

What is WHAT in allocation?

A

source(base members) BPC420 P.485

372
Q

What is WHERE in allocation?

A

target BPC420 P.485

373
Q

What is USING in allocation?

A

allocation factor BPC420 P.485

374
Q

What is TOTAL in allocation?

A

sum, very useful when calculating a percentag USING/total BPC420 P.485

375
Q

What is FACTOR?

A

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
Q

>>>>

A

keyword to reference defintions used to the right BPC420 P.485

377
Q

<<<<

A

keyword to reference defintions used to the left BPC420 P.485

378
Q

What are the WHAT options?

A

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
Q

What is not allowed in WHAT?

A

blank or [ALL], must be base member to use <>. BPC420 P.485

380
Q

What are possible WHERE options?

A

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
Q

What is different between WHERE & WHAT?

A

WHERE can use blank or all. Can also use *APP (ability to write to a different application). BPC420 P.486

382
Q

Examples of USING / FACTOR options

A

-1*USING/100 USING/TOTAL 1+USING USING-1 … BPC420 P.487

383
Q

What if FACTOR is omitted? Allocation

A

defaults to 1 BPC420 P.487

384
Q

What if the arithmetic expression is omitted? Allocation

A

default is multiplication BPC420 P.487

385
Q

Other allocation considerations?

A

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
Q

What are some allocation uses?

A

top down, or aggregate children to a new category. Ex p 490 Asia. BPC420 P.490

387
Q

What is *DIM DOT(R)?

A

identify dimension type BPC420 P.491

388
Q

Lesson 17: Logic Scripts & ABAP

A

Lesson 17: Logic Scripts & ABAP BPC420 P.509

389
Q

Discuss Function modules in BPC

A

assign a function module BPC420 P.509

390
Q

Describe the integration between ABAP & BPC

A

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
Q

BAdI & ABAP

A

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
Q

What is BAdI based on?

A

ABAP (Advanced business Application Programming) BPC420 P.509

393
Q

Are BAdI’s effective?

A

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
Q

START_BADI/END_BADI

A

also calles ABAP programming written using UG_CUSTOM_LOGIC BADI (transaction code SE19) BPC420 P.510

395
Q

What is syntax for BADI?

A

*START_BADI = =…*END_BADI ….filter value of your BADI implementation is the name providedin UJ_CUSTOM_LOGIC_BADI BPC420 P.510

396
Q

What are the optional Parameters of BADI?

A

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
Q

In which section of a transformation file does a BADI go?

A

Options BPC420 P.518

398
Q

What 2 pieces of information are important for ABAP-LOGIC SCRIPT integration?

A

1 technical name (of the filter value of the BADI) 2 business logic (implmented with ABAP coding) BPC420 P.518

399
Q

If you create your own BADI what do you enter as the Enhancement Spot?

A

UJD_ROUTINE BPC420 P.518

400
Q

What is ZDAVY in ABAP?

A

message class, error message text BPC420 P.518

401
Q

Lesson 18: Introducing Member Formulas

A

Lesson 18: Introducing Member Formulas BPC420 P.532

402
Q

Identify the possibility of on the fly calculation

A

use excel or member formulas(with caution) BPC420 P.532

403
Q

Create Member Formulas

A

See detail questions BPC420 P.532

404
Q

What is MDX formula syntax?

A

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
Q

When are dimension member formulas calculated?

A

at run time, refresh or save BPC420 P.532

406
Q

What is a member formula prerequisite?

A

enable on the dimension BPC420 P.535

407
Q

What operatorts are supported by member formulas?

A

addition (+), subtraction (-), multiplication (*) and division (/), as are the MDX keywords BPC420 P.535

408
Q

What is caution with member formulas?

A

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
Q

What is solve order for member formula?

A

>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
Q

What is formula collision?

A

two formulas collide. Solve order determines whicn one dominates BPC420 P.535

411
Q

What are pros & cons of member formulas?

A

Pro: speed, consistency Con: lack flexibility, shared by all models, retrieval performance BPC420 P.535

412
Q

how are solver order numbers derived like 5 or 100 in member formulas?

A

user sets them. Start with >3 as 3 is for measures. http://scn.sap.com/thread/1477159 BPC420 P.535

413
Q

Lesson 19: Create a Planning Business Process Flows

A

Lesson 19: Create a Planning Business Process Flows BPC420 P.555

414
Q

Create a BPF

A

See detail questions BPC420 P.555

415
Q

Run a BPF

A

See detail questions BPC420 P.555

416
Q

What are the benefits of BPF?

A

– 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
Q

What are costs of BPF?

A
  • 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
Q

BPF Process Template

A
  • A sequential grouping of activities to complete a process BPC420 P.557
419
Q

BPF Activities

A
  • The activities for which the logged-on user can perform BPC420 P.557
420
Q

BPF Activity Regions

A
  • The members that an activity is executed by BPC420 P.557
421
Q

BPF Process Instance

A
  • An iteration of a business process flow template that is in active use BPC420 P.557
422
Q

BPF Process monitor

A
  • Users who can monitor the instances of a template BPC420 P.557
423
Q

BPF Performer

A
  • A User(s) or Team assigned to a Dimension. Performers can complete or submit (for approval) activities for example. BPC420 P.557
424
Q

BPF Reviewer

A
  • A User(s) or Team assigned to a Dimension. Reviewers approve or reject submitted activities. BPC420 P.557
425
Q

BPF Workspace

A
  • A tab in the Web Interface with links to activities BPC420 P.557
426
Q

BPF Hyperlink

A
  • A link in a workspace which defines the action that occurs when chosen BPC420 P.557
427
Q

What is the context for each BPF workspace?

A

Each BPF workspace has it’s own context BPC420 P.558

428
Q

how many users can access a BPF activity?

A

multiple BPC420 P.560

429
Q

What is BPF Opening Criteria?

A

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
Q

What are BPF “Process Settings”?

A

contain the general properties of the template. BPC420 P.562

431
Q

What does the square next to the Activity do?

A

copy activity or move up and down. BPC420 P.563

432
Q

What is a BPF driving dimension?

A

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
Q

What is BPF member?

A

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
Q

What is require reviewer in BPF?

A

reviewer must approve or reject BPC420 P.564

435
Q

What is a BPF reviewer?

A

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
Q

What are 3 ways to add contents to the Activity Workspace?

A

Add: hyperlink, Content, New Report. BPC420 P.565

437
Q

What are BPF related actions?

A

guided navigation via hyperlinks. BPC420 P.566

438
Q

What are 3 version types in BPF?

A

Draft, deployed, Inactive. Inactive versions can’t be used. BPC420 P.566

439
Q

What is DRAFT in BPF?

A

draft is default for new template, can be edited or deleted. BPC420 P.566

440
Q

What is Deployed in BPF?

A

draft templates can be “deployed”. An “Instance” can be created for it. BPC420 P.566

441
Q

What are version limits in BPF?

A

for a given template, only 1 draft, 1 deployed, multiple inactive. BPC420 P.566

442
Q

What is a BPF instance?

A

Instance of a template that will be used and archived. BPC420 P.567

443
Q

What are the steps in the BPF “instance “ wizard?

A

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
Q

What activities are available in an “instance” BPF?

A

start, suspend/resume, change assignment, reset, archive, finalize. BPC420 P.569

445
Q

What is “change assignment” in an “instance” BPF?

A

Process Owner and Activity Owners can be changed by selecting the Change Assignment option BPC420 P.569

446
Q

What is “reset” in an “instance” BPF?

A

To reset an instance back to the first activity BPC420 P.569

447
Q

Who can “finalize” an “instance” BPF?

A

You can finalize a process instance if you are the process instance Owner BPC420 P.569

448
Q

How can you report on an archived instance?

A

if Audit of BPF activity is turned on BPC420 P.569

449
Q

What is an S-type template? C-type?

A

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
Q

Owners & reviewers & email notification BPF

A

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
Q

Which program is used to generate email notificaitons in BPF?

A

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
Q

What does a BPF email notification include?

A

• 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
Q

What is BPF integration with work status, task profile, data access profile?

A

permissions need to be set to allow access. Integrated with BPF. BPC420 P.569

454
Q

What are the work state options?

A

• 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
Q

What does status controlled by determine?

A

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
Q

What are the Work status interface methods?

A

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
Q

For BPF Administration, what are two processes?

A

process template, process instances BPC420 P.569

458
Q

Lesson 20: Validating Master Data

A

Lesson 20: Validating Master Data BPC420 P.609

459
Q

Estimate the Validation Concept

A

driver dimension rules are another way to validate data loads in addition to transformation files. BPC420 P.609

460
Q

Describe the customizing for Validation

A

set up in bw see detail questions BPC420 P.609

461
Q

Why does one use master data validation?

A

control special combinations of data selections; are only allowed during loading or saving. – prevent loading of incorrect combinations. BPC420 P.610

462
Q

What is the transaction code for master data validations?

A

UJ_VALIDATION BPC420 P.611

463
Q

How many driver dimensions are permitted in a model?

A

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
Q

How is an AND condition created with driver dimension rules?

A

two rules that collide BPC420 P.612

465
Q

Master Data Validation and driver dimension rules

A

driver dimension rules are another way to validate data loads in addition to transformation files. BPC420 P.613

466
Q

What members can be used in driver dimension rules?

A

range of member, members not yet created(errors, but continue). BPC420 P.613

467
Q

Can you compy a driver dimension validation configuration to another environment?

A

Yes BPC420 P.613

468
Q

What happens if you delete a dimension?

A

The dimension driver validation configuration is deleted with it. BPC420 P.613

469
Q

Dimension driver validations turn on/off on which objects?

A

environment, model, journal, manual planning, Data manager. BPC420 P.613

470
Q

What are three validation switches in driver dimension validations?

A

journal, manual planning, Data manager. All packages for Data manager. Both web and excel for planning. BPC420 P.613

471
Q

How is driver dimension authorization controlled?

A

transaction authorizations S_TRANS object BPC420 P.613

472
Q

How can changes in driver dimensions be tracked?

A

“Audit Module” - stored in underlying validation tables (UFV*) BPC420 P.613

473
Q

Lesson 21: Configure Audits

A

Lesson 21: Configure Audits BPC420 P.625

474
Q

How do you track changes in data and configuration?

A

Audit BPC420 P.625

475
Q

What is a benefit of Audit tool?

A

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
Q

At what levels is auditing available?

A

Activity & Data audition are the 2 categories: admin & user tasks at environment; transaction data at model level. BPC420 P.626

477
Q

What can be tracked using Audit?

A

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
Q

How would a data package be involved in Audit?

A

Use a data package to archive activity BPC420 P.627

479
Q

What are two ways to archive?

A

settings in tool & data package “archive activity”. BPC420 P.630

480
Q

Where can you view failed audit log updates?

A

SLG1 transaction code BPC420 P.630

481
Q

Does a user get notification is audit-run is failing?

A

no BPC420 P.630

482
Q

What are filters to see failed audit logs?

A

Object = UJ, SubObject=UJU BPC420 P.630

483
Q

Where are audit tables & Audit Archive tables?

A

Audit Tables: /1CPMB/appset_prefix+appl_prefix+AD Audit Archive Tables: /1CPMB/appset_prefix+appl_prefix+AD_A BPC420 P.629

484
Q

What is the purpose of security audit reports?

A

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
Q

What are the general security reports available?

A

• Data changes • Comments • Work status • Administration Activity. BPC420 P.631

486
Q

What are the options once security report displays?

A

edit, refresh, print, export BPC420 P.632

487
Q

Whatis work status?

A

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
Q

Lesson 22: Concurrency Locking

A

Lesson 22: Concurrency Locking BPC420 P.646

489
Q

LO Define How Concurrency locking works

A

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
Q

What is Concurrency locking?

A

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
Q

What is default size of data package save?

A

40,000 records. When a save is above 40,000 records it starts creating data packages for saving. BPC420 P.646

492
Q

What is code for changing save data “Package Size”?

A

UJR_PARAM OR transaction cod UJR0 BPC420 P.646

493
Q

What happens if there are locked records?

A

save will fail, cannot “unsave” BPC420 P.647

494
Q

What is a component that does not post delta values?

A

journals don’t post delta, so not packages creates since package size is always 99,999,999 records. BPC420 P.647

495
Q

How is data saved?

A

delta records saved to the cube so packages can be run again. BPC420 P.647

EPM BPC 10.0 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions