Skip to Content
0

1rowcount info object in BEX Query

Nov 11, 2016 at 05:31 AM

400

avatar image

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

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

2 Answers

Jay Reddy Nov 17, 2016 at 05:50 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Nov 25, 2016 at 08:10 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded