Mega Elite Training Flashcards
1
Q
Presentation 2: Consolidation Framework
A
Presentation 2: Consolidation Framework ME D01 P02 P.2
2
Q
What are the three models required for consolidation?
A
Consolidation, Ownership, Rate, InterCompany (optional) ME D01 P02 P.2
3
Q
What are the steps to creating a consolidation?
A
1 - create models 2 - Activate Business Rules & Script Logic 3 ME D01 P02 P.2
4
Q
What are components to each delivered Consolidation Task?
A
process chain, script logic, business rule ME D01 P02 P.5
5
Q
What are the delivered functionalities for consolidation?
A
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
6
Q
What parameters must be set after creating an environment?
A
Set template version(current version for dynamic templates) & “change status” (offline or online) ME D01 P02 P.6
7
Q
What are 6 purposes of a legal consolidation model?
A
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
8
Q
Which 9 dimensions are required for legal consolidation?
A
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
9
Q
Which 5 dimensions are required for Rate Model?
A
A,C,E,R,T – Account, category, entity, currency, time ME D01 P02 P.9
10
Q
What are 6 purposes of Ownership model?
A
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
Editor functionality.
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
11
Q
Which 6 dimensions are required for Ownership Model?
A
A,C,E,G,I,T – Account, category, entity, Scope(G), InterCo, Time ME D01 P02 P.11
12
Q
What are 2 general settings for Ownership Model?
A
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
data.
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
13
Q
What should the value be for Parent/child property for hierarchy of groups?
A
value should be Parent_Group. ME D01 P02 P.12
14
Q
What are two settings for Non-interco Member in Ownership?
A
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
15
Q
What are the 7 required dimensions for InterCoMatching model? 1 optional
A
A,C,D,E,G,I,T, - optional S(Flow) ME D01 P02 P.13
16
Q
What is IDtype for Flow?
A
S (Flow) ME D01 P02 P.13
17
Q
What is IDtype for Scope?
A
G(Scope) ME D01 P02 P.13
18
Q
What is Groups (G)/Scope?
A
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
19
Q
What is Intercompany I?
A
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
20
Q
What is DataSource (D)/AudiTrail?
A
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
21
Q
What is CALC?
A
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
22
Q
HIR: What is the recommended way of creating subaccounts?
A
hierarchies as opposed to formulas. ME D01 P02 P.15
23
Q
What is HLEVEL? Which Dim?
A
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
24
Q
What is RATETYPE? Optional? Which Dim?
A
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
25
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
26
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
27
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
28
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
29
Which 4 properties are main properties for C_Account?
- ACCTYPE, RATETYPE, TYPELIM,ELIMACC ME D01 P02 P.15
30
Which 2 properties are main properties for FLOW?
- FLOW_TYPE, DIMLIST ME D01 P02 P.16
31
What is FLOW_TYPE?
- Defines the type of flow of the dimension- Opening, Closing.. (Consolidation) ME D01 P02 P.16
32
What is DIMLIST?
- Used to group the Flows for several Business Rules ME D01 P02 P.16
33
Which 4 properties are main properties for ENTITY?
- CURRENCY, ELIM, INTCO, FX_TYPE ME D01 P02 P.17
34
What is CURRENCY? Which Dim?
ENTITY - The currency in which local data are entered (Currency Conversion) ME D01 P02 P.17
35
What is ELIM? Which Dim?
ENTITY - Used to identify elimination entities used in US Eliminations (Consolidation) ME D01 P02 P.17
36
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
37
What is FX_TYPE? Which Dim?
ENTITY - Special currency conversion Rule (Currency Conversion) ME D01 P02 P.17
38
Which property is main property for INTCO?
- ENTITY ME D01 P02 P.17
39
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
40
What is special about ENTITY property on INTCO?
- it is validated against Entity dimension. ME D01 P02 P.18
41
Which 6 properties are main properties for AuditTrail?
- CDDIIO - IS_CONVERTED, IS_CONSOLIDATED, COPYOPENING, OPENINGDATASRC, DATASRC_TYPE, DATASRC_STAGE ME D01 P02 P.19
42
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
43
What is IS_CONSOLIDATED property? Which Dim?
AUDITTRAIL - IS_CONSOLIDATED Consolidate that Datasrc (Y) (Consolidation) ME D01 P02 P.19
44
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
45
What is OPENINGDATASRC property? Which Dim?
AUDITTRAIL - OPENINGDATASRC Datasrc to be used during carry-forward process (Y) (Copy Opening) ME D01 P02 P.19
46
What is DATASRC_TYPE property? Which Dim?
AUDITTRAIL - DATASRC_TYPE Input (I), Manual (M), or Automatic (A) (Consolidation) ME D01 P02 P.19
47
What is DATASRC_STAGE Property? Which Dim?
AUDITTRAIL - DATASRC_STAGE Special setting for multi-level consolidations (Consolidation) ME D01 P02 P.19
48
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
49
What is OPENING_PERIOD Property? Which Dim?
OPENING_PERIOD Period to use for Copy Opening (Copy Opening) - CATEGORY ME D01 P02 P.20
50
What is OPENING_YEAR Property? Which Dim?
OPENING_YEAR Year to use for Copy Opening (Copy Opening) - CATEGORY ME D01 P02 P.20
51
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
52
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
53
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
54
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
55
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
56
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
57
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
58
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
59
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
60
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
61
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
62
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
63
What is DATASRC_LEVEL Property? Which Dim?
DATASRC_LEVEL Datasrc ID to use for sub-consolidation eliminations (Consolidation) - SCOPE ME D01 P02 P.22
64
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
65
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
66
What is FIRST_CONS_DATE Property? Which Dim?
FIRST_CONS_DATE Date of first consolidation (Consolidation) - SCOPE ME D01 P02 P.22
67
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
68
What is PARENT_GROUP Property? Which Dim?
PARENT_GROUP ID of parent group (Consolidation) - SCOPE ME D01 P02 P.22
69
What is STAGE_ONLY Property? Which Dim?
STAGE_ONLY Storage option for staged consolidations (Consolidation) - SCOPE ME D01 P02 P.22
70
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
71
Which 2 properties are main properties for RPTCURRENCY?
CURRENCY_TYPE, REPORTING ME D01 P02 P.22
72
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
73
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
74
Which 3 properties are main properties for RPTCURRENCY?
PERIOD, YEAR, MONTHNUM ME D01 P02 P.24
75
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
76
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
77
What is MONTHNUM Property? Which Dim?
MONTHNUM 1, 2, 3, … - TIME ME D01 P02 P.24
78
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
79
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"
80
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
method
-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"
81
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
82
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
83
Presentation 3: Consolidation Monitor
Presentation 3: Consolidation Monitor ME D01 P03 P.3
84
What 4 items does consolidation Monitor track?
Controls, conversion, consolidation, work status ME D01 P03 P.3
85
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"
86
What are the two security tasks for Consolidation Monitor?
View consolidation Monitor, Run Consolidation Tasks ME D01 P03 P.6
87
What are 3 sections of Consolidation Monitor StartPage?
context, actions, Status ME D01 P03 P.7
88
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
89
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
90
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
91
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
92
In which 2 modes can Currency Conversion & Consolidation be executed?
Incremental or Full ME D01 P03 P.14
93
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
94
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
95
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"
96
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
97
Presentation 04: Controls - Controls Administration
Presentation 04: Controls - Controls Administration ME D01 P04 P.3
98
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
99
Are controls available in Planning?
Yes ME D01 P04 P.4
100
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
101
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
102
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
103
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
104
Which two attributes are required in the Entity type dimension?
– CONTROL_LEVEL (1)
| – CTRL_CURRENCY_NOT_LC (1) ME D01 P04 P.7
105
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
106
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
107
What 2 tasks are related to Controls from an administration point of view?
– Edit Controls definition
| – View Controls definition ME D01 P04 P.8
108
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
109
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
110
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
111
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
112
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
113
What is a Set of Controls?
Controls can be grouped into Sets. ME D01 P04 P.19
114
What are 2 views for assigning controls?
– Categories by Time
| – Control Sets by Time ME D01 P04 P.19
115
Presentation 05: Controls Monitor - Executing Controls
Presentation 05: Controls Monitor - Executing Controls ME D01 P05 P.1
116
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"
117
What 4 tasks are related to controls from and end-user point of view?
"*Reset Control Dismissal
* Dismiss Blocking Controls
* View Control
* Run Controls ME D01 P05 P.6"
118
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
119
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
Ownership Manager)
*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"
120
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"
121
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"
122
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).
*1: Basic
*2: Standard
*3: Advanced
*4: Comprehensive (Default) ME D01 P05 P.11"
123
How are entities organized in the Controls Monitor?
"An entity uses all the controls that have been assigned
to that level (and above).
*1: Basic
*2: Standard
*3: Advanced
*4: Comprehensive (Default) ME D01 P05 P.11"
124
How do you execute controls for an entity?
highlight the entity or node and click the Run Controls button ME D01 P05 P.13
125
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
126
How do you get a detailed view of all control results?
Open Controls Results ME D01 P05 P.15
127
How do you drill down on a control?
click the arrow on the left of the screen ME D01 P05 P.18
128
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
129
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
130
What is threshold column in controls monitor
*The Threshold column indicates the threshold that was defined for that period ME D01 P05 P.18
131
What is type in controls monitor?
*The Type column indicates whether the control is Blocking or Warning ME D01 P05 P.18
132
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
133
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
134
Is there a possibility to force a control to pass?
Yes, dimiss it. Status will be "dismissed". ME D01 P05 P.20
135
Presentation 06: Journals
Presentation 06: Journals ME D01 P06 P.1
136
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
137
What are 2 global parameters for journals?
enforce balanced journals, allow journals to be reopened ME D01 P06 P.7
138
What are 2 journal template display features?
balanced by entity, "balanced by currency" ME D01 P06 P.10
139
What can be added to journal headers?
additional headers, text or date specific ME D01 P06 P.11
140
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
141
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
142
What do you see on journal landing page?
journal count, additional header count, reopen logic(Y/N) ME D01 P06 P.13
143
How many journal templates can you have for a model?
ONE ME D01 P06 P.13
144
What are two ways of entering journal entries?
via web or Excel add-in ME D01 P06 P.14
145
What are two methods for viewing a set of journals?
Context bar or Advanced Query ME D01 P06 P.16
146
What are 4 options available in Advanced Query for journal entries?
"Essentially all is searchable.
147
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
148
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"
149
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
150
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
151
What are 3 sub tabs of journal entry?
Journal Entries, Additional Properties, Multi Posting ME D01 P06 P.27
152
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
153
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
154
What are 6 journal creation statuses?
Saved, deleted, Posted, Unposted, Locked, Unlocked? ME D01 P06 P.30
155
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
156
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
157
Regarding Journal creation status, what is posted?
• Posted - journal entries have been committed to database ME D01 P06 P.30
158
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
159
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
160
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
161
When a journal is unlocked, what is the new status?
posted ME D01 P06 P.30
162
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
163
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
164
How is the journal BADI delivered?
empty, but customizable by client ME D01 P06 P.31
165
What are 3 options on journals?
balanced, reopen in next period, auto reverse ME D01 P06 P.32
166
Presentation 07: Ownership Manager
Presentation 07: Ownership Manager ME D01 P07 P.1
167
What is Ownership Manager fka?
Dynamic Hierarchy Editor ME D01 P07 P.3
168
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
169
What are 3 key dimensions of Ownership Manger?
Category, Time, Scope. ME D01 P07 P.3
170
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
171
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
172
What are three security tasks for Ownership Manager?
View, Edit, Run Ownership Calculations ME D01 P07 P.5
173
What is Financial Interest Rate in ownership?
POWN ME D01 P07 P.8
174
What are 3 variables in Ownership?
Consolidation Method, Consolidation Rate, Financial Interest Rate ME D01 P07 P.8
175
How do you run internal program that determines the "generated" values for Consolidation Rate and Financial Interests
Calculate ME D01 P07 P.17
176
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
177
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
178
What is BR Share?
business rule share for ownership? ME D01 P07 P.20
179
How is METHOD_SYS determined?
BR share range lookup ME D01 P07 P.20
180
How is PCON_SYS derived?
BR share range lookup ME D01 P07 P.20
181
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
182
What is UPO?
Ultimate Parent Organization ME D01 P07 P.24
183
Direct or Group. Which results in higher ownership%?
Direct does since you don't multiply and dilute the ownership. ME D01 P07 P.24
184
Exercise 01
Exercise 01 ME D01 E01 P.1
185
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
186
Drill Through
Drill Through ME D01 E01 P.37
187
How can you further analyze a BEX query result?
Click the icon with the arrow on it ME D01 E01 P.45
188
What are 2 file extensions for Dashboards in BPC Web Portal?
.swf & .xlf -- generated using Dashboard Design software ME D01 E01 P.194
189
Exercise 02: Overview Consolidations
Exercise 02: Overview Consolidations ME D01 E02 P.1
190
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
191
What C_ACCOUNT is used for eliminations?
USELIMDIFF ME D01 E02 P.18
192
What are 4 main columns in Ownership Manager Entity Editor?
Consolidation Method, Percent Consolidation, Percent Control, Percent Ownership ME D01 E02 P.24
193
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
194
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
195
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
196
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
197
What does enabling "Update Method" do?
calculates the system "generated" value ME D01 E02 P.33
198
What does enabling "Update % Consolidation" do?
calculates the system "generated" value ME D01 E02 P.33
199
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
200
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
201
When journals are grouped what do you see?
Group ID has a value ME D01 E02 P.47
202
How do you create a "Control Set"?
click "edit Sets" ME D01 E02 P.56
203
Why do you need to "set assignments" for controls?
Set is only executed for the category and time specified. ME D01 E02 P.57
204
6 Methods (3 major) for GAAP reporting of investees?
Fair Value, Equity, Consolidation(Acquisition, Purchase, Pooling) ME D02 P01 P.5
205
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"
206
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
207
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
Debit Goodwill
Credit Investment in Investee ME D02 P01 P.8
208
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
209
Where are method codes located?
Business rules/Global Definitions/Methods in administration. ME D02 P01 P.13
210
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
211
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
212
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
213
What are 3 types of inter-entity eliminations?
Automatic Adjustments, US Eliminations, Intercompany Bookings ME D02 P01 P.19
214
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
215
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
216
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
217
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"
218
What is BS translated at?
Month end Spot ME D02 P01 P.24
219
What is IS translated at?
Average Rate ME D02 P01 P.24
220
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
221
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
222
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
223
Which dimension carries Rate type property?
Account ME D02 P01 P.30
224
Which dimensions drive currencies in consolidation?
Entity drives source currency and Group drives target currency ME D02 P01 P.31
225
How are currency rates determined?
by a base currency ME D02 P01 P.32
226
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
227
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"
228
What are 4 steps of consolidation system?
prepare, collect, consolidate, report ME D02 P02 P.3
229
What are preparation steps?
Dimensional Model, Master Data, Business Rules/Configuration, Security, IC, Ownership Manager, Rates ME D02 P02 P.3
230
Where are collect steps?
manual entry, file upload, ERP integration, controls, currency translation ME D02 P02 P.3
231
Where are consolidate steps?
IC eliminations, LT investments/Scope Changes, Reclassification, Allocation ME D02 P02 P.3
232
What are two types of reports?
Management and Statutory ME D02 P02 P.3
233
What are 4 consolidation properties on ACCOUNT?
Acctype, elimacc, typeelim, ratetype ME D02 P02 P.8
234
Where are 4 consolidation properties on ENTITY?
Currency, Owner, Elim, control level ME D02 P02 P.8
235
What are 6 consolidation properties on SCOPE?
CONSO_TYPE, CURRENCY_TYPE, ENTITY, STORE_ENTITY, GROUP_CURRENCY, STORE_GROUP_CURRENCY ME D02 P02 P.8
236
What are 5 consolidation properties on AUDITRAIL?
COPYOPENING, DATASRC_TYPE, IS_CONSOL, IS_CONVERTED, OPENING_DATASRC ME D02 P02 P.8
237
What are 4 consolidation properties on CATEGORY?
FX_SOURCE_CATEGORY, OWN_PERIOD, OWN_YEAR, RATE_CATEGORY ME D02 P02 P.8
238
What are 2 consolidation properties on O_ACCOUNT?
IS_INPUT, special _SYS dimension ME D02 P02 P.8
239
What is 1 consolidation property of R_ACCOUNT?
RATETYPE ME D02 P02 P.8
240
What is 1 consolidation property of INPUTCURRENCY?
MD ME D02 P02 P.8
241
What are 4 elements of Ownership Manager?
METHOD, PCON, PWON, PCTRL ME D02 P02 P.10
242
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
243
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
244
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
245
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
246
What are 4 processes in Consolidation Monitor?
Control status, work status, currency translation, Consolidation calculation ME D02 P02 P.11
247
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
248
What does Purchase Method business rule do?
calculation group and minority interest ME D02 P02 P.13
249
What does Goodwill do?
Calculate cost over book value ME D02 P02 P.13
250
At what entity & currency level are controls executed?
LC and base level entities ME D02 P02 P.14
251
Are controls a predecessor to consolidation?
yes, controls must be executed prior to running consolidation ME D02 P02 P.14
252
What are control sets?
groups of controls. Controls Sets can be assigned to specific intersections of TIME/CATEGORY combinations. ME D02 P02 P.14
253
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
254
What are 4 control levels for controls? Where assigned?
Basic, standard, advanced, comprehensive --- "control_level" property on Entity. ME D02 P02 P.16
255
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
256
What is one way of incorporating BO Intercompany?
source -->IC --> BPC --> adjustments back to source ME D02 P03 P.8
257
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
258
What is first step of Disclosure Management?
Extract post consolidated data from BPC and send to DM application. ME D02 P03 P.3
259
What are three benefits of Disclosure Management?
Reduce the Time, Risk and Cost of Regulatory Disclosures ME D02 P04 P.5
260
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
Collaboration
* 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"
261
What is some of the functionality of Disclosure Management?
```
"*Automated Integration with Data Sources
– Data Source Link Synchronization
*Ability to Manage Financial Data and
Reports
– Create Reports
– Upload Financial Data
– Modify
– Compare Versions
*Audit Ability
*Traceability
*Collaboration
– Viewing
– Comments
– Approvals
*Configurable Workflow
*Monitoring and Cockpit Views
*Users/Roles/Permissions
*Statement Versioning
*Taxonomy Tagging
*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"
```
262
Does BPC contain BO Intercompany?
Yes ME D02 P05 P.16
263
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
264
Is Intercompany a standalone application?
Yes ME D02 P05 P.40
265
What is an implementation time for BO Intercompany?
4 weeks ME D02 P05 P.41
266
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
267
What is a Model in BW?
InfoProvider ME D03 P01 P.5
268
What is a dimension in BW?
InfoObject ME D03 P01 P.5
269
What is a member in BW?
Characteristic value ME D03 P01 P.5
270
What is a property in BW?
Attribute ME D03 P01 P.5
271
What is a hierarchy in BW?
hierarchy ME D03 P01 P.5
272
What is text in BW?
text ME D03 P01 P.5
273
What is signed data in BW?
Key Figure ME D03 P01 P.5
274
What is measures in BW?
calculated key figures ME D03 P01 P.5
275
RSA1
RSA1 Admin Workbench ME D03 P01 P.7
276
RSDCUBE
RSDCUBE InfoCube editing ME D03 P01 P.7
277
RSDMPRO
RSDMPRO Initial Screen: MultiProvider Proc. ME D03 P01 P.7
278
LISTCUBE
LISTCUBE List viewer for Info Cubes ME D03 P01 P.7
279
RSINPUT
RSINPUT Manual Input of Data into Cube ME D03 P01 P.7
280
RSOR
RSOR BW Metadata Repository ME D03 P01 P.7
281
RSMO
RSMO Data-Load-Monitor Start ME D03 P01 P.7
282
RSRQ
RSRQ Data Load Monitor for a Request ME D03 P01 P.7
283
RSPC
RSPC Process Chain Maintenance ME D03 P01 P.7
284
RSA2
RSA2 Datasource Repository ME D03 P01 P.7
285
RSA6
RSA6 Maintain DataSources ME D03 P01 P.7
286
RSRT
RSRT Query Monitor ME D03 P01 P.7
287
RSBBS
RSBBS Query Jump Targets ME D03 P01 P.7
288
RSZC
RSZC Copy Queries between cubes ME D03 P01 P.7
289
RSZDELETE
RSZDELETE Delete queries and workbooks ME D03 P01 P.7
290
RSBBS
RSBBS Query Jump Targets ME D03 P01 P.7
291
What is transaction code to view BW transaction codes?
SE93 *RS codes ME D03 P01 P.11
292
Modeling
Modeling– you create/maintain all of the key BW objects here, such as: ME D03 P01 P.11
293
Info Providers
Info Providers – cubes, data store objects (DSOs), Multi-providers, virtual providers, etc. ME D03 P01 P.11
294
Info Objects
Info Objects – Characteristics (BPC Dimensions) and Key Figure (SignData)definitions ME D03 P01 P.11
295
InfoSource
InfoSource - prepares consolidated data from multiple sources for updating to the data targets ME D03 P01 P.11
296
DataSource
DataSource - used to extract data from a source system and to transfer the data to the BW system ME D03 P01 P.11
297
Source Systems
Source Systems – define general connection settings between SAP/Non-SAP systems and BW ME D03 P01 P.11
298
What is in BW Administration?
Administration – monitor BW operations (Admin Cockpit), broadcast reports, view logs and exceptions ME D03 P01 P.12
299
What is in Transport Connection?
Transport Connection – create BW and BPC transports (new in BPC10) transports. ME D03 P01 P.13
300
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
301
What is in Translation section of BW?
Translation– translate short and long texts for Business Information Warehouse objects ME D03 P01 P.16
302
What is an Extractor?
•Extractors are used to move data from any source into the BW system ME D03 P01 P.17
303
What is in InfoPackage?
•InfoPackages are used to move data from source system to PSA ME D03 P01 P.17
304
What is a transformation in BW?
•Transformations are built to map the fields between the source and target ME D03 P01 P.17
305
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
306
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
307
Is BW a multi key figure model? BPC?
yes, BPC is single. ME D03 P01 P.25
308
What are 2 DSO's used for Delta Load process into BPC?
Full Snapshot and Deltas Only. ME D03 P01 P.29
309
What is high level Delta Load Process?
source --> DSO--> cube --> Full snapshot DSO --> Deltas Only DSO ME D03 P01 P.31
310
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
311
What is transaction code to access process chains?
RSPC Process Chain Maintenance ME D03 P01 P.36
312
With a process chain, what if errors?
Can have two paths for errors or success ME D03 P01 P.37
313
How are process chains initiated?
scheduled or triggered by events (i.e. ECC extract completes) ME D03 P01 P.37
314
What about Logs & process chains?
Each process chain can generate a log that includes details of the execution ME D03 P01 P.37
315
What are 2 views for Process chains?
Tree or Network Display --- change view in Settings option ME D03 P01 P.38
316
What is a link in the chain?
Process types ME D03 P01 P.39
317
How do you construct a process chain?
drag and drop into the forming process chain. ME D03 P01 P.40
318
How is the Data Manager prompt file for a process chain stored?
as a program variant ME D03 P01 P.44
319
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
320
Real time processing of chains can be viewed by color
Green, yellow, red ME D03 P01 P.46
321
What are 5 reporting options?
BEX (Query & Analyzer), LISTCUBE, EPM 10 Add-in (BPC & BW connections) ME D03 P01 P.49
322
What is LISTCUBE?
BW transaction LISTCUBE allows access directly into the BW InfoProvider. Download into file or excel. ME D03 P01 P.56
323
When connecting to BW with EPM Add-in what kind of connection is used?
ODBO ME D03 P01 P.63
324
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
325
What are 2 types of rule groups for infoObjects in BW?
Standard, technical ME D03 E01 P.39
326
What is a typical setting in BW for Aggregation?
Summation ME D03 E01 P.39
327
What is a typical multiplier for transforming records?
3 x original (dr, cr, 0balance) ME D03 E01 P.49
328
Before you can display data in DSO what do you do?
activate data ME D03 E01 P.52
329
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
330
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
331
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
332
What is unique about each process chain?
The start process is unique for each process chain. ME D03 E04 P.3
333
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
334
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.
335
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.
336
When loading data in BW, what is Proposal tab?
load example data, check formatting. - See on Preview tab ME D03 E06 P.
337
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
338
What one overrides the other? EPMFormatting or EPMCopyRange?
EPMCopyRange() overrides EPMFormatting Sheet ME D04 E02 P.
339
How are Dashboard Design & EPM 10 connected?
very tightly ME D04 E11 P.
340
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
341
How, using a formula, can you insert a variance?
EPMInsertCellsBeforeAfterBlock() ME D04 E02 P.20
342
In BPC_Statistics, what is Mddataset_select_data?
run time for the MDX query (creating MDX piece). ME D04 E08 P.7
343
What is the RUN_RSDRI_query?
query that just reads the fact tables ME D04 E08 P.11
344
What is SPRO?
transaction for getting to set parameters to turn on BPC Statistics ME D04 E08 P.2
345
What is /NUJSTAT?
gets you to performance statistic reports ME D04 E08 P.6
346
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
347
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
348
What is transaction code for parallel generators?
parrallel_generators; tcode: /nRZ12 ME D04 E01 P.27
349
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
350
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
351
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
352
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
353
What is text for a macro button to run a data package?
Sub Execute_DM_ADJForecast()
Application.Run "EPMExecuteAPI", "DataManagerRunPackage", "", "Adjust Forecast", "Data Management", ""
End Sub ME D04 E01 P.68
354
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)
* Blueprinting
* Project Quality Assurance ME D05 P02 P.2"
355
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
356
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
357
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"
358
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
359
What is an additional use of detail design document?
unit testing ME D05 P02 P.9
360
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
361
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
362
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
363
What is relevant information in process description?
"Relevant information in process description:
* High level and detailed description of process
* Business Requirements
* User Roles
* Security requirements
* 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"
364
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"
365
What data sources need to be specified in the blueprint?
Master & transactional ME D05 P02 P.11
366
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"
367
What are 3 major components of the Operational Concept in blueprinting?
"The operational concept should include
*System Maintenance
– Maintenance of master data (frequency, responsibility)
– Initialization of system for a new period
– Roll-out of application updates/fixes
*User Maintenance
– Responsibility for maintenance
*Concept for service packs / updates
– Testing
– Roll-out of local client (if applicable) ME D05 P02 P.11"
368
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"
369
What is system landscape?
Dev, Quality, Production…also sandbox, emergency production fixes, types of objects, maintenance. ME D05 P02 P.13
370
What are contents of a business blueprint?
"Table of Content
* Introduction
* Management/Executive Summary
* Project
* Description of AS-IS Situation
* Description of TO BE Situation
* Processes to be covered
* Data Model
* Data Sources
* Security Concept
* Operational Concept
* Backup approach
* System Landscapes and Transports
* Historical Data Migration Concept ME D05 P02 P.9"
371
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"
372
What is important when blueprinting QA? What is method-based quality assurance?
QA is carried out during project. ME D05 P02 P.15
373
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
374
What occurs in the business blue printing stage?
Technical:
•Architecture and Installation Sizing Review
Functional:
•Project Plan review
•Stage Gate review
•Design advisory
PM:
•Project Plan review ME D05 P02 P.16
375
What occurs in the realization phase?
```
Technical:
•Review of the BPC
•Transport
•process, -Performance
• Analysis
•Milestone review
•Technical *
```
```
Functional:
•Milestone review
• Application *
•Stage Gate review
•(Build review) ME D05 P02 P.16
```
376
What occurs in the Final Preparation phase?
```
Technical:
•QA of open technical
• Issues, Performance
•Test Design Review
Functional:
•Stage Gate review ME D05 P02 P.16
```
377
What occurs in the Go-Live & Support phase?
Technical:
•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
378
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
379
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
380
How many days for a blueprint & implementation review?
5 day initiative ME D05 P02 P.20
381
What is the mandatory outcome for any review?
Provide an action plan (with type of resources and planned activities) ME D05 P02 P.20
382
What are 2 phases and 5 components of "Performance Review Methodology"?
Preparation:
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
Execution:
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
383
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
384
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
385
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
386
What are 3 possible reasons for performance issues?
lack of data, lack of stress testing, design errors. ME D05 P02 P.25
