Skip to Content

output of 3.x bex query and 7.0 bex query is not matching

Feb 21, 2017 at 11:54 AM


avatar image
Former Member

Hi Gurus,

I have copied a standard content bex query 0IC_MC01_Q0001 Slow-moving items and created another query in SAP BI 7.0. The structure of this copy query is exactly same as standard bex query. When i ran both the reports for same selection, copy query output is not matching with standard content query. For example standard content query contains 1000s records wheras copy query contains only 10 records. 10 records of copy query is available in standard content query wheras remaining 990 records are not available in copy query output.

Do we need to changes/settings while copying 3.x query to 7.0 ?

Please suggest.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

John Hawk Feb 21, 2017 at 03:30 PM

Check to see if the 3.x query contains exception aggregation. Exception aggregation is no longer authorized in 7.x and may have been left out of the 7.x copy.

Good luck, and don't forget to record the correct answer.

John Hawk

10 |10000 characters needed characters left characters exceeded