In this page we discuss the aggregations NOP, NO1 and NO2:
- NO1: No Aggregation (X, If More Than One Record Occurs)
- NO2: No Aggregation (X, If More Than One Value Occurs)
- NOP: No Aggregation (X, If More Than One Value Uneq. to 0 Occurs)
In RSD1, you can define for a key figure the aggregation N02 and the exception aggregations NO1, NO2 and NOP:
The exceptions aggregations NOP, NO1 and NO2 can also be defined for formulas in the QueryDesigner. In order to better understand how these special kinds of aggregation work, we take a look at a query which uses these exception aggregations regarding characteristic 0CALMONTH:
In the following we are going to focus on N02 when it is used as Aggregation(NOT exception aggregation) for a key figure.
Important to know
- Only aggregation NO2 is allowed for basis key figures
- In the past it was also possible to define a key figure with aggregation NOP(normally only used internally, see note 785825). So, it might be that there are 'old' key figures which are still used on your system with aggregation NOP.
- In InfoCubes these key figures(NOP or NO2) are not clearly defined since e.g. query results depend on whether compression was already done or not.
- You create a new InfoCube: If you want to add such a key figure to an InfoCube(on a current BW system), you get a corresponding error message(see note 772424). So, it is not possible any longer to use such key figures in InfoCubes.
- You have an old InfoCube with NO2/NOP key figures:
- Compression is not possible any longer, see note 2412837 (DBMAN 378).
- When queries are generated, the system issues the warning BRAIN156 'Key figure XY cannot be processed consistently in InfoProvider ...'
- NO2 key figure can be used in the following InfoProviders
- DSO of type 'Direct Update'
- ADSO of type 'Direct Update & 'Planning Mode'
- If it is required to use such NO2(NOP) key figures in BEX queries, it is recommended to store them in a separate DSO and define a suitable MultiProvider/CompositeProvider(see note 785825)
- Transaction LISTCUBE does not handle key figures with aggregation NOP and NO2 correctly. In case of NOP aggregation, no database aggregation is done (all records are displayed) at all. In case of NO2 aggregation, the minimal and maximal values are displayed in two corresponding key figures. See examples below.
SAP Online Documentation
SAP Consulting Notes
- 2412837 InfoCube compression does not work (DBMAN378)
- 2381441 No InfoCube compression for key figures with NOP/NO1/NO2 aggregation
- 2368087 SQL error 195
- 772424 Key figures with NOP-aggregation (InfoCubes, MultiProvider)
- 785825 Various problems with key figures with the NOP aggregation