Hierarchy
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-EI-APD (Application Component) Analysis Process Designer⤷
RSAN_WB (Package) APD - Tool - User Interface
Basic Data
| Data Element | RSAN_WB_DS_INFOPROV_ENSURE_AGG |
| Short Description | Flag: Ensure Correct Aggregation |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | AS4FLAG | |
| 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 | 0 | |
| Medium | 0 | |
| Long | 0 | |
| Heading | 0 |
Documentation
Definition
This flag defines whether the key figures have to be aggregated completely when reading data from an InfoProvider.
Use
Depending on the InfoProvider type, the Data Manager read access (RSDRI) might not guarantee complete aggregation of the key figures. With the MultiProvider for example, the same characteristic combination can occur more than once in the result ("split"). Normally, Analysis Process Designer performs a subsequent aggregation here. It only does this though for InfoProvider types where complete aggregation by Data Manager is not guaranteed.
Only deactivate the flag if incomplete aggregation is acceptable (for example if the data will be aggregated at its destination), and subsequent aggregation is undesirable for performance reasons .
Dependencies
If complete aggregation of an InfoProvider is already guaranteed by Data Manager, this flag is not input-ready. The system does not perform a subsequent aggregation in the analysis process either.
Example
You want to store large amounts of data from a MultiProvider in an analytical index (type "insert only"). The accompanying analysis process does not contain any transformations. This requires complete aggregation of the key figures, a filter for characteristics for example. To ensure aggregation, the system has to replicate the data that has been read to a temporary DB table (deactivate performance setting "Process Data in Memory"). This activity is highly performance-intensive. In this case, deactivate the "Ensure Complete Aggregation" flag in order to avoid this.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 720 |
