Skip to Content
0

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

Apr 10, 2017 at 12:06 PM

123

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

John Hawk Apr 18, 2017 at 09:06 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks John

0
Loed Despuig Apr 25, 2017 at 01:42 AM
0

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


delete.jpg (24.6 kB)
Share
10 |10000 characters needed characters left characters exceeded