Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time of Calculation "Before Aggregation" obsolete in NW2004S

Hi all,

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.

Kind Regards,

Kurt

Former Member
Former Member replied

Hi Kurt,

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."

Regards, Klaus

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question