Skip to Content
0

No of records issue in BEx Query

Nov 03, 2016 at 11:15 AM

27

avatar image
Former Member

In the BEx Query, we have used Exception aggregation -Standard Aggregation.

In Row, we have a field Document date as 7th field. When I move the Document date field, the no of records became reduced from 10k to some few hundred records.

May I know the reason for this. How can we correct this?

Thanks,

Jai Ganesh J

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

2 Answers

avatar image
Former Member Nov 03, 2016 at 11:18 AM
0

n the BEx Query, we have used Exception aggregation -Standard Aggregation.

In Row, we have a field Document date as 7th field. When I move the Document date field to the first position, the no of records became reduced from 10k to some few hundred records.

May I know the reason for this. How can we correct this?

Thanks,

Jai Ganesh J

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 17, 2016 at 05:57 AM
0

use constant selection and try.

When we drill down characteristics in report, all KPIs will split accordingly.

Share
10 |10000 characters needed characters left characters exceeded