cancel
Showing results for 
Search instead for 
Did you mean: 

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

venkatesh_veera2
Participant
0 Kudos

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

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

May be the below thread might help you to understand more on Before and After aggregations;

https://archive.sap.com/discussions/thread/408808

https://archive.sap.com/discussions/thread/1678504

Thanks,

Jothi

Accepted Solutions (0)

Answers (2)

Answers (2)

Loed
Active Contributor
0 Kudos

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

john_hawk
Active Contributor
0 Kudos

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

venkatesh_veera2
Participant
0 Kudos

Thanks John