Time of Calculation "Before Aggregation" obsolete in NW2004S
As mentioned in note 935903 the option Time of Calculation "Before Aggregation" is obsolete in NW2004S .
Can anyone tell me how to achieve a "Before Aggregation" in BEx in NW2004S?
The examply we would like to re-produce:
- Key figure A holding difference between 2 dates (number of days)
- Creation of CKF's with 'Before Aggregation':
-> (A>20) * Amount
-> (A>30) * Amount
-> (A>40) * Amount
=> Calculation on cube level not possible as key users need to be able to define new CKF based upon A.
- Lowest level of detail in cube (document + item).
Thanks a lot for your feedback.
please read the documentation, http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/02223c5f00612be10000000a11402f/frameset.htm.
Let me quote from there: "Calculating before aggregation results in poor performance because the database reads the data at the most detailed level and the formula is calculated for every record. In formula calculations, often the single record information for just one or two specific characteristics is required; the remaining data from the InfoProvider can be aggregated.
We recommend that you control the calculation level using an exception aggregation with the corresponding reference characteristic. If you require multiple exception aggregations or reference characteristics, you can nest formulas and calculated key figures in one another and specify an exception aggregation for each formula or calculated key figure."