Skip to Content
avatar image
Former Member

No of records issue in BEx Query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2016 at 05:57 AM

    use constant selection and try.

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

    Add comment
    10|10000 characters needed characters exceeded