Flashcards in Mega Elite Training Deck (386):
Presentation 2: Consolidation Framework
Presentation 2: Consolidation Framework ME D01 P02 P.2
What are the three models required for consolidation?
Consolidation, Ownership, Rate, InterCompany (optional) ME D01 P02 P.2
What are the steps to creating a consolidation?
1 - create models 2 - Activate Business Rules & Script Logic 3 ME D01 P02 P.2
What are components to each delivered Consolidation Task?
process chain, script logic, business rule ME D01 P02 P.5
What are the delivered functionalities for consolidation?
Balance Carry Forward, Currency Conversion, InterCo Reconciliation, InterCo Balance, Legal Consolidation(elims & adjustment rules, Account Calculation/Transformation/(cash flow functioned), US widely used InterCo Elimination/US Elim rules ME D01 P02 P.5
What parameters must be set after creating an environment?
Set template version(current version for dynamic templates) & "change status" (offline or online) ME D01 P02 P.6
What are 6 purposes of a legal consolidation model?
SUMMARY: journal, TB, CarryFwd, DataControls, CurrConversion, Reporting
DETAIL: defines journal template, stores the initial (pre-consolidated) trial balance records, launches balance carry forward processes, ensures data consistency with controls, launches currency conversion and consolidation processes, reporting for pre/post consolidation financial reports ME D01 P02 P.7
Which 9 dimensions are required for legal consolidation?
A,C,D,E,G,I,R,S,T ---Account, Category, AuditTrail, Entity, Scope(G), InterCo,Currency,Flow(S), Time ME D01 P02 P.8
Which 5 dimensions are required for Rate Model?
A,C,E,R,T -- Account, category, entity, currency, time ME D01 P02 P.9
What are 6 purposes of Ownership model?
Org Structure (hierarchy & data records), METHOD, PCON, PCTRL, POWN
DETAIL: Stores a time dependent representation of the organization structure of the parent company in transactional data records by directly interfacing with the Dynamic Hierarchy
Stores the consolidation method (METHOD) to use as well as the percentage of
consolidation (PCON) , percentage of control (PCTRL) for each of the entities.
Stores the percentage of ownership i.e. POWN. ME D01 P02 P.10
Which 6 dimensions are required for Ownership Model?
A,C,E,G,I,T -- Account, category, entity, Scope(G), InterCo, Time ME D01 P02 P.11
What are 2 general settings for Ownership Model?
Parent/Child property for hierarchy of groups, Non-interco Member in Ownership.
This parameter is used with dynamic hierarchy for legal applications when defining
consolidation hierarchies. The value set here must match the name of property in
GROUPS dimension in the legal consolidation application to store the ownership
Value should be PARENT_GROUP.
This parameter should be a member ID in the INTERCO dimension in the ownership
model if you are using dynamic hierarchies.
For example: I_NONE or ThirdParty ME D01 P02 P.12
What should the value be for Parent/child property for hierarchy of groups?
value should be Parent_Group. ME D01 P02 P.12
What are two settings for Non-interco Member in Ownership?
This parameter should be a member ID in the INTERCO dimension in the ownership
model if you are using dynamic hierarchies.
For example: I_NONE or ThirdParty ME D01 P02 P.12
What are the 7 required dimensions for InterCoMatching model? 1 optional
A,C,D,E,G,I,T, - optional S(Flow) ME D01 P02 P.13
What is IDtype for Flow?
S (Flow) ME D01 P02 P.13
What is IDtype for Scope?
G(Scope) ME D01 P02 P.13
What is Groups (G)/Scope?
Scope in Consolidation and Ownership models. Contains all the relevant groups for which you want to run consolidations. This dimension can also be used in Planning models if needed. ME D01 P02 P.14
What is Intercompany I?
Contains the list of intercompany partners (must be corresponding to existing entities). This dimension can also be used in Planning models if needed. ME D01 P02 P.14
What is DataSource (D)/AudiTrail?
Used to track data origins and segregate input from adjustments from eliminations… SubTable S Flow in Consolidation model Breaks down data by ME D01 P02 P.14
What is CALC?
A system-generated property. It indicates whether the account is calculated by means of a formula or is at a parent level. You can view the property values in the Member selector in the EPM Add-In for Office. ME D01 P02 P.15
HIR: What is the recommended way of creating subaccounts?
hierarchies as opposed to formulas. ME D01 P02 P.15
What is HLEVEL? Which Dim?
C_ACCOUNT - system-generated property. It denotes the hierarchical level of the member. The property values can be viewed in the Member Lookup in BPC for Excel ME D01 P02 P.15
What is RATETYPE? Optional? Which Dim?
C_ACCOUNT - Used for currency conversion (see corresponding business rules). Value is optional and has to be valid account in the R_Account dimension ME D01 P02 P.15
What is SCALING? Which Dim?
C_ACCOUNT - Scaling options are Y or N. Used by EPM Add-In for Office. Value is optional, but if a value is not defined, scaling is unavailable for the associated member ID. ME D01 P02 P.15
What is TYPELIM? Which Dim?
C_ACCOUNT - Used to group accounts by type of behavior. The member can be used in the Eliminations and Adjustments business rules. ME D01 P02 P.15
What is ELIMACC? Which Dim?
C_ACCOUNT - Used to identify the counterpart account on which the elimination is performed (plug account for instance for intercompany balance eliminations). It must be an existing account in the dimension. ME D01 P02 P.15
What is STORED_CALC? Which Dim?
C_ACCOUNT - user-defined identifier for denoting whether the account is calculated by means of a formula or is at a parent level. Valid entries are Y or N (or blank). ME D01 P02 P.15
Which 4 properties are main properties for C_Account?
- ACCTYPE, RATETYPE, TYPELIM,ELIMACC ME D01 P02 P.15
Which 2 properties are main properties for FLOW?
- FLOW_TYPE, DIMLIST ME D01 P02 P.16
What is FLOW_TYPE?
- Defines the type of flow of the dimension- Opening, Closing.. (Consolidation) ME D01 P02 P.16
What is DIMLIST?
- Used to group the Flows for several Business Rules ME D01 P02 P.16
Which 4 properties are main properties for ENTITY?
- CURRENCY, ELIM, INTCO, FX_TYPE ME D01 P02 P.17
What is CURRENCY? Which Dim?
ENTITY - The currency in which local data are entered (Currency Conversion) ME D01 P02 P.17
What is ELIM? Which Dim?
ENTITY - Used to identify elimination entities used in US Eliminations (Consolidation) ME D01 P02 P.17
What is INTCO? Which Dim?
ENTITY - Link to intercompany counterpart ID ; it must be a valid member in the Interco dimension (Consolidation) ME D01 P02 P.17
What is FX_TYPE? Which Dim?
ENTITY - Special currency conversion Rule (Currency Conversion) ME D01 P02 P.17
Which property is main property for INTCO?
- ENTITY ME D01 P02 P.17
What is ENTITY property? Which Dimension?
INTCO - A 20 character field that can either be left blank or contain a valid member name of the Entity dimension associated to the current application. The ENTITY property is validated against the Entity dimension, and blank fields are allowed (Consolidation). dim = INTCO ME D01 P02 P.18
What is special about ENTITY property on INTCO?
- it is validated against Entity dimension. ME D01 P02 P.18
Which 6 properties are main properties for AuditTrail?
- CDDIIO - IS_CONVERTED, IS_CONSOLIDATED, COPYOPENING, OPENINGDATASRC, DATASRC_TYPE, DATASRC_STAGE ME D01 P02 P.19
What is IS_CONVERTED property? Which Dim?
AUDITTRAIL - Y or N. All members of the DATASRC dimension having the property IS_CONVERTED not set to ‘Y’ will be skipped (Currency Conversion) ME D01 P02 P.19
What is IS_CONSOLIDATED property? Which Dim?
AUDITTRAIL - IS_CONSOLIDATED Consolidate that Datasrc (Y) (Consolidation) ME D01 P02 P.19
What is COPYOPENING property? Which Dim?
AUDITTRAIL - COPYOPENING Flag to select whether Datasrc is included in Copy Opening (Y) (Copy Opening) ME D01 P02 P.19
What is OPENINGDATASRC property? Which Dim?
AUDITTRAIL - OPENINGDATASRC Datasrc to be used during carry-forward process (Y) (Copy Opening) ME D01 P02 P.19
What is DATASRC_TYPE property? Which Dim?
AUDITTRAIL - DATASRC_TYPE Input (I), Manual (M), or Automatic (A) (Consolidation) ME D01 P02 P.19
What is DATASRC_STAGE Property? Which Dim?
AUDITTRAIL - DATASRC_STAGE Special setting for multi-level consolidations (Consolidation) ME D01 P02 P.19
What 11 properties are main properties for Category?
OPENING_PERIOD, OPENING_YEAR, CATEGORY_FOR_OPE, RATE_CATEGORY, RATE_YEAR, RATE_PERIOD, FX_DIFFERENCE_ONLY, FX_SOURCE_CATEGORY ME D01 P02 P.20
What is OPENING_PERIOD Property? Which Dim?
OPENING_PERIOD Period to use for Copy Opening (Copy Opening) - CATEGORY ME D01 P02 P.20
What is OPENING_YEAR Property? Which Dim?
OPENING_YEAR Year to use for Copy Opening (Copy Opening) - CATEGORY ME D01 P02 P.20
What is CATEGORY_FOR_OPE Property? Which Dim?
CATEGORY_FOR_OPE Category to use for Copy Opening (Copy Opening) - CATEGORY ME D01 P02 P.20
What is RATE_CATEGORY Property? Which Dim?
RATE_CATEGORY The category from which the rates are read(Currency Conversion) - CATEGORY ME D01 P02 P.20
What is RATE_YEAR Property? Which Dim?
RATE_YEAR The year from which the rates are read. The value can be absolute (2010) or a relative value (-1, -2,+1, + 2). If blank it is the same as the source (Currency Conversion) - CATEGORY ME D01 P02 P.20
What is RATE_PERIOD Property? Which Dim?
RATE_PERIOD The period from which the rates are read. The value can be absolute (DEC, FEB) or a relative value (-1, -2, +1, + 2). If blank it is the same as the source (Currency Conversion) - CATEGORY ME D01 P02 P.20
What is FX_DIFFERENCE_ONLY Property? Which Dim?
FX_DIFFERENCE_ONLY Only the difference is stored (Y) (Currency Conversion) - CATEGORY ME D01 P02 P.20
What is FX_SOURCE_CATEGORY Property? Which Dim?
FX_SOURCE_CATEGORY The category for the source (LC) data. If blank it is the current category (Currency Conversion and Consolidation) - CATEGORY ME D01 P02 P.20
What is OWN_CATEGORY Property? Which Dim?
Contains the name of the category where ownership values will be retrieved (Consolidation) - CATEGORY ME D01 P02 P.21
What is OWN_YEAR Property? Which Dim?
Contains the value of the year to take into account when retrieving Ownership data. The value can be a relative value : +1 or -1 for example of a specific value : 2010 for example. The value is optional. In case no value is entered the system will use the Year of the consolidation process (Consolidation) CATEGORY ME D01 P02 P.21
What is OWN_PERIOD Property? Which Dim?
Contains the value of the year to take into account when retrieving Ownership data. The value can be a relative value : +1 or -1 for example of a specific value : DEC for example. The value is optional. In case no value is entered the system will use the Period of the consolidation process (Consolidation) - CATEGORY ME D01 P02 P.21
Which 10 properties are main properties for Scope/Group?
CONSO_TYPE, CURRENCY_TYPE, DATASRC_LEVEL, ENTITY, STORE_ENTITY, FIRST_CONS_DATE, GROUP_CURRENCY, PARENT_GROUP, STAGE_ONLY, STORE_GROUP_CURR ME D01 P02 P.22
What is CONSO_TYPE Property? Which Dim?
Consolidation type allows defining specific sets of rules for specific groups - GROUP/SCOPE ME D01 P02 P.22
What is CURRENCY_TYPE Property? Which Dim?
G for Group and N for Non Group (only one member should have the „N“ value, it will be used for data entry only) - GROUP/SCOPE - SCOPE ME D01 P02 P.22
What is DATASRC_LEVEL Property? Which Dim?
DATASRC_LEVEL Datasrc ID to use for sub-consolidation eliminations (Consolidation) - SCOPE ME D01 P02 P.22
What is ENTITY (SCOPE DIM) Property? Which Dim?
ENTITY Entity ID to store consolidated results (Consolidation) (audit & compliance purposes, easier creation of reports) - SCOPE ME D01 P02 P.22
What is STORE_ENTITY Property? Which Dim?
STORE_ENTITY Y to store consolidated results on the specified entity – see Entity property (Consolidation) - SCOPE ME D01 P02 P.22
What is FIRST_CONS_DATE Property? Which Dim?
FIRST_CONS_DATE Date of first consolidation (Consolidation) - SCOPE ME D01 P02 P.22
What is GROUP_CURRENCY Property? Which Dim?
GROUP_CURRENCY Must be a valid reporting currency ; can be a list of several currencies (Consolidation) - SCOPE ME D01 P02 P.22
What is PARENT_GROUP Property? Which Dim?
PARENT_GROUP ID of parent group (Consolidation) - SCOPE ME D01 P02 P.22
What is STAGE_ONLY Property? Which Dim?
STAGE_ONLY Storage option for staged consolidations (Consolidation) - SCOPE ME D01 P02 P.22
What is STORE_GROUP_CURR Property? Which Dim?
STORE_GROUP_CURR Value = Y to store on the Group Currency when running Currency Conversion (Consolidation) - SCOPE ME D01 P02 P.22
Which 2 properties are main properties for RPTCURRENCY?
CURRENCY_TYPE, REPORTING ME D01 P02 P.22
What is CURRENCY_TYPE Property? Which Dim?
CURRENCY_TYPEG for Group and N for Non Group (only one member should have the „N“ value, it will be used for data entry only) - RPTCURRENCY ME D01 P02 P.23
What is REPORTING Property? Which Dim?
REPORTING Y or Blank. To specify against which currencies the conversion will be executed. - RPTCURRENCY ME D01 P02 P.23
Which 3 properties are main properties for RPTCURRENCY?
PERIOD, YEAR, MONTHNUM ME D01 P02 P.24
What is PERIOD Property? Which Dim?
The PERIOD property allows you to filter, sort, and report based on the period. - TIME ME D01 P02 P.24
What is YEAR Property? Which Dim?
YEAR The YEAR property allows you to filter, sort, and report based on the year. You should place the YEAR properties in chronological order in the file, in order for the offset function in EPM Add-In for Office to give offsets correctly. - TIME ME D01 P02 P.24
What is MONTHNUM Property? Which Dim?
MONTHNUM 1, 2, 3, … - TIME ME D01 P02 P.24
What are 4 purposes of Ownership Manager?
KW: relationships, hierarchy, method, records
1 DETAIL: Provides a web based interface to allow the business user to set up time dependent relationships between various subsidiaries and organizational units.
2 Each hierarchy is keyed to a specific combination of Category and Time dimension member values.
3 Provides a convenient table entry to define the consolidation METHOD, PCTRL, POWN and PCON of each individual unit.
4 The dynamic hierarchy is stored in the Ownership application as transactional records. ME D01 P02 P.25
How to setup the consolidation framework in order to keep the investment details like no of shares, investment details also in the BPC system ?
"1-Add the relevant accounts in the O_account dimension : number of issued shares, number of owned shares, with and without voting rights
2-Create the corresponding data entry schedule in order to enable users to enter the number of shares owned (using the interco dimension) – data can also be loaded
using a flat file, BW cube…
3-Set up the calculation of ownership percentage based on data entered on owned and issued shares ME D01 P02 P.26"
What is the difference between PCON, PCTRL and POWN ?
"-Percent control represents the percentage of an entity based on voting shares that
other entities own, directly or indirectly. It is used to determine the consolidation
-Percent ownership (also known as the interest percentage) represents the percentage of an entity’s nonvoting shares that other entities own, directly or indirectly
-Percent consolidation is the percentage of an entity’s values that consolidate to its parent
-Direct percent ownership is the percentage of regular nonvoting shares of stock owned by each entity ME D01 P02 P.26"
What is the difference between elimination entity and consolidation entity? Are they the same?
Elimination entity will only store eliminations generated by US elimination business rules while the consolidation entity is the entity storing the consolidated results for each group/sub-group ME D01 P02 P.27
What happens when we use different entities in place consolidation entity?
It allows us to secure only the entity dimension instead of securing both entity and scope dimensions in case sub-consolidors need to access sub-consolidated data. ME D01 P02 P.27
Presentation 3: Consolidation Monitor
Presentation 3: Consolidation Monitor ME D01 P03 P.3
What 4 items does consolidation Monitor track?
Controls, conversion, consolidation, work status ME D01 P03 P.3
What are the 5 prerequisites for Consolidation Monitor?
"Model, ownership structure, work status, controls, task profiles
*Use of a Consolidation type Model
*Define the ownership structure for that period
*Define work status (for work status display)
*Define controls (for control display)
*Assign relevant task profiles ME D01 P03 P.5"
What are the two security tasks for Consolidation Monitor?
View consolidation Monitor, Run Consolidation Tasks ME D01 P03 P.6
What are 3 sections of Consolidation Monitor StartPage?
context, actions, Status ME D01 P03 P.7
What 8 actions are available in Consolidation Monitor?
The following Actions are available (some actions may be grayed out if no entity or a node level is selected)
– Work Status: Open the screen to update work status for the selection. ONLY AT BASE LEVEL.
– Translate: Runs currency conversion
– Consolidate: Runs consolidation
– Display Running Processes: Opens a window that shows which processes are currently running
– Reset: Resets execution status for Currency Translation and Consolidation
– Refresh: Refreshes the current screen
– Show Description: Shows description instead of ID
– View Select between a hierarchical and flat view ME D01 P03 P.8
What 3 steps need to be performed in order to execute Currency Conversion?
1 - set context 2 - select group or entity; click translate 3 - translate dialog box (full or incremental) ME D01 P03 P.10
What is difference in executing translation at group or entity level?
Group uses Group currencies. Entity allows you to choose currency & rate entity. ME D01 P03 P.11
What 2 points are important for Currency Conversion & Consolidation?
KW: Global, No logic
– Member in the Entity type dimension of the Rate application needs to be called GLOBAL (in upper case) for the conversion to group currencies to work properly
– The respective programs for currency conversion and consolidation are called directly. No logic script is called, therefore no custom calculations can be executed. ME D01 P03 P.13
In which 2 modes can Currency Conversion & Consolidation be executed?
Incremental or Full ME D01 P03 P.14
What is incremental vs Full currency conversion or consolidation?
The incremental mode will only execute the program for those entities that were changed since the last execution of the program (this is of course much faster than executing the program for all entities) ME D01 P03 P.14
How does the incremental or full process work?
Every time data is written-back to the system, a timestamp is written to a separate table to keep track of when the data of an entity has last been updated
– When a program runs in incremental mode, it will check which entity has been modified
since it’s last execution and only perform the calculation for those entities, which significantly speeds up the process. ME D01 P03 P.14
When does incremental mode work? When not?
"The incremental mode only works when data has been updated, it does not work in the following cases:
*Rates were changed
*Ownership information was changed
*Business Rules were changed
The program needs to be run in full mode if one of the cases mentioned above has occurred ME D01 P03 P.15"
Where & when can you reset consolidation processes?
Display running processes. If a process has failed, opening this screen will allow this process to be reset (after a certain period), so that it can be executed again.
note: status are set back to To Be Executed if data is entered (for the Entity were data has been entered) ME D01 P03 P.17
Presentation 04: Controls - Controls Administration
Presentation 04: Controls - Controls Administration ME D01 P04 P.3
What is a control? 3 additional points about controls?
A Control is the individual check of data accuracy and consistency.
Controls replaces the Validation Business rules used in prior version.
Available only in the NW version.
Controls are enabled or disabled at model level. ME D01 P04 P.3
Are controls available in Planning?
Yes ME D01 P04 P.4
Why are controls used?
Consistency. They are mainly used to control the consistency of financial data (for example that a Balance Sheet is balanced or that flow movements are matching the with the closing balance) ME D01 P04 P.4
What are two ways of enabling controls?
blocking or warning. Controls can be enforced (blocking controls) or just displayed as warnings, to inform users of potential problems. ME D01 P04 P.4
What are 2 benefits of controls?
Consistency of data & Flexibility Note: 1. Different level of controls can be defined by entity. 2. control sets are assigned by Category and Time ME D01 P04 P.5
What are 7 steps required to define controls?
KW: Tasks, Enable, define individual, create, Assign(C,T)---Entity Dimension(Level, LC?)
The following steps are required to define controls
1. Assign Security Tasks related to Controls
2. Enable Controls
3. Create individual controls (and definition of the level for each control)
4. Create Sets of controls (group of controls)
5. Assign a set of controls by category and time
On top of that, two more attributes need to be set in the Entity type dimension
1. Define for each entity the level of control that should be applied
2. Possibility to bypass controls in Local Currency (if data are loaded in reporting
currency directly) ME D01 P04 P.6
Which two attributes are required in the Entity type dimension?
– CONTROL_LEVEL (1)
– CTRL_CURRENCY_NOT_LC (1) ME D01 P04 P.7
What is CONTROL_LEVEL? 4 values?
This property controls which level of control is applied for each entity. The following four values are available:
• 1 : Basic
• 2 : Standard
• 3 : Advanced
• 4 : Comprehensive
The default value (blank) is equivalent to “4” ME D01 P04 P.7
What is CTRL_CURRENCY_NOT_LC?
– This property controls whether controls should be executed in the reporting currency instead of LC.
The following two values are available:
o N : Controls are executed in Local Currency
o Y : Controls are executed in the currency defined in the Currency property of the Entity
– The default value (blank) is equivalent to “N” ME D01 P04 P.7
What 2 tasks are related to Controls from an administration point of view?
– Edit Controls definition
– View Controls definition ME D01 P04 P.8
How do you access the different components of Controls (controls, sets, assignments)?
Click on the numbers. Not the hyperlinks on top right of screen for next step. ME D01 P04 P.10
What are 3 sections of a Control Definition?
– The top of the screen contains the buttons to Save, Close and Validate the control
– The header section : specifies the type of control, the threshold and the break-down dimensions
– The detail section : specifies which members are compared ME D01 P04 P.12
What is in header section for a Control definition?
– ID : id for the control, no space allowed
– Type : Blocking / Warning. All blocking controls must pass before the work status can be changed
– Equation type : type of comparison using the equal, different, bigger and smaller operators
– Control Level : Level of this control, linked to the “Control_Level” property of the Entity dimension
– Tolerance Threshold
o In value : absolute value
o In % : percentage is calculated based on the value of the top part
– Breakdown Dimension(s)
o Up to 2 dimensions can be specified as break-down dimensions
o The control will be executed separately for each member of the break-down dimension. In the example of a break-down by Audit on the member ALL_INPUT, the control will be executed for each member below ALL_INPUT (INPUT and INPUT11) in this example
o For a breakdown, the same member must be specified in the top and in the bottom part ME D01 P04 P.13
What is in detail section for a Control Definition?
– Top Part
o Sign: + or -
o Account Member from the Account dimension (parent or base level)
o Flow Member from the Flow dimension (parent or base level)
o Interco: Member from the Interco dimension (parent or base level)
o AuditID Member from the AuditID dimension (parent or base level)
o Multiply select multiply or divide (for the Value specified)
o Value: value to multiply or divide by
– Bottom Part
o Same column as top part
o Year Offset use a different year. Values can be a year (2010) or an offset (+1,-1)
o Period: use a different period. Values can be a period (1) or an offset (+1,-1)
o Category: use a different category (enter ID of category to use) ME D01 P04 P.14
What is a Control document? Why use it?
A document (report or input schedule) can be linked to each control. This will provide a hyperlink for the user, so that when a control fails, the user can open that document to understand where the issues is coming from ME D01 P04 P.15
What is a Set of Controls?
Controls can be grouped into Sets. ME D01 P04 P.19
What are 2 views for assigning controls?
– Categories by Time
– Control Sets by Time ME D01 P04 P.19
Presentation 05: Controls Monitor - Executing Controls
Presentation 05: Controls Monitor - Executing Controls ME D01 P05 P.1
What needs do be defined for EndUser to use controls?
"* Controls need to be defined and assigned in the Administration module
*For Consolidation type application, ownership structure need to be maintained
*Work Status need to be defined in the Administration Module ME D01 P05 P.5"
What 4 tasks are related to controls from and end-user point of view?
"*Reset Control Dismissal
*Dismiss Blocking Controls
*Run Controls ME D01 P05 P.6"
What is the 5 step process overview for Controls?
1. Run Controls
2. Review Controls
3. Identify issues in data
4. Correct Data
5. Re-run Controls ME D01 P05 P.7
What are the 3 selections in Context for Consolidation/Planning when working with Controls?
The selection of the context will define which Category, Time and Groups/Entities
are displayed in the Control Monitor.
*For Consolidation type application, display the Group type dimension (user selects a group
and will get all the sub-groups and entities displayed, according to the definition in the
*For Planning type application, display the Entity type dimension (user selects an Entity and
will get the selected Entity and all its descendants, according to the hierarchy of the Entity
dimension) ME D01 P05 P.8"
What 5 things does Controls Monitor indicate for each entity?
"*Control Set: Control set that has been assigned for this category and period
*Status: Displays status of current control
*Level: Level of control applicable for that entity (linked to the CONTROL_LEVEL property)
*Number of Blocking: How many blocking controls have failed
*Number of Warnings: How many warning controls have failed ME D01 P05 P.9"
What 4 statuses exist for Controls?
"*To be executed: Control needs to be run (has not been executed yet or data have changed since last execution)
*Passed: Control passed successfully
*Failed: Control has failed, data needs to be corrected
*Dismissed: Control was forced to pass ME D01 P05 P.10"
What 4 levels of controls can be assigned to an entity?
"An entity uses all the controls that have been assigned
to that level (and above).
*4: Comprehensive (Default) ME D01 P05 P.11"
How are entities organized in the Controls Monitor?
"An entity uses all the controls that have been assigned
to that level (and above).
*4: Comprehensive (Default) ME D01 P05 P.11"
How do you execute controls for an entity?
highlight the entity or node and click the Run Controls button ME D01 P05 P.13
What do you see after running controls?
After the execution, the status and the number of blockings and warnings are updated. ME D01 P05 P.14
How do you get a detailed view of all control results?
Open Controls Results ME D01 P05 P.15
How do you drill down on a control?
click the arrow on the left of the screen ME D01 P05 P.18
What is Breakdown member in controls?
*The breakdown members indicate which member of the break-down dimension is displayed if break-down has been defined for that control ME D01 P05 P.18
What are equation and result in controls monitor?
*The Equation and Result columns show the calculation that are performed and the result that is calculated ME D01 P05 P.18
What is threshold column in controls monitor
*The Threshold column indicates the threshold that was defined for that period ME D01 P05 P.18
What is type in controls monitor?
*The Type column indicates whether the control is Blocking or Warning ME D01 P05 P.18
What is status in controls monitor?
*The Status column indicates if the control has passed, failed or has been dismissed ME D01 P05 P.18
What is important to note about a report hyperlinked in controls monitor?
Please note that only the Category, Entity, and Time dimensions are passed to the report, the rest of the dimension need to be set manually in the report itself. ME D01 P05 P.19
Is there a possibility to force a control to pass?
Yes, dimiss it. Status will be "dismissed". ME D01 P05 P.20
Presentation 06: Journals
Presentation 06: Journals ME D01 P06 P.1
Is it possible to delete journals and journal templates?
Yes. All journals from a template must be deleted in order to delete the journal. ME D01 P06 P.5
What are 2 global parameters for journals?
enforce balanced journals, allow journals to be reopened ME D01 P06 P.7
What are 2 journal template display features?
balanced by entity, "balanced by currency" ME D01 P06 P.10
What can be added to journal headers?
additional headers, text or date specific ME D01 P06 P.11
What are reopen rules permitted?
A,S,I(Account, flow, interCo)The reopen rule allows you to identify specific Account(s) (and account properties), Flows, and Interco dimension values to determine source journal entries to be reopened (Source). The filtering property on the account Source dimension can be selected from the dropdown list provided. ME D01 P06 P.12
What is available when a journal is reopened?
Once reopened, the journal entries can be reposted to a new (Destination) Account, Flow, Interco dimension entry. Sign reversal of the value upon reopening is also available. ME D01 P06 P.12
What do you see on journal landing page?
journal count, additional header count, reopen logic(Y/N) ME D01 P06 P.13
How many journal templates can you have for a model?
ONE ME D01 P06 P.13
What are two ways of entering journal entries?
via web or Excel add-in ME D01 P06 P.14
What are two methods for viewing a set of journals?
Context bar or Advanced Query ME D01 P06 P.16
What are 4 options available in Advanced Query for journal entries?
"Essentially all is searchable.
What options are available for Journal template security?
The ability to manage, view, edit, post/unpost, reopen, lock/unlock are all controlled by specific tasks assignments in BPC security: ME D01 P06 P.18
What are 3 ways to create journal entries?
"single, multiple header, multiple value…
*Single journal entry
*Using multiple headers to generate a group of individual journal entries
*Using multiple values for various dimension selections in the journal body ME D01 P06 P.22"
What is a characteristic of multiple header journal entry?
KW: common values with multiple header
Using multiple headers will generate a group of individual journal entries with common values but different header selections: ME D01 P06 P.24
What is a characteristic of multiple value journal entry?
Using multiple values expands the journal entry screen based upon the dimension selected for multiple entry: The result is an expanded journal entry section allowing separate entries for each of the selected dimension members: Using multiple values will generate a group of individual journal entries with potentially different values but the same header selection. ME D01 P06 P.25
What are 3 sub tabs of journal entry?
Journal Entries, Additional Properties, Multi Posting ME D01 P06 P.27
What is the journal entry sub-tab?
The Journal Entry sub-tab allows the user to directly input journal postings, the system automatically provides a running summary of the accumulated values entered. ME D01 P06 P.27
What is the additional properties sub-tab in a journal entry?
allows the user to enter and additional property fields defined in the template. Date selector useful for banking industry. ME D01 P06 P.28
What are 6 journal creation statuses?
Saved, deleted, Posted, Unposted, Locked, Unlocked? ME D01 P06 P.30
Regarding Journal creation status, what is saved?
• Saved - journal has been saved but journal entries have not been committed to database ME D01 P06 P.30
Regarding Journal creation status, what is deleted?
• Deleted – journal has been deleted, the system retains this information to prevent any subsequent reuse of journal ids. ME D01 P06 P.30
Regarding Journal creation status, what is posted?
• Posted - journal entries have been committed to database ME D01 P06 P.30
Regarding Journal creation status, what is Unposted?
• Unposted - - journal entries previously committed to database have been reversed with offsetting postings made in the database ME D01 P06 P.30
Regarding Journal creation status, what is locked?
• Locked – journal entries have been posted and the data is locked from any additional changes. Journals cannot be unposted or deleted with a Locked status. ME D01 P06 P.30
Regarding Journal creation status, what is unlocked?
• Unlocked – A locked journal can be unlocked by an administrator with the Lock/Unlock security task assignment. Unlocking a journal sets its status to posted. ME D01 P06 P.30
When a journal is unlocked, what is the new status?
posted ME D01 P06 P.30
What is an advantage of Journal BADI over journal.lgf logic?
able to leverage fields that journal.lgf does not access ( additional items, date fields, etc) ME D01 P06 P.31
What is a Journal BADI?
when saving or posting an ABAP BADI can be triggered to create additional calculated records. ME D01 P06 P.31
How is the journal BADI delivered?
empty, but customizable by client ME D01 P06 P.31
What are 3 options on journals?
balanced, reopen in next period, auto reverse ME D01 P06 P.32
Presentation 07: Ownership Manager
Presentation 07: Ownership Manager ME D01 P07 P.1
What is Ownership Manager fka?
Dynamic Hierarchy Editor ME D01 P07 P.3
What is Ownership Manager?
a transaction data based representation of an organizational hierarchy as well as defining consolidation parameters. Fka DHE (dynamic hierarchy Editor) ME D01 P07 P.3
What are 3 key dimensions of Ownership Manger?
Category, Time, Scope. ME D01 P07 P.3
What does the use of 3 dimensions in Ownership Manager allow?
Category, Time, and Scope. This allows multiple organizational structures to be created to support dynamic ownership situations (such as acquisitions, divestitures, changes
in existing positions, etc.). ME D01 P07 P.3
What does Ownership Manager require?
an Ownership model. Required dimension must be the same as those in the Consolidation Model (C,E,G,I,T). Account provides ownership type such as PGROUP, POWN, PCON, PCTRL ME D01 P07 P.4
What are three security tasks for Ownership Manager?
View, Edit, Run Ownership Calculations ME D01 P07 P.5
What is Financial Interest Rate in ownership?
POWN ME D01 P07 P.8
What are 3 variables in Ownership?
Consolidation Method, Consolidation Rate, Financial Interest Rate ME D01 P07 P.8
How do you run internal program that determines the "generated" values for Consolidation Rate and Financial Interests
Calculate ME D01 P07 P.17
What is the METHOD business rule definition?
PCTRL_SYS generated by Ownership Calculation is compared to the "share range" to determine 2 things (METHOD_SYS and PCON_SYS) ME D01 P07 P.18
What is Direct Share & Group Share calculation?
Direct (no mod) or Group(multiply rates) - don't combine or combine (PCTRL_SYS & POWN_SYS) ME D01 P07 P.19
What is BR Share?
business rule share for ownership? ME D01 P07 P.20
How is METHOD_SYS determined?
BR share range lookup ME D01 P07 P.20
How is PCON_SYS derived?
BR share range lookup ME D01 P07 P.20
How is POWN_SYS derived?
POWN_SYS is derived from the ultimate ownership percentage calculation using the selected share method (Direct/Group) and the POWN values entered in the Cross Ownership Schedule ME D01 P07 P.20
What is UPO?
Ultimate Parent Organization ME D01 P07 P.24
Direct or Group. Which results in higher ownership%?
Direct does since you don't multiply and dilute the ownership. ME D01 P07 P.24
Exercise 01 ME D01 E01 P.1
What are two roles required in NW to create a user? Transaction code?
SU01 -- /POA/BUI_FLEX_CLIENT & /POA/BUI_UM_USER KW: flex client and user ME D01 E01 P.23
Drill Through ME D01 E01 P.37
How can you further analyze a BEX query result?
Click the icon with the arrow on it ME D01 E01 P.45
What are 2 file extensions for Dashboards in BPC Web Portal?
.swf & .xlf -- generated using Dashboard Design software ME D01 E01 P.194
Exercise 02: Overview Consolidations
Exercise 02: Overview Consolidations ME D01 E02 P.1
When US Eliminations is run what does system look for in entity hierarchy?
First common parent, then it looks at immediate descendants for an elimination entity (ELIM=Y property in Entity dimension). ME D01 E02 P.17
What C_ACCOUNT is used for eliminations?
USELIMDIFF ME D01 E02 P.18
What are 4 main columns in Ownership Manager Entity Editor?
Consolidation Method, Percent Consolidation, Percent Control, Percent Ownership ME D01 E02 P.24
What is generated vs system in Ownership Manager?
Generated, is a system proposal for these parameter values that can be accepted or manually overwritten in the current column ME D01 E02 P.24
What is needed for Ownership Manger to propose values for "Generated" column?
The system will first need to understand the ownership relationships between the holding company and the various subsidiaries. This information can easily be entered via an input schedule . ME D01 E02 P.28
What are 3 ways to input Ownership Information?
Input Schedule, Data Manager import, "Current" fields in Ownership manager. INPUT SCHEDULE IS BEST since it is readily available to system. ME D01 E02 P.28
When you enable "Overwrite current ownership values with calculated values", what does system do?
copies the values from "generated" to "current" ME D01 E02 P.33
What does enabling "Update Method" do?
calculates the system "generated" value ME D01 E02 P.33
What does enabling "Update % Consolidation" do?
calculates the system "generated" value ME D01 E02 P.33
What does the "multiple header" option allow a user to do?
to create more than one journal with each journal containing the same header combination. This technique makes the generation of many journal entries much more efficient for the user, as well as allowing the grouping of similar journal entries together for potential mass (group) processing. ME D01 E02 P.44
What does the "Multi Posting" tab determine?
View Multi Posting Tab to determine which header values will be used for this multiple header journal. ME D01 E02 P.44
When journals are grouped what do you see?
Group ID has a value ME D01 E02 P.47
How do you create a "Control Set"?
click "edit Sets" ME D01 E02 P.56
Why do you need to "set assignments" for controls?
Set is only executed for the category and time specified. ME D01 E02 P.57
6 Methods (3 major) for GAAP reporting of investees?
Fair Value, Equity, Consolidation(Acquisition, Purchase, Pooling) ME D02 P01 P.5
What is Fair Value Method of investment accounting?
"Investments that are either for re-sale (“held-to-maturity” or “trading”) or that are held (“available-for-sale”) with unrecognized gains in losses reported as separate equity item (under other comprehensive income)
*Dividends recognized as income ME D02 P01 P.6"
What is Equity Method?
Investments where investor has ability to “significantly influence” investee (APB 18)
• Investor recognizes its share of the earnings or losses of an investee in the periods for which they are reported
• Share of the earnings or losses adjusts parent investment and reports the recognized earnings or losses in income.
• Cash dividends reduces reversed to avoid double counting ME D02 P01 P.7
What is Acquisition Method?
Under acquisition method, investment is eliminated against equity and the portion of equity not attributable to parent is created in the equity section as non-controlling
interest (FAS 160)
Example journal entries:
Debit Capital Stock
Debit Retained Earnings
Credit Non-Controlling (Minority) Interest
Credit Investment in Investee ME D02 P01 P.8
What are method codes? 3 types
Method codes are freely configurable but must be assigned to one of the predefined method types:
1. ‘H’ for parent investors or holding entities
2. ‘G’ for subsidiaries that are to be financially consolidated with parent
3. ‘E’ for equity method investees ME D02 P01 P.12
Where are method codes located?
Business rules/Global Definitions/Methods in administration. ME D02 P01 P.13
Equity method vs Consolidated Statements
Difference between equity method and consolidated financial statements
Equity method does not combine balance sheet and income statements with parent but rather recognizes share of investee income ME D02 P01 P.14
What is the Equity adjustment type?
To reverse equity method investee financial statements a special Adjustment Type in Business Rules is used ME D02 P01 P.15
How are intercompany eliminations posted?
Eliminations are posted against an elimination clearing account for automatic adjustment rules within their own data source ME D02 P01 P.18
What are 3 types of inter-entity eliminations?
Automatic Adjustments, US Eliminations, Intercompany Bookings ME D02 P01 P.19
What are automatic adjustments?
Contribution model -- approach Eliminates trading partner (intercompany dimension) pairs and also handles. Doesn't use an Elimination ENTITY. Does it with IntCo and existing ENTITY. ME D02 P01 P.19
What are US Eliminations?
Elimination entity or “first common parent” approach --Eliminates trading partner combinations on a common elimination entity. Uses ENTITY = Elimination. ME D02 P01 P.19
What are Intercompany Bookings?
Subsidiary reconciliation approach-- For reconciliation reporting, copies trading partner details onto each entity for secured reporting purposes ME D02 P01 P.19
What are 4 things to know about InterCompany (IC) Matching?
"KW: enable, expedite, copy, separate, currency, work status.
*Designed to enable subsidiaries to do their own intercompany reconciliation
with peers to expedite corporate reconciliation
*Copies the trading partner side of eliminations onto the receiving entity for secured reporting purposes
*Designed as a separate application with specific data sources to facilitate intercompany reconciliation
*Consider a separate application for IC matching; facilitates adding additional transaction currency dimension and having separate work status definitions ME D02 P01 P.20"
What is BS translated at?
Month end Spot ME D02 P01 P.24
What is IS translated at?
Average Rate ME D02 P01 P.24
What is a CTA?
Currency Translation Adjustment Retained earnings translated at both historical and average rates causing the balance sheet to be out-of-balance and necessitating an equity plug (i.e. “CTA” or “Currency Translation Adjustment”) ME D02 P01 P.24
How is Retained Earnings both month end & average?
Opening RE is historical rate, Current period RE is at avg rate. ME D02 P01 P.24
When cost is in excess of book value, what are 2 ways to handle?
1. Assets that are undervalued on the investee’s books must amortize fair value differences over the remaining useful life of the asset (lest the asset life is indefinite)
2. Goodwill remains without adjustment until the investment is disposed ME D02 P01 P.26
Which dimension carries Rate type property?
Account ME D02 P01 P.30
Which dimensions drive currencies in consolidation?
Entity drives source currency and Group drives target currency ME D02 P01 P.31
How are currency rates determined?
by a base currency ME D02 P01 P.32
How is consolidation percent ownership referenced for minority interest?
ACCOUNT & elimination Code --> Source Account (Elim & Adj Rule)
Multiplier (Elim & Adj Rule) --> ID (method based multiplier rule)
POWN (method based multiplier rule) ---> Ownership ME D02 P01 P.34
What is Purchase Method?
"*Investment and Equity Eliminations
*Calculation and Posting of Non-Controlling Interest
*Calculation and Posting of Goodwill ME D02 P01 P.43"
What are 4 steps of consolidation system?
prepare, collect, consolidate, report ME D02 P02 P.3
What are preparation steps?
Dimensional Model, Master Data, Business Rules/Configuration, Security, IC, Ownership Manager, Rates ME D02 P02 P.3
Where are collect steps?
manual entry, file upload, ERP integration, controls, currency translation ME D02 P02 P.3
Where are consolidate steps?
IC eliminations, LT investments/Scope Changes, Reclassification, Allocation ME D02 P02 P.3
What are two types of reports?
Management and Statutory ME D02 P02 P.3
What are 4 consolidation properties on ACCOUNT?
Acctype, elimacc, typeelim, ratetype ME D02 P02 P.8
Where are 4 consolidation properties on ENTITY?
Currency, Owner, Elim, control level ME D02 P02 P.8
What are 6 consolidation properties on SCOPE?
CONSO_TYPE, CURRENCY_TYPE, ENTITY, STORE_ENTITY, GROUP_CURRENCY, STORE_GROUP_CURRENCY ME D02 P02 P.8
What are 5 consolidation properties on AUDITRAIL?
COPYOPENING, DATASRC_TYPE, IS_CONSOL, IS_CONVERTED, OPENING_DATASRC ME D02 P02 P.8
What are 4 consolidation properties on CATEGORY?
FX_SOURCE_CATEGORY, OWN_PERIOD, OWN_YEAR, RATE_CATEGORY ME D02 P02 P.8
What are 2 consolidation properties on O_ACCOUNT?
IS_INPUT, special _SYS dimension ME D02 P02 P.8
What is 1 consolidation property of R_ACCOUNT?
RATETYPE ME D02 P02 P.8
What is 1 consolidation property of INPUTCURRENCY?
MD ME D02 P02 P.8
What are 4 elements of Ownership Manager?
METHOD, PCON, PWON, PCTRL ME D02 P02 P.10
What is METHOD?
METHOD identifies the consolidation method associated with the entity as defined within the ownership hierarchy. The METHOD values are directly connected to the methods defined within the “Methods” business rules. ME D02 P02 P.10
What is PCON?
PCON stores the percent of consolidation for the selected entity. This is the percentage that will be applied to the records requiring consolidation. For example, if PCON is 75% and the data value is 400, this record will consolidate 0.75 * 400 = 300. ME D02 P02 P.10
What is POWN?
POWN is also known as the ultimate percent ownership of an entity by the holding company. It is the calculated share percentage based upon a specified calculation method (Direct Share or Group Share). For the Direct Share calculation, the percent ownership is assumed to be 100% of the subsidiary ownership. For Group Share calculations, the percent ownership is the product between the various subsidiaries percentages. POWN is used internally by the ownership manager calculation engine to determine POWN_SYS based upon the financial process selected by the user (i.e.: Direct Share or Group Share calculation). ME D02 P02 P.10
What is PCTRL?
PCTRL identifies the ultimate percent of control for each entity in a model. This value may differ from POWN, for example if 60% of outstanding shares of a subsidiary is owned, the control on that company may be greater than 60% (it may be 100%, for example). PCTRL is used internally by the ownership manager calculation engine to determine METHOD_SYS and PCON_SYS selections from the METHOD business rule. ME D02 P02 P.10
What are 4 processes in Consolidation Monitor?
Control status, work status, currency translation, Consolidation calculation ME D02 P02 P.11
What is a business rule?
Business rules are parameter-driven functions within Planning and Consolidation models used for calculating and posting monetary amounts in support of common accounting activities. ME D02 P02 P.12
What does Purchase Method business rule do?
calculation group and minority interest ME D02 P02 P.13
What does Goodwill do?
Calculate cost over book value ME D02 P02 P.13
At what entity & currency level are controls executed?
LC and base level entities ME D02 P02 P.14
Are controls a predecessor to consolidation?
yes, controls must be executed prior to running consolidation ME D02 P02 P.14
What are control sets?
groups of controls. Controls Sets can be assigned to specific intersections of TIME/CATEGORY combinations. ME D02 P02 P.14
How are controls assigned a control level?
Controls can be assigned a control level which can be used to determine which control rules are executed for a specific Entity. The selection of the control level to be employed by an Entity is defined in the master data property CONTROL_LEVEL: ME D02 P02 P.16
What are 4 control levels for controls? Where assigned?
Basic, standard, advanced, comprehensive --- "control_level" property on Entity. ME D02 P02 P.16
What is SAP BO Intercompany?
SAP Business Objects Intercompany is a web-based application enabling business units to reconcile:
- intercompany balances (account level) and
- invoice level transactions
It is a pre-consolidation tool used to accelerate FINANCIAL CLOSE. ME D02 P03 P.9
What is one way of incorporating BO Intercompany?
source -->IC --> BPC --> adjustments back to source ME D02 P03 P.8
What is BPC Disclosure Management?
Post Consolidation results are typically required to be entered into a final official publication for external consumption. Disclosure Manage provides the means for taking this post consolidated data and assembling a complete publishable report. ME D02 P03 P.16
What is first step of Disclosure Management?
Extract post consolidated data from BPC and send to DM application. ME D02 P03 P.3
What are three benefits of Disclosure Management?
Reduce the Time, Risk and Cost of Regulatory Disclosures ME D02 P04 P.5
What are 12 points about Disclosure Management?
"Speed and flexibility
*Accelerate the generation of disclosure statements
*Integrate data for a single view of the organization
*Optimize the close from source to digital disclosure
*Assign disclosure responsibility to distributed teams
*Automate integration and data flow
*Designed for ownership by finance professionals
Compliance and control
*In-house production of trusted financial statements
*Support multiple financial and regulatory statements
*Enable creation of XBRL-based statements ME D02 P04 P.8"
What is some of the functionality of Disclosure Management?
"*Automated Integration with Data Sources
– Data Source Link Synchronization
*Ability to Manage Financial Data and
– Create Reports
– Upload Financial Data
– Compare Versions
*Monitoring and Cockpit Views
*Validation of Mappings
*Instance Document Creation (XBRL/iXBRL)
*Taxonomy Design and Management
*Multiple Output Formatting
*Report Support (10K/10Q/20F)
*Reusable Reports (Roll-forward) ME D02 P04 P.8"
Does BPC contain BO Intercompany?
Yes ME D02 P05 P.16
Legal Entity vs Management Entity for IC data
Consolidation concern legal entities, for reconciliation purpose however, companies may need to do matching at management entity level. For existing SAP BusinessObjects Financial Consolidation and SAP BusinessObjects Planning and Consolidation it may be costly or require some set up modification to allow reconciliation at management entity level. ME D02 P05 P.39
Is Intercompany a standalone application?
Yes ME D02 P05 P.40
What is an implementation time for BO Intercompany?
4 weeks ME D02 P05 P.41
What is integration between BPC and BO Intercompany?
Balance export between SAP BusinessObjects Intercompany and SAP BusinessObjects Planning & Consolidation has to go through an export file. This exported file can then be picked up by FIM (Financial Information Management) or by Data Integrator in BPC. ME D02 P05 P.43
What is a Model in BW?
InfoProvider ME D03 P01 P.5
What is a dimension in BW?
InfoObject ME D03 P01 P.5
What is a member in BW?
Characteristic value ME D03 P01 P.5
What is a property in BW?
Attribute ME D03 P01 P.5
What is a hierarchy in BW?
hierarchy ME D03 P01 P.5
What is text in BW?
text ME D03 P01 P.5
What is signed data in BW?
Key Figure ME D03 P01 P.5
What is measures in BW?
calculated key figures ME D03 P01 P.5
RSA1 Admin Workbench ME D03 P01 P.7
RSDCUBE InfoCube editing ME D03 P01 P.7
RSDMPRO Initial Screen: MultiProvider Proc. ME D03 P01 P.7
LISTCUBE List viewer for Info Cubes ME D03 P01 P.7
RSINPUT Manual Input of Data into Cube ME D03 P01 P.7
RSOR BW Metadata Repository ME D03 P01 P.7
RSMO Data-Load-Monitor Start ME D03 P01 P.7
RSRQ Data Load Monitor for a Request ME D03 P01 P.7
RSPC Process Chain Maintenance ME D03 P01 P.7
RSA2 Datasource Repository ME D03 P01 P.7
RSA6 Maintain DataSources ME D03 P01 P.7
RSRT Query Monitor ME D03 P01 P.7
RSBBS Query Jump Targets ME D03 P01 P.7
RSZC Copy Queries between cubes ME D03 P01 P.7
RSZDELETE Delete queries and workbooks ME D03 P01 P.7
RSBBS Query Jump Targets ME D03 P01 P.7
What is transaction code to view BW transaction codes?
SE93 *RS codes ME D03 P01 P.11
Modeling– you create/maintain all of the key BW objects here, such as: ME D03 P01 P.11
Info Providers – cubes, data store objects (DSOs), Multi-providers, virtual providers, etc. ME D03 P01 P.11
Info Objects – Characteristics (BPC Dimensions) and Key Figure (SignData)definitions ME D03 P01 P.11
InfoSource - prepares consolidated data from multiple sources for updating to the data targets ME D03 P01 P.11
DataSource - used to extract data from a source system and to transfer the data to the BW system ME D03 P01 P.11
Source Systems – define general connection settings between SAP/Non-SAP systems and BW ME D03 P01 P.11
What is in BW Administration?
Administration – monitor BW operations (Admin Cockpit), broadcast reports, view logs and exceptions ME D03 P01 P.12
What is in Transport Connection?
Transport Connection – create BW and BPC transports (new in BPC10) transports. ME D03 P01 P.13
What is in BI Content section of BW?
BI Content – contains all of the “delivered” objects from your BW installation. Specific objects can be selected and activated so they can be available in your system ME D03 P01 P.15
What is in Translation section of BW?
Translation– translate short and long texts for Business Information Warehouse objects ME D03 P01 P.16
What is an Extractor?
•Extractors are used to move data from any source into the BW system ME D03 P01 P.17
What is in InfoPackage?
•InfoPackages are used to move data from source system to PSA ME D03 P01 P.17
What is a transformation in BW?
•Transformations are built to map the fields between the source and target ME D03 P01 P.17
What is a DTP (Data Transfer Process) in BW?
•Data Transfer Processes (DTPs) are used to move the data from the PSA to Target (i.e. characteristic or info provider) ME D03 P01 P.17
What are several options to accelerate the data loading speed?
• Architect for delta loading
• Increase load frequency
• Leverage real-time daemon in SAP NetWeaver BW ME D03 P01 P.19
Is BW a multi key figure model? BPC?
yes, BPC is single. ME D03 P01 P.25
What are 2 DSO's used for Delta Load process into BPC?
Full Snapshot and Deltas Only. ME D03 P01 P.29
What is high level Delta Load Process?
source --> DSO--> cube --> Full snapshot DSO --> Deltas Only DSO ME D03 P01 P.31
What is load setting for delta load? Merge or Replace? Why?
BPC will calculate the appropriate record offset natively with the “Merge” type load.
The “Merge” type load into BPC is used since the “final value” of the record will be delivered to BPC. This means we are not actually loading the “difference” but rather the “final” value of each record. The filters applied on the DTP for the Snapshot DSO, selects only the After Image and the New Image change log records. This filtering ensures the records to be sent into BPC are new records at their “final” value (not at their true “delta” value). ME D03 P01 P.35
What is transaction code to access process chains?
RSPC Process Chain Maintenance ME D03 P01 P.36
With a process chain, what if errors?
Can have two paths for errors or success ME D03 P01 P.37
How are process chains initiated?
scheduled or triggered by events (i.e. ECC extract completes) ME D03 P01 P.37
What about Logs & process chains?
Each process chain can generate a log that includes details of the execution ME D03 P01 P.37
What are 2 views for Process chains?
Tree or Network Display --- change view in Settings option ME D03 P01 P.38
What is a link in the chain?
Process types ME D03 P01 P.39
How do you construct a process chain?
drag and drop into the forming process chain. ME D03 P01 P.40
How is the Data Manager prompt file for a process chain stored?
as a program variant ME D03 P01 P.44
What are three programs that can call BPC Data Manger functions from a BW process chain?
UJD_TEST_PACKAGE - run package
UJD_TEST_PACKAGE_LONGPROMPT - allows the assignment of a text file containing large prompt instructions. Required for prompts greater than 1000 characters.
UJD_TEST_PACKAGE_LINK – Package links are Data Manager collections of individual packages to be executed in a sequence. A simple BPC process chain of sorts. ME D03 P01 P.45
Real time processing of chains can be viewed by color
Green, yellow, red ME D03 P01 P.46
What are 5 reporting options?
BEX (Query & Analyzer), LISTCUBE, EPM 10 Add-in (BPC & BW connections) ME D03 P01 P.49
What is LISTCUBE?
BW transaction LISTCUBE allows access directly into the BW InfoProvider. Download into file or excel. ME D03 P01 P.56
When connecting to BW with EPM Add-in what kind of connection is used?
ODBO ME D03 P01 P.63
What is a compounded characteristic for Profit Center? Why?
Profit Center is a compounded characteristic requiring the definition of a controlling area to fully define a specific profit center. BPC does not have characteristic compounding feature, as a result the current best practice is to concatenate both characteristics (Controlling Area and Profit Center) to define a unique profit center key. ME D03 E01 P.35
What are 2 types of rule groups for infoObjects in BW?
Standard, technical ME D03 E01 P.39
What is a typical setting in BW for Aggregation?
Summation ME D03 E01 P.39
What is a typical multiplier for transforming records?
3 x original (dr, cr, 0balance) ME D03 E01 P.49
Before you can display data in DSO what do you do?
activate data ME D03 E01 P.52
Why is/was a shadow DSO for deltas needed for BPC?
full load to BPC is only available in BPC at this time. Future packages will have native delta loading. ME D03 E01 P.56
For a delta extraction to Delta DSO, what are 3 important settings?
full extraction, not parallel extraction, enable change log.
This step is VERY IMPORTANT. DSOs make use of a Change Log to keep track of Delta specific information and it is this Change Log that we are using to load only the Deltas. If you use this option, the DTP will only load the “changed” records from the source DSO and not the entire “active” table – which effectively means we can fill our shadow Delta Only’s DSO with the deltas and not the full load. ME D03 E01 P.56
Are there multiple ways to do Delta Load?
at least 2 with 0RECORDMODE when using MERGE data package. With 0RECORDMODE when you make an append package. ME D03 E01 P.60
What is unique about each process chain?
The start process is unique for each process chain. ME D03 E04 P.3
What is the delivered ABAP program to execute BPC Data Manager from BW?
UJS_TEST_PACKAGE. Execute and can store BPC Data Manager prompts in a program variant. ME D03 E04 P.22
What is an important part of Process Chain?
Answer Prompt. Answer Prompt field represents the
values coming from the Data Manager Package Prompt screens (the values the user enters when executing a
BPC Data Manager Package, such as source InfoProvider, transformation files, and various processing options
(ignoring work status or running default logic) ME D03 E04 P.
Where do you start with loading a FlatFile in BW?
Modeling/Source systems/Files/Create ---then go to DataSources/click Icon(yellow box with X in it)/FlatFile ME D03 E04 P.
When loading data in BW, what is Proposal tab?
load example data, check formatting. - See on Preview tab ME D03 E06 P.
How could EPM - Lock Selected Cells be used? How access?
use it on EPM formatting sheet. Right click/EPM/Lock selected cells ME D04 E02 P.6
What one overrides the other? EPMFormatting or EPMCopyRange?
EPMCopyRange() overrides EPMFormatting Sheet ME D04 E02 P.
How are Dashboard Design & EPM 10 connected?
very tightly ME D04 E11 P.
What does EPMsorting Override allow?
Sorting Override formula in order to sort our input form, based on a property name displayed in the spreadsheet (something not possible from the EPM Add-in interface directly). ME D04 E04 P.15
How, using a formula, can you insert a variance?
EPMInsertCellsBeforeAfterBlock() ME D04 E02 P.20
In BPC_Statistics, what is Mddataset_select_data?
run time for the MDX query (creating MDX piece). ME D04 E08 P.7
What is the RUN_RSDRI_query?
query that just reads the fact tables ME D04 E08 P.11
What is SPRO?
transaction for getting to set parameters to turn on BPC Statistics ME D04 E08 P.2
What is /NUJSTAT?
gets you to performance statistic reports ME D04 E08 P.6
What is new keyword *XDIM_PACKAGEBY?
This new keyword in BPC10 is used to parallelize the actual Script execution in a simple but effective manner. The *PACKAGEBY keyword will break up the execution of the script into separate data regions (semantic partitions) and run them in parallel. This will be done in 4 major steps: ME D04 E01 P.26
What are 4 implementation steps to *XDIM_PACKAGEBY?
-Configure the System for *XDIM_PACKAGEBY
-Change the Script to use the *XDIM_PACKAGEBY keyword (See Appendix C)
-Execute the Data Manager Package across the highest level of dimension members
-Show results with the EVDRE created in Exercise 1 and note the performance ME D04 E01 P.27
What is transaction code for parallel generators?
parrallel_generators; tcode: /nRZ12 ME D04 E01 P.27
What global parameter needs to be set for parallel generation?
PARALLEL_SERVER_GRP - need to make sure to set the BPC Global parameter "PARALLEL_SERVER_GRP" so that BPC knows which RFC Server Group to execute the parallel runs on. Go to transaction /nSPRO and click the “SAP Reference IMG” button: ME D04 E01 P.27
What should not be run with *XDIM_PACKAGEBY?
You should NOT use the *XDIM_PACKAGEBY keyword and the RUNLOGIC BADI together! BACKGROUND: The RUNLOGIC BADI code was written in the form of a Script Logic BADI (Business Add-In). Customers and Partners are able to write their own ABAP code in the form of BADIs which can be executed within the normal Application Logic using predefined Enhancement Spots. This is an effective and very powerful way of writing and developing your own custom business functions, tools, and calculations. ME D04 E01 P.43
Where do you go to activate RUNLOGIC badi?
/nSE20 -- UJ_CUSTOM_LOGIC. we must ensure that the RUNLOGIC BADI has been activated in your system. Go to transaction /nSE20 and enter the name of the Script Logic BADI Enhancement Spot “UJ_CUSTOM_LOGIC”, then click display: ME D04 E01 P.47
What can you see in "Formula log"?
under the “Formula Log” node you can see the actual list of records that the script wrote back: ME D04 E01 P.60
What is text for a macro button to run a data package?
Application.Run "EPMExecuteAPI", "DataManagerRunPackage", "", "Adjust Forecast", "Data Management", ""
End Sub ME D04 E01 P.68
What are key success factors for BPC implementations?
"1- Product Expertise, 2 - A Structured project delivery using best practices (scoping, blueprinting, QA)
detail on item 2
* Method-based Scoping and Implementation efforts (ASAP 7.1 BPC add-on)
* Project Quality Assurance ME D05 P02 P.2"
What are top 3 topics for architects?
1 -Method-based Scoping and Implementation efforts (ASAP 7.1 BPC add-on)
2 - Blueprinting
3 - Project Quality Assurance ME D05 P02 P.4
What are 5 phases of an implementation?
1. Preparation 2. Blue Print 3. Realization 4. Final Preparation 5. Go Live & Support ME D05 P02 P.5
What are 3 factors of BPC Blueprinting process?
"The blueprinting activity is a key activity in any BPC project. It is key not to
underestimate the time required for this task (at least 20 to 30 percent of the total
time of the project – depends on the availability of documented requirements)
Here are some of the factors that will impact the blueprinting effort:
*Type of project (Planning, Consolidation)
*Number of processes to be covered
*Level of details required ME D05 P02 P.7"
What should a blueprint reflect?
what will be customized, sign-off is key, change order, lean implementation model, detail design, prototyping . ME D05 P02 P.8
What is an additional use of detail design document?
unit testing ME D05 P02 P.9
Why is prototyping important?
Prototyping is a key for early user involvement and to prove designs. It reduces change management efforts during Go-Live Preparation (lean implementation model) ME D05 P02 P.9
What are two points of view for blueprint?
User & System. User is how user will interact with the system. System is data flows, calculations, maintenance. ME D05 P02 P.10
What is a part of the Blueprint process?
AS IS & TO-BE. - is a benefit and a good starting point for change management activities. ME D05 P02 P.10
What is relevant information in process description?
"Relevant information in process description:
*High level and detailed description of process
*Setup and Customizing in BPC (BPF, Input Schedules/reports, Calculations, Data Model)
*Custom development requirements
*Improvements compared to current process ME D05 P02 P.10"
What should the blueprint of the data model contain?
"The Data Model should at least have the following information
*List of all applications
*List of dimensions per application (and dimension type)
*High level content for each dimension
*List of properties for each dimension
*Description of internal data flows between applications ME D05 P02 P.11"
What data sources need to be specified in the blueprint?
Master & transactional ME D05 P02 P.11
Consider what 4 things for data import?
"*Central / De-central data load
*Automatic / Manual trigger
*Full vs. Incremental load
*Technology used for data load (out-of-the box, development in ABAP, ...) ME D05 P02 P.11"
What are 3 major components of the Operational Concept in blueprinting?
"The operational concept should include
– Maintenance of master data (frequency, responsibility)
– Initialization of system for a new period
– Roll-out of application updates/fixes
– Responsibility for maintenance
*Concept for service packs / updates
– Roll-out of local client (if applicable) ME D05 P02 P.11"
What are three considerations for backup approach?
"The backup approach needs to be addressed from a global point of view, if BPC is
not run on a dedicated NW server. In that case, the backup strategy will have to be
aligned to the strategy of the NW environment.
If the NW instance is dedicated to BPC, then a strategy can be defined specifically
for BPC and it should include:
*Frequency, Type of backup. Restore possibilities and time estimation ME D05 P02 P.12"
What is system landscape?
Dev, Quality, Production…also sandbox, emergency production fixes, types of objects, maintenance. ME D05 P02 P.13
What are contents of a business blueprint?
"Table of Content
*Description of AS-IS Situation
*Description of TO BE Situation
*Processes to be covered
*System Landscapes and Transports
*Historical Data Migration Concept ME D05 P02 P.9"
When blueprinting, what 3 components should be included in the plan?
"The migration of Historical Data should include at least the following information:
*Source system (or systems)
*Number of periods required
*Approach (for calculations, mapping of dimension members, …) ME D05 P02 P.14"
What is important when blueprinting QA? What is method-based quality assurance?
QA is carried out during project. ME D05 P02 P.15
What are 3 types of method-based QA reviews?
Functional, technical, project management - not performed by delivery team. Use experienced resources. QA team delivers reports. ME D05 P02 P.15
What occurs in the business blue printing stage?
•Architecture and Installation Sizing Review
•Project Plan review
•Stage Gate review
•Project Plan review ME D05 P02 P.16
What occurs in the realization phase?
•Review of the BPC
• Application *
•Stage Gate review
•(Build review) ME D05 P02 P.16
What occurs in the Final Preparation phase?
•QA of open technical
• Issues, Performance
•Test Design Review
•Stage Gate review ME D05 P02 P.16
What occurs in the Go-Live & Support phase?
•Review the maintenance hand ongoing optimization measures put in place for the Go Live, Review of the operational processes and technical handover to operations. ME D05 P02 P.16
What are 4 reviews as part of QA stream?
Reviews as part of the Quality Assurance stream are following the same approach.
1) Assessment of status quo and pain points with relevant client representative and project team members (different views)
2) Execute review and document results
3) Present outcome to the client representative and project team member
4) Formalize report and present results to the stakeholders ME D05 P02 P.19
What are 3 topics for "must be" reviews when blueprinting?
The „must-be“ reviews are on the following topics:
• Business Blueprint review
•Implementation review (Assessment of build quality - Functional review)
• Performance review (reports / input schedules, calculations) ME D05 P02 P.19
How many days for a blueprint & implementation review?
5 day initiative ME D05 P02 P.20
What is the mandatory outcome for any review?
Provide an action plan (with type of resources and planned activities) ME D05 P02 P.20
What are 2 phases and 5 components of "Performance Review Methodology"?
1) Get an understanding about the implemented solution to anticipate potential performance impacts.
2) Get the most critical report (if reporting has performance issues) to check VBA usage, usage of formatting, member selections, no. of formulas (BPC 7.x/EPM 10), no. of sheets in a workbook.
3) Request system access for BPC client, BW backend server with the authorization to UJSTAT
1) Get in touch with client stakeholders / implementation team and make short interviews to understand the individual experiences about the performance
2) Check provided information regarding client settings, server settings, BWA etc. ME D05 P02 P.21
What are 5 steps for trouble-shooting report runtime issues?
1.) If several sheets are used isolate them and run them one by one and the workbook
2.) Run stress tests and benchmark with iterative approach and document result using Tcodes UJSTAT, MDXTEST etc.
3.) Benchmark Network time using Fiddler etc.
4.) Activate / Deactivate VBA, formatting etc to identify the bottlenecks
5.) Either eliminate bottlenecks directly or make a list of action items ME D05 P02 P.22
What are 5 steps for trouble-shooting write-back runtime issues?
1.) Check writeback time in UJSTAT
2.) Analyze the default logic and, if used, the called BAdI
3.) Test script logic using UJK_Script_LOGIC_TESTER
4.) Improve script logic and/or ABAP or request a scripting resource to do it
5.) Analyze write-back calculations and evaluate potential batch jobs (realtime vs near-time availability of calculated no.) ME D05 P02 P.23
What are 4 steps for trouble-shooting Logon issues?
1.) Check on different client desktops (document different client settings)
2.) Check on BPC clients installed on the .NET Server (usually different client settings as no standard client images)
3.) Check logon process (download dimension files etc)
4.) Check SDN, Customer Message System to identify potential bugs/side effects from SPs as usually client logon issues are reported soon from clients
note: Open customer message as soon it looks into a direction of SW related issues ME D05 P02 P.24