Skip to Content
avatar image
Former Member

1rowcount info object in BEX Query

Why 1rowcount infoobject could not be seen in BEX query designer for a cube ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi,

    we have other ways to see 1 row count in cube.

    While checking cube data,select tick box "Output number of hits" .

    Create a counter if u want in Bex level.

    I think, 1rowcount not avaialble in cube because of star schema structure model.

    All others flat structure/table model which have 1 rowcount.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 25, 2016 at 08:10 AM

    Hi,

    You may create a FORMULA instead and enter 1. In the EXCEPTION AGGREGATION choose SUMMATION (you may also choose the reference characteristics corresponding to UNIQUE combination fields of your cube).

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded