Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
FI-SL-IS (Application Component) Information System⤷
GBIW_PI (Package) FI-SL: Interface to Business Information Warehouse
Basic Data
| Data Element | GBIWPIDELTA_VIA_ADD |
| Short Description | Determination of Delta Using ADD Process |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | BOOLE | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | ADD |
| Medium | 19 | ADD (Additive) |
| Long | 34 | ADD (Additive from Line Items) |
| Heading | 50 | ADD (Additive Extraction from Line Item Table) |
Documentation
Definition
Use
When you select this delta process, the Time Stamp field is used to select all of the line items posted in the line item table since the last transfer and to transfer them in summarized form to BW.
Note
For the full upload and the delta initialization, the records are selected from totals table.
Advantages:
- Good performance with large volumes of data
- Relatively small data volume that is transferred to BI
- No DSO or ODS required
Disadvantages:
- Safety interval of one hour, which means that the system only transfers line items that are older than one hour to BI
- Postings cannot be made during delta initialization (this has to be set up from an organizational point of view)
- Additional index is necessary for the Time Stamp field on the line item table
It is advisable to use this procedure with large volumes of data due to the advantages for performance. It operates most efficiently when postings are made to new as well as to many identical characteristic combinations (such as numerous postings to the taxes on sales/purchases account with the same profit center) between two delta transfers because the selected line items in such cases are transferred to BW in aggregated form.
The prerequisite for using this procedure is that line items are written in period 0. For more information, see SAP Note 1153947.
If you opt for this procedure, you need to make sure that the update type Addition is selected for all key figures when a DSO or ODS is used in the transformation to DSO or in the update rule for the ODS.
Caution
If you are interested in the noncumulative key figure Balance, you have to create a start routine in the transformation or update rule in BI (using the correction instructions for the program UPDATE_ROUTINE detailed in SAP Note 1153944).
With this start routine, Balance is calculated very quickly in BI.
Since an ODS is no longer required during this additive procedure, we recommend using the start routine in the transformation or the update rule for the InfoCube because this reduces the data volume, which consequently improves performance in BI.
For more information, see section 3 Additional Steps for the ADD Procedure in SAP Note 1153944.
Dependencies
Example
History
| Last changed by/on | SAP | 20100310 |
| SAP Release Created in | 605 |
