1rowcount info object in BEX Query

[Former Member]

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

[Loed]

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

[jay_reddy1]

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.