Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

As explained in QueryProvider: Seemantic Grouping, the DTP only can create packages when semantic grouping is used. The following simple examples show which kind of key figures or OLAP features prevent a split into sub-queries(pack level 3). See also QueryProvider: Example I, where you can find a detailed discussion of the technical consequences of the usage of pack level 3 or 5.

We check the following sample query which contains a couple of key figures, and formulas:

We use this query as an QueryProvider in a DTP and map one key figure after the other in the transformation in order to check which key figure allows which pack level. The result is the following:

  • Formula 1: contains boolean operator 'greater than' -> pack level 5
  • Formula 2: devision of two basic key figures -> pack level 5
    • in case a basic key figure is devided(multiplied) by a constant(see also note 1903468) → pack level 3
  • Formula 3: basic key figures 'Transaction Counter' with exception aggregation(MAX reg. 0calday) -> pack level 3
  • Formula 4: basic key figures 'Transaction Counter' with exception aggregation AVG reg. 0calday -> pack level 5
  • Formula 5: FAGGR: devision of two basic key figures with aggregation SUM reg. 0calday -> pack level 5
  • Basic Key Figure 'Transaction Counter' with Constant Selection  -> pack level 3
Formula with Boolean Operator

First we use the Formula 1 in our transformation

The DTP is defined the same way as in QueryProvider: Example I:

When we check the pack level in the debugger(see QueryProvider: Example I), we can see that it is 5 in this case:

Finally, 2 packages were written into the target, however, the query result was retrieved in one go.  

Formula with exception aggregation MAX

Formula 3 only contains one basic key figure( 'Transaction Counter') with exception aggregation Max regarding 0CALDAY.

In the DTP only 2 basic key figures and the formula 3 is mapped:

The DTP is defined the same way as in QueryProvider: Example I:

When we check the pack level in the debugger(see QueryProvider: Example I), we can see that it is 3 in this case:


  • No labels