Hi,
I have read the help.sap.com documentation for exception aggregation, but I must be missing something because I have not yet created a CKF using exception aggregation that can take the place of my CKF's that use "Time of Calculation" before aggregation.
Using the example that has been posted on this very topic in the thread, 'Time of Calculation "Before Aggregation" obsolete in NW2004S', could someone give me an example of the CKF's necessary to replace the old calculation before aggregation CKF? Our problem is so similar to this example that I think an answer here will help us replace our Before Aggregation calculations. Using this example I have successfully created a CKF that will display the right numbers for us, but only if I also display each Order number. When I remove the Order characteristic from the row to show only the totals or show them by Plant I no longer have the correct totals. My good numbers go away and I get 0 or 1 depending on how I defined my CKF. I am defining my CKF's as global CKFs on a MultiProvider defined on an ODS.
I'll repeat the very nice example from the thread I mentioned here.
I have a specific requirement to provide aging buckets of orders. At the cube level, I have written the difference in days.
Order..........Days Open.......QTY........Plant
123.............25....................5............A
456.............40...................10...........A
780.............15.....................8...........A
743.............20...................14...........B
In my query I want to show:
Plant..........QTY < 30 days.........QTY > 30 days
A................13...........................10
B................14............................0
Previously I would use a formula to calculate prior to aggregation that would look something like ('Days Open < 30)*QTY.
Thanks for your help,
Jeri