Skip to Content

Warning time of calculation "before aggregation" is obsolute Analyzer 3.X

Dear Gurus,

We created a copy query on a existing query in development and did the reconciliation work with R/3 and it worked fine. We moved the changes to quality when ever i'm trying to execute the query in analyzer it shows the pop up saying Warning time of calculation "before aggregation" is obsolete. And then results are getting displayed. When i tried to do the reconciliation work data is not matching. All the rows with the key figure values where not showed in the query output only the rows with values are displayed.

I tried with the option suppress zero values but it didn't worked. If anyone have the solution for this please help me out!

Kind Regards,

V

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 18, 2017 at 09:06 PM

    Hi V,

    Calculation "Before Aggregation" is obsolete after 3.x. Bex really isn't designed to perform row level calculations.

    Try to figure out a different way.

    See

    https://wiki.scn.sap.com/wiki/display/BI/OT-OLAP-CBA

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 01:42 AM

    Hi,

    The alternative for the BEFORE AGGREGATION is the EXCEPTION AGGREGATION with reference to some characteristics. You can find it as another tab to your query.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded