Hi BW Experts,
we want to identify all of our 3.5 Querys which uses Calculated Key Figures. And for the identified CKFs we want to see which one uses the calculation before or after Aggregation option/flag.
The background for this is, that we want to migrate our 3.5 Querys towards 7.x. To avoid display problems with the changed aggrationmode in 7.x we want to identify these querys in beforehand.
This is what I could achieve so far:
- Buid up a APD which joins the neccessary RSZ* Tables. (please see screenshot attached)
RSZCALC-ELTUID = RSZELTDIR-ELTUID
RSZCALC-CALLATE (Aggregation Mode) -> X or NULL
RSZELTDIR- DEFTP -> CKF (Calculated Keyfigure)
RSZELTDIR-ELTUID = RSZELTXREF-TELTUID
RSZELTXREF-SELTUID -> link towards RSRREPDIR?
RSZELTXREF-SELTUID = RSRREPDIR-COMPUID
--> Here the Join fails an does not deliver any data.
Do I missed here something? Or is there some more mapping Table between RSZELTXREF and RSRREPDIR?
Help would be highly appreciated.