BPC420 NW Administration L07 - L22 Flashcards
What is Lesson 07?
Creating Dimensions BPC420 P.85
LO Create dimensions & Members
See Questions. BPC420 P.85
LO Create properties & hieararchies
See Questions. BPC420 P.85
What is the related BW object for Dimension Property?
Integration between dimensions and InfoObjects of type characteristic BPC420 P.85
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
How are dimensions managed?
Define members, create hierarchies, assign properties BPC420 P.85
Do dimensions belong to only one model?
dimensions can be added to one or more models. BPC420 P.85
Are Dimension IDs case sensitve? Unique?
no, yes BPC420 P.87
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
What are dimension description guidelines?
255 char max BPC420 P.88
What does type allow?
Allows you to organize dta within model based on type BPC420 P.88
What is referential integrity?
validates properties of dimension with the IDs of a different dimension, completes during processing. BPC420 P.88
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
Can an environment have multiple dimensions of one type?
Yes, however only one of each of the required types. BPC420 P.88
Which dimension types are required for a model?
A, C, D, E, R, T - BPC420 P.88
What is A-Account?
chare og accounts and measures, stat keys BPC420 P.88
What is C-Category?
Budget, Forecast, actual BPC420 P.88
What is D - Audit?
Data source, used to segregate input data BPC420 P.88
What is E-Entity?
business units, cost center, geographic entity, profit cneter, legal company, region BPC420 P.88
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
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
What is I- intercompany?
contains the intercompany codes for entities, for legal consolidation intercompany matching and elimination. BPC420 P.89
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
What is S-Subtables?
Used to break down account activity or flow. (Opening, Additions, Deletions, Transfers, Ending Balances). BPC420 P.89
What is Subtables important for?
writing business rules that require currency translation amounts to be calculated by account. BPC420 P.89
Whati is T-Time ?
custom time or weekly, monthly, quarterly BPC420 P.89
What is U-User?
Any User-defined dimension for planning process. U1, U2, … BPC420 P.89
Tell about predefined properties?
based on dimension type, a dimension contains pre-defined properties. Add new Properties as desired. BPC420 P.89
Why would one flag “allow dimension formulas”?
to allow creation of member formulas BPC420 P.90
What are two ways to open up the structure of a dimension?
“Edit Structure” in toolbar or hyperlink BPC420 P.90
What do properties do?
define behavior of dimension members BPC420 P.91
What are some powerful features of properties?
member lookup, formulas, data manager selections, reporting, filtering, BPC420 P.91
What are 3 ways to use properties for a region?
1-filter & sort 2-logic 3-defined report format BPC420 P.91
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
What is max length of Property ID?
20 char BPC420 P.91
What is max length of Property name?
40 char BPC420 P.91
What are the required dimension types?
A, C, D, E, R, T - BPC420 P.91
What properties can be modified or removed?
system-generated properties cannot be removed or modified. Othes may be. BPC420 P.92
What are some system-generated properties?
ACCTYPE, RATETYPE, SCALING BPC420 P.92
What properties are generated for all dimension types, but not displayed?
Description, CALC, HIR BPC420 P.93
What is CALC?
indicates whether calculated by formul or is at parent level. BPC420 P.93
What is HIR?
stores the hierarchy IDs associated with the member, H1, H2,.. BPC420 P.93
What are 2 reserved IDs?
SOLVE_ORDER , FORMULA BPC420 P.93
What is SOLVE_ORDER?
a property that defines the order of calculation when calculated members intersect calculated members BPC420 P.93
What is FORMULA property?
optional property that allows you to define dimension member formulas BPC420 P.93
What is max chars for dimension member?
32 in 10.0, 20 in 7.5 BPC420 P.95
What special characters are allowed in Dimension member ids?
_ & - (underscore & hyphen) BPC420 P.95
What is Delete & Revert?
only available if the changes are not confirmed to the dimension members BPC420 P.98
What is the command to change oder of appearance?
“Apply Hierarchy order” - requires that Hiearchy is set up BPC420 P.98
What does the “display” option do in list view?
view property header by name or by ID BPC420 P.99
What does the “display” option do in hierarchy view?
display member id, description, or both. BPC420 P.99
What type of object is a dimension in BW?
InfoObject of type Characteristic BPC420 P.99
What does the “maintain” button in BW show you?
data in InfoProvider, what does it look like? 2 green squares BPC420 P.123
In BW where is the “maintain hierarchies” button?
On the hierarchy tab of the InfoProvider BPC420 P.123
How do you get to view the hieararchy in BW?
InfoProvider, Hierarchy tab, click “maintain Hiearachies” button, double-click yellow bar BPC420 P.123
In BW what does the “Expand Branch” icon look like?
Two triangles pointed down. Shows full hiearachy. BPC420 P.123
What is Lesson 08?
Creating Models BPC420 P.126
LO - Discuss the Creation of a Model
See Questions. BPC420 P.126
LO - Explain Model Page features
See Questions. BPC420 P.126
LO - Outline the do’s and don’ts in BW InfoProviders created in BPC
See Questions. BPC420 P.126
LO- Describe delivered Measure Formulas and define Custom Measures
See Questions. BPC420 P.126
How do you create a model?
Use the six step wizard BPC420 P.128
What are the two main types of model?
Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128
What are the six types of model?
Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128
What are the 2 Data Entry modes for a model?
Periodic or YTD BPC420 P.128
What is general setting for data entry mode?
Periodic BPC420 P.128
When is YTD data entry mode used?
model with foreign currency conversion. Balances are accumulated/YTD BPC420 P.128
Describe a Standard model
No special requirements, no default business intelligenc/Logic. Create logic as needed. BPC420 P.128
What are the required dimensions for a standard model?
A, C, E, T Account, Category, Entity, Time BPC420 P.128
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
What are the required dimensions for a Financial model?
A, C, E, T, R Account, Category, Entity, Time, Currency BPC420 P.128
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
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
what are three reporting model types?
Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128
What are three Driver & rate model types?
Reporting (Standard, Financial, Consoldiation) & “Drivers and Rates” (Exchange Rates, Ownership, Generic) BPC420 P.128
What do reporting models hold?
financial data BPC420 P.128
All models require which 4 dimension types?
A,C, E,T - Account, category, entity, time BPC420 P.128
What is the special business rule in consoldiations not in standard?
Automatic Adjustments BPC420 P.128
What are the additional required dimensions for consolidation?
D, G, I, R, S, Audit, Group, Intercompany, Currency, Subtables, BPC420 P.128
What is the synonym for subtable?
Flow BPC420 P.128
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
Will Source Data transfer when copying a model?
source data no, data yes, BPC420 P.130
Can you have duplicated diminsion types in a model?
no, exception is user defined which are unique by U1, U2, … BPC420 P.130
When copying a model, where are business rules activated?
in “Business Rules” view. BPC420 P.137
What are control definitions?
Financial and Consolidation type BPC420 P.137
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
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
What is “change type” for a model?
allows a change withint type (Reporting or “Drivers & Rates”) BPC420 P.137
When changing a model type, can you change dimensions?
Yes, add or remove. BPC420 P.139
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
What does Full optimization do?
Sames as light. Plus it checks to see if data model can be improved. BPC420 P.139
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
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
Do both optimizations take the system offline?
Yes BPC420 P.140
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
In which table are dimensions to an application stored?
UJA_DIM_APPL BPC420 P.140
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
Is partitioning available?
not yet because BPC is not using standard SAP time dimension. BPC420 P.142
What is created when an application/model is created?
InfoProvider, MultiProvider, Query, BPC420 P.142
Where can you find the technical name of the InfoProviders?
UJA_APPL BPC420 P.142
Is a new InfoArea created for each AppSet/Environment?
Yes BPC420 P.142
What is the naming convention of InfoProvider?
/CPMB/I BPC420 P.143
What is the naming convention of MultiProvider?
/CPMB/M BPC420 P.143
Whatis the naming convention of Query?
/!!O BPC420 P.143
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
What about the MultiProvider and full optimization?
MultiProvider will automatically point to new InfoProvider. Query & MultiProvider created. BPC420 P.143
What is BW part of a BPC query?
MDX statements are performed against query which is on top of the MultiProvider. BPC420 P.143
What is the BW equivalent of measures?
calculated key figures BPC420 P.144
How many key figures in an InfoProvider?
1…but it is possible to report on multiple “measures”. BPC420 P.144
What are the three measures delivered with BPC?
Periodic, QTD, YTD BPC420 P.144
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
What are some example custom measures?
Week to Date, Month to Date, Rolling 12 month total, … BPC420 P.144
Where is the measure table?
UJA_Formula BPC420 P.144
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
What does MDX stand for?
Multidimensional Expressions – typically deal with SIGN transformations and TIME calculations for each account type. BPC420 P.145
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
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
What is Lesson 09?
Describing the Security Model BPC420 P.153
LO Discuss the BPC security concept?
See Questions. BPC420 P.153
LO Recognize security conflicts
See Questions. BPC420 P.153
What is Event & Notification function?
create messages and alerts in App or emails. Can contain hyperlinks. Security addresses. BPC420 P.153
What is Content Lifecycle Management (CLM)?
tool that support distribution of content across systems. Security addresses. BPC420 P.155
What is the BW transaction for Manage Users & Roles?
SU01 & PFCG..ABAP user management mechanisms BPC420 P.155
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
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
What kind of security reporting is available?
“Enable Auditing of Administration Activity” BPC420 P.155
What is an Emergency User?
when normal access is not available, log on as SysAdmin or other user with Admin rights. BPC420 P.155
What about SSO & EPM products?
SSO is available, must use same DNS (Domain Name System) BPC420 P.157
What is no longer supported for security?
Windows Active Directory & “CMS” BPC420 P.157
Which security object is in BW?
Task profile. Other are in BPC ABAP tables. BPC420 P.157
What are task rights of System Administrator?
1 - manage environments 2 - Manage Security 3-Use system when offline BPC420 P.157
What are task rights of Secondary Administrator?
Manage dimensions, Edit Content of Public Folder BPC420 P.157
What are task rights of Primary Administrator?
All Tasks (….) BPC420 P.157
What is the limit on Task Profiles?
none, task security is cumulative BPC420 P.160
What are the possible values for “Assigned to” concerning task profiles?
“All Teams” or “Some teams only” – seems outdated. BPC420 P.167
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
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
How is pw saving on client machine disabled?
in BW transaction SPRO / IMG true=enhanced BPC420 P.169
If a technical users is set up, what should be the type?
communciation. “technical” users not required nor recommended. BPC420 P.170
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
Can a “team Lead” be established in team security?
Yes BPC420 P.173
What is a “team lead” used for?
Research BPC420 P.180
What drives security conflict resolution?
Data Access: Write, Read Only, Denied. Write is least restrictive. “Less restrictive” profile wins. BPC420 P.180
What authority do child members have?
Child members always have access level of parent unless otherwise specified. BPC420 P.181
How does hierarchy factor in with a secured dimension?
Ignore H1, H2… BPC420 P.182
What is Lesson 10?
Define Parameters BPC420 P.189
LO Discuss the functional parameters and configuration parameters
See Questions. BPC420 P.189
LO Describe how to customize parameters
See Questions. BPC420 P.189
What are administration parameters?
Administration parameters are used to change or enhance the functionality and configuration of BPC scenario BPC420 P.189
What are the three types of administration parameters?
Functional, Configuration, & System BPC420 P.189
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
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
What is a system parameter?
set by system, mainly flags, cannot be set by user through and Admin UI. EX: AVAILABLEFLAG BPC420 P.190
Which 3 tables contain sytem parameters?
UJA_PARAM (cross environment) & UJA_PARAM_APP (Environment & Model level), UJA_USER_DEF (a few) BPC420 P.190
What are the 3 parameters within Configuration parameters?
Global, Environment, Model BPC420 P.192
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
What does the IMG activity “documentation” & “activity” button look like?
See book. BPC420 P.193
What is an importatant Configuration - Model parameter?
BPC_STATISTICS (monitor system performance) BPC420 P.193
Which 2 tables are useful for monitoring performance?
UJ0_STAT_HDR & UJ0_STAT_DTL BPC420 P.193
How do you enable monitoring of system performance?
BPC_STATISTICS (monitor system performance) BPC420 P.193
What is Lesson 11?
Using the EPM Add-in BPC420 P.199
LO Create an EPM add-in connection
See detail questions BPC420 P.200
LO Describe the features of the EPM add-in ribbon
See detail questions BPC420 P.200
LO Define default values for dimensions with the EPM Context Bar
See detail questions BPC420 P.200
LO Build a simple report
See detail questions BPC420 P.200
What are 7 features of EPM Retrieval?
CADCCPI - Create Reports, analyze data, dynamic formatting, calculations, charts, print and share, Integration. BPC420 P.200
What are 4 features of BPC only?
1 Data Input 2 Planning functions 3 Distribution & Collection 4 Data Manager BPC420 P.200
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
What are the command display options?
Reports, Data Analysis, Data Input, Tools, Data Manager BPC420 P.209
What are the options under Reports Group?
open, save, edit report, new report, report actions, view formats, refresh. BPC420 P.212
What are the options under Data Analysis Group?
Expand, collapse, Keep, exclude. BPC420 P.212
What are the options under Data Group?
save data (save, refresh, validate, change work status), comments, planning, journals. BPC420 P.212
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
What are options under Tools group?
drill through, quick links, offline mode, insert function, options, More (freeze data refresh, acessmemeber properties…) BPC420 P.212
What are 2 ways to adjust the EPM Context & Pane?
Drag and drop, dropdown arrow. BPC420 P.212
Where are default context members set?
Context Options BPC420 P.NA
What is Lesson 12?
Data Manager BPC420 P.248
Explain the Data Manager Package tool and the issues related to it
See detail questions BPC420 P.248
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
Does default logic automatically run when you import data?
most of the time BPC420 P.249
What is Data Manager
import, copy or move data within and across models, export. Supports mapping and complex transformations. BPC420 P.249
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
Run Admin Packages
can view and run packages set to type “admin” BPC420 P.251
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
Edit Transformation files
edit, create, delete, BPC420 P.251
Edit Conversion files
edit, create, delete, BPC420 P.251
Cancel any user packages
NW only. Cancel other user packages. BPC420 P.251
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
Run Packages
run packages that have security folder rights for BPC420 P.251
Edit Package Links
edit, create, delete, BPC420 P.251
Upload Data
upload a data file BPC420 P.251
Download Data
ability to download and preview. BPC420 P.251
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
What is special about NW data packages?
They are technically Process Chains. BPC420 P.252
What is a process chain?
defined beginning and end, sequence of processes, BPC420 P.252
What are dynamic packages?
designed to work without modification BPC420 P.252
Where can you modify packages to behave differently or to perform additional functions?
“Organize Package Lis” BPC420 P.253
Where can process chain templates be displayed and edited?
ABAP transaction RSPC BPC420 P.254
How are delivered process chains activated?
note: delivered process chains must be activated. version changes from “delivered” to “active”. BPC420 P.254
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
What are the custom process types?
IF_RSPC_EXECUTE, IF_RSPC_GET_VARIANT,IF_RSPC_MAINTAIN, IF_RSPC_TRANSPORT BPC420 P.255
Which process type can be omitted in a custom, but not delivered ?
transport BPC420 P.255
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
How can you retract both master & transaction data?
BADI BPC420 P.256
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
From which BW objects is data loaded?
DSO (Data Store Objects) full or delta load. BPC420 P.256
Which objects support full or delta load?
both Delta & full(standard cube, standard DSO, write-optimized DSO). Full Only(virtual & MultiProvider. BPC420 P.256
How can data packages impact performance?
data in temporary tables. “dump” BPC420 P.257
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
What are 4 tasks with packages?
run or shedule, Organize packages into a list, view package status, view schedule status. BPC420 P.257
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
What is Lesson 13?
Data Loads BPC420 P.262
Explain the configuration of flat file uploads
See detail questions BPC420 P.262
Describe the set up of Uploads from BW
See detail questions BPC420 P.262
Install Master Data Upload, hierarchy upload, transaction data upload
See detail questions BPC420 P.262
What is a tranformation file?
1 worksheet, named instructions, sets up rules for reading data from external source BPC420 P.262
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
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
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
What is the transaction code for Badi?
UJD_routine BPC420 P.267
Where does the BADI filter go in the transformaiton file?
Options section BPC420 P.267
What is *COL(A)?
defines a dimension for a field in the data file when there’s no header row. BPC420 P.268
What is *COL(A, B:C)?
defines a dimension for a subset of a field of a data file BPC420 P.268
What is *NEWCOL(A)?
function creates a new field with the given value BPC420 P.268
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
*Str(string)
function adds text string to the members of a column BPC420 P.268
*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
What is the conversion syntax?
Dimension Name = [COMPANY]WorkbookName[!SheetName] -note: items in brackets are optional. BPC420 P.269
What are best practices for conversion files?
one file per dimension, same name as dimension, BPC420 P.270
How do you ignore external data?
*skip in the internal column BPC420 P.270
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
What do you preced Java script with?
js: BPC420 P.270
Can you use javascript with If statements?
yes BPC420 P.271
js:%external%.substring(0,2)
return a Long containing the number of characters in a string BPC420 P.271
js:%external%.length
return the length of the string contained in external BPC420 P.271
js:%external%.replaces(“apples”,”oranges”)
return a string where a substring has been replaced… BPC420 P.271
How do you revalue during upload? Revaluation
use the formula column that is executed during upload. BPC420 P.271
What is CONVERTAMOUNTVVDIM?
points to the formula column for dimension BPC420 P.272
What are three data upload packages?
Append, Import, Import Append (contains 2 overwriting possibilities) BPC420 P.274
For data package how is the target determined?
uses current connection BPC420 P.274
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
what is the process chain for importing master data?
/CPMB/IMPORT_IOBJ_MASTER BPC420 P.278
What are the two operators for “set selection”?
= , BT (between) BPC420 P.278
What is option with “Import Text Node”?
Y, and level. So node and two levels down is level=2. BPC420 P.278
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
What if level is blank/unspecified? Data package.
whole sub-tree is selected by taking the member ID as root. BPC420 P.279
Write Mode: Overwrite
master data that has no data will be deleted, rest is overwritten BPC420 P.279
Update Mode:
master data will be overwritten if the id is the same, new master data will be added. BPC420 P.279
What if Internal format is selected for data package?
no conversion routine is used during the import process. BPC420 P.279
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
What is Javascript replace method?
js: %external%.replace(“-“,”_”) BPC420 P.280
What is JavaScript split and join?
js:%external%.split(‘ ‘).join(‘’) – remove spaces from master data BPC420 P.280
What is process chain for importing hierarchy?
/CPMB/IMPORT_IOBJ_HIER. BPC420 P.281
Can you import partial hierarchy?
Yes, use levels BPC420 P.281
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
Is ParentH* format required?
Yes BPC420 P.283
When preparing hierarchy what must be done?
replace - with _, remove blanks, parenth* BPC420 P.283
What is another option for space replace for hierarchy upload?
js:%external%.toString().replace(/\s+/g,“”) BPC420 P.283
In which section of a transformation file do you write code for removing blanks?
*Mapping BPC420 P.290
What is a text node?
only exists in a hierarchy BPC420 P.300
Lesson 14: Creating Basic Logic Scripts & Online Execution
Lesson 14: Creating Basic Logic Scripts & Online Execution BPC420 P.365
What is online execution of logic?
running in default logic instead of Data Manager packages. Users execute by themselves. BPC420 P.367
Describe the concept of logic scripts
Describe the concept of logic scripts BPC420 P.367
Identify Logic Script Commands
Identify Logic Script Commands BPC420 P.367
Recognize the Golden Rule for Logic Scripts
Recognize the Golden Rule for Logic Scripts BPC420 P.367
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
What is worksheet based logic?
exists in worksheets only BPC420 P.369
What are member formulas?
powerful formulas mostly for account dimension members. BPC420 P.369
What are dimension formulas?
defined at environment level, valid across all models BPC420 P.369
What is a logic script?
calculate, but only at base level members BPC420 P.369
What is a business rule?
table based logic - only for management & legal consolidations. Don’t have to understand scripting. BPC420 P.369
Which business rules are delivered with BPC?
Account transformation, currency conversion, intercompany booking, carry-forward rules, US elminations, validations, automatic adjustments BPC420 P.369
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
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
How do you navigate to Logic?
Rules / Logic Scripts BPC420 P.371
What are 2 types of Logic?
default, other BPC420 P.371
what is default logic?
automatically executed on every write back to the model. BPC420 P.371
What are two files for each logic script?
.LGF(ASCII file), .LGX (compiled, not stored in BPC) BPC420 P.371
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
What is Calcaccount.lgf?
prepare cash flow; run Account Calculation Business Rule BPC420 P.372
What is Consolidation.lg?
run legal consolidation business rule BPC420 P.372
What is Copy_Opening.lgg?
run a balance carry forward business rule BPC420 P.372
What is FX_Trans.lgf?
run currency conversion? BPC420 P.372
What is ICBooking.lgf?
run intercompany reconciliation and difference posting BPC420 P.372
What is ICData.lgf?
run intercompany reconciliation BPC420 P.372
What is ICElim.lgf?
run intercompany reconciliation BPC420 P.372
What is MDXlib.lgf?
library of MDX financial functions BPC420 P.372
What is System_Constants.lgf?
stores constant values for use in scripts BPC420 P.372
What is System_Library.lgf?
basic examples of keywords BPC420 P.372
What is Validation.lgf?
run a validation rule BPC420 P.372
What is scope with logic on save?
scope of query is non-calculated accounts, only specific members sent to BPC420 P.373
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
What is a program for debugging script logic?
UJK_SCRIPT_LOGIC_TESTER - transaction code SE38 (ABAP Editor) BPC420 P.373
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
What are 3 run options on logic tester?
validate, execute, execute (simlulate) BPC420 P.376
What is *WHEN?
trigges use of SQL syntax, used to narrow scope further BPC420 P.376
Wha tis *WHEN * *IS *?
entire section BPC420 P.376
*WHEN ACCOUNT *IS “SalesUnits”
Sales Units account BPC420 P.376
how do you differentiate numeric from text in logic?
use quotes for text Ex: *IS “AVG” vs *IS 10 BPC420 P.376
What if *IS is used without an operator?
= equal is assumed BPC420 P.376
What is limitation with <>?
can only follow with one number. *IS <> 2,3,4 is invalid. BPC420 P.376
What operators are not supported?
AND, OR, NOT, *IS dimension.property BPC420 P.376
how many levels allowed for WHEN/ENDWHEN?
as many as desired BPC420 P.376
What is *REC in logic?
generate a new record BPC420 P.377
What are the paramters of REC() ?
specify what to modify in the original record, generate as many records as want BPC420 P.377
What is FACTOR?
multiplies source by facor BPC420 P.377
What is EXPRESSION?
apply an arithmetic operator ( + - / *) BPC420 P.377
What does second part of record statement do?
tells the value where to post BPC420 P.377
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
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
What ideal case for *COMMIT?
use one and use sparingly as there is a performance impact. BPC420 P.379
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
What is the syntax for *XDIM_MEMBERSET?
*XDIM_MEMBERSET {dimension name} = {member set} Ex: *XDIM_MEMBERSET INTCO = Non_Interco BPC420 P.379
If you want to use calculated members what do you have to do before another formula can use?
*COMMIT to database BPC420 P.379
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
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
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
*FOR / *NEXT
loops BPC420 P.381
*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
*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
*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
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
Which is a much better performer? *SELECTCASE or WHEN/ENDWHEN?
WHEN/ENDWHEN BPC420 P.384
*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
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
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
What is an implied keyword?
available for each dimension %DIMNAME_SET%, %INTCO_SET% or %TIME_SET%. 2 - reads Context BPC420 P.386
What is keyword SET?
refers to the context for the value BPC420 P.386
What is keyword DIM?
syntax: %{DimType}_DIM% BPC420 P.386
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
How can a value outside scope be grabbed? (3)
Expand the scope, use *LOOKUP/*ENDLOOKUP, use *DESTINATION_APP BPC420 P.387
*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
*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
*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
*SKIP_DIM with DESTINATION_APP
skip dimensions in destination BPC420 P.388
*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
How to avoid re-writing logic?
Update the Constants file at Enviroment level BPC420 P.389
What are 2 scenarios for configuring Constants for logic?
1 -Environment level 2 - Configuration of Constants at Model level. BPC420 P.391
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
How can you code A = B+C?
*XDIM_MEMBERSET ACCOUNT = B,C *WHEN * *IS* *REC(ACCOUNT=A) *ENDWHEN BPC420 P.391
How many records load in memory?
as few as possible BPC420 P.391
Logic rule regarding structure?
keep as compact as possible. BPC420 P.391
What 3 actions does *COMMIT trigger?
read records, generate records, send records to db – use as few COMMIT stmts as possible. BPC420 P.392
which is better reducing data pulled in memor or reducing COMMITs?
reducing COMMITs BPC420 P.392
what is better way to execute logic? Default or Data Packages
Data Packages much better compared to “online execution” / default logic. BPC420 P.393
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
What is UJFS transaction code?
file service for locating logic files in BW BPC420 P.393
Which has better performance, *WHEN/*ENDWHEN or *SELECTCASE or IIF?
*WHEN/*ENDWHEN BPC420 P.393
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
Lesson 15: Create Logic Script & Execute
Lesson 15: Create Logic Script & Execute BPC420 P.450
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
LO Define How to adapt Packages for Central Execution
copy and modify BPC420 P.450
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
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
What is %USER%? %APPSET%? %APP?
returns current user, appset, app BPC420 P.451
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
What are pre-requisites to creating butons?
add developer tab , enable macro settings BPC420 P.453
What do you put in front/behind variable for prompting?
$ signs before and after ex: $VAR_KPI1$ BPC420 P.454
What is syntax for package prompting? Know cold.
ex: PROMPT(TEXT, %VAR_KPIT%, “INPUT VARIABLE VALUE FOR KPI1 AS ABSOLUTE VALUTE”,) BPC420 P.455
Lesson: 16 Define Logic Scripts for Allocation
Lesson: 16 Define Logic Scripts for Allocation BPC420 P.483
Discuss the concept of allocation in BPC
See detail questions BPC420 P.483
Define the logic elements for allocation
See detail questions BPC420 P.483
Execute an allocation
See detail questions BPC420 P.483
Allocation
1 sender to multiple receives 2 frequent top down use 3 complex allocations with very limited instructions BPC420 P.484
Where is definition of allocation engine?
standard logic scripts BPC420 P.484
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
How do you read the allocation script?
vertically, each vertical line represents the data selection BPC420 P.484
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
When do you use *DIM TIME row in allocation?
allocate one year’s data to refre to prior year data BPC420 P.484
What is WHAT in allocation?
source(base members) BPC420 P.485
What is WHERE in allocation?
target BPC420 P.485
What is USING in allocation?
allocation factor BPC420 P.485
What is TOTAL in allocation?
sum, very useful when calculating a percentag USING/total BPC420 P.485
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
>>>>
keyword to reference defintions used to the right BPC420 P.485
<<<<
keyword to reference defintions used to the left BPC420 P.485
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
What is not allowed in WHAT?
blank or [ALL], must be base member to use <>. BPC420 P.485
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
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
Examples of USING / FACTOR options
-1*USING/100 USING/TOTAL 1+USING USING-1 … BPC420 P.487
What if FACTOR is omitted? Allocation
defaults to 1 BPC420 P.487
What if the arithmetic expression is omitted? Allocation
default is multiplication BPC420 P.487
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
What are some allocation uses?
top down, or aggregate children to a new category. Ex p 490 Asia. BPC420 P.490
What is *DIM DOT(R)?
identify dimension type BPC420 P.491
Lesson 17: Logic Scripts & ABAP
Lesson 17: Logic Scripts & ABAP BPC420 P.509
Discuss Function modules in BPC
assign a function module BPC420 P.509
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
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
What is BAdI based on?
ABAP (Advanced business Application Programming) BPC420 P.509
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
START_BADI/END_BADI
also calles ABAP programming written using UG_CUSTOM_LOGIC BADI (transaction code SE19) BPC420 P.510
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
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
In which section of a transformation file does a BADI go?
Options BPC420 P.518
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
If you create your own BADI what do you enter as the Enhancement Spot?
UJD_ROUTINE BPC420 P.518
What is ZDAVY in ABAP?
message class, error message text BPC420 P.518
Lesson 18: Introducing Member Formulas
Lesson 18: Introducing Member Formulas BPC420 P.532
Identify the possibility of on the fly calculation
use excel or member formulas(with caution) BPC420 P.532
Create Member Formulas
See detail questions BPC420 P.532
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
When are dimension member formulas calculated?
at run time, refresh or save BPC420 P.532
What is a member formula prerequisite?
enable on the dimension BPC420 P.535
What operatorts are supported by member formulas?
addition (+), subtraction (-), multiplication (*) and division (/), as are the MDX keywords BPC420 P.535
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
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
What is formula collision?
two formulas collide. Solve order determines whicn one dominates BPC420 P.535
What are pros & cons of member formulas?
Pro: speed, consistency Con: lack flexibility, shared by all models, retrieval performance BPC420 P.535
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
Lesson 19: Create a Planning Business Process Flows
Lesson 19: Create a Planning Business Process Flows BPC420 P.555
Create a BPF
See detail questions BPC420 P.555
Run a BPF
See detail questions BPC420 P.555
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
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
BPF Process Template
- A sequential grouping of activities to complete a process BPC420 P.557
BPF Activities
- The activities for which the logged-on user can perform BPC420 P.557
BPF Activity Regions
- The members that an activity is executed by BPC420 P.557
BPF Process Instance
- An iteration of a business process flow template that is in active use BPC420 P.557
BPF Process monitor
- Users who can monitor the instances of a template BPC420 P.557
BPF Performer
- A User(s) or Team assigned to a Dimension. Performers can complete or submit (for approval) activities for example. BPC420 P.557
BPF Reviewer
- A User(s) or Team assigned to a Dimension. Reviewers approve or reject submitted activities. BPC420 P.557
BPF Workspace
- A tab in the Web Interface with links to activities BPC420 P.557
BPF Hyperlink
- A link in a workspace which defines the action that occurs when chosen BPC420 P.557
What is the context for each BPF workspace?
Each BPF workspace has it’s own context BPC420 P.558
how many users can access a BPF activity?
multiple BPC420 P.560
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
What are BPF “Process Settings”?
contain the general properties of the template. BPC420 P.562
What does the square next to the Activity do?
copy activity or move up and down. BPC420 P.563
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
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
What is require reviewer in BPF?
reviewer must approve or reject BPC420 P.564
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
What are 3 ways to add contents to the Activity Workspace?
Add: hyperlink, Content, New Report. BPC420 P.565
What are BPF related actions?
guided navigation via hyperlinks. BPC420 P.566
What are 3 version types in BPF?
Draft, deployed, Inactive. Inactive versions can’t be used. BPC420 P.566
What is DRAFT in BPF?
draft is default for new template, can be edited or deleted. BPC420 P.566
What is Deployed in BPF?
draft templates can be “deployed”. An “Instance” can be created for it. BPC420 P.566
What are version limits in BPF?
for a given template, only 1 draft, 1 deployed, multiple inactive. BPC420 P.566
What is a BPF instance?
Instance of a template that will be used and archived. BPC420 P.567
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
What activities are available in an “instance” BPF?
start, suspend/resume, change assignment, reset, archive, finalize. BPC420 P.569
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
What is “reset” in an “instance” BPF?
To reset an instance back to the first activity BPC420 P.569
Who can “finalize” an “instance” BPF?
You can finalize a process instance if you are the process instance Owner BPC420 P.569
How can you report on an archived instance?
if Audit of BPF activity is turned on BPC420 P.569
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
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
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
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
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
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
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
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
For BPF Administration, what are two processes?
process template, process instances BPC420 P.569
Lesson 20: Validating Master Data
Lesson 20: Validating Master Data BPC420 P.609
Estimate the Validation Concept
driver dimension rules are another way to validate data loads in addition to transformation files. BPC420 P.609
Describe the customizing for Validation
set up in bw see detail questions BPC420 P.609
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
What is the transaction code for master data validations?
UJ_VALIDATION BPC420 P.611
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
How is an AND condition created with driver dimension rules?
two rules that collide BPC420 P.612
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
What members can be used in driver dimension rules?
range of member, members not yet created(errors, but continue). BPC420 P.613
Can you compy a driver dimension validation configuration to another environment?
Yes BPC420 P.613
What happens if you delete a dimension?
The dimension driver validation configuration is deleted with it. BPC420 P.613
Dimension driver validations turn on/off on which objects?
environment, model, journal, manual planning, Data manager. BPC420 P.613
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
How is driver dimension authorization controlled?
transaction authorizations S_TRANS object BPC420 P.613
How can changes in driver dimensions be tracked?
“Audit Module” - stored in underlying validation tables (UFV*) BPC420 P.613
Lesson 21: Configure Audits
Lesson 21: Configure Audits BPC420 P.625
How do you track changes in data and configuration?
Audit BPC420 P.625
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
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
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
How would a data package be involved in Audit?
Use a data package to archive activity BPC420 P.627
What are two ways to archive?
settings in tool & data package “archive activity”. BPC420 P.630
Where can you view failed audit log updates?
SLG1 transaction code BPC420 P.630
Does a user get notification is audit-run is failing?
no BPC420 P.630
What are filters to see failed audit logs?
Object = UJ, SubObject=UJU BPC420 P.630
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
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
What are the general security reports available?
• Data changes • Comments • Work status • Administration Activity. BPC420 P.631
What are the options once security report displays?
edit, refresh, print, export BPC420 P.632
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
Lesson 22: Concurrency Locking
Lesson 22: Concurrency Locking BPC420 P.646
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
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
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
What is code for changing save data “Package Size”?
UJR_PARAM OR transaction cod UJR0 BPC420 P.646
What happens if there are locked records?
save will fail, cannot “unsave” BPC420 P.647
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
How is data saved?
delta records saved to the cube so packages can be run again. BPC420 P.647
