Skip to Content

Analysis for excel not showing values in master data table

Nov 20, 2017 at 04:57 PM


avatar image

Hi gurus

I have a bex query with the acces type for results value marked as Master data, and Filter value Selection marked as Values in master data table, for 0FISCPER3 characteristic.

The result is that bex query shows 12 months per each selection, including those months without posted values

It runs OK in bex analyzer and RSRT, but when I execute it in Analysis for office, the first row showed is first row with values.

any idea to show the first 4 rows?

Thanks in advance


captura.jpg (30.8 kB)
captura.jpg (22.7 kB)
captura.jpg (19.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gregor Dieckmann
Nov 21, 2017 at 02:22 PM


AO has a client implementation of zero suppression; you may check whether the effect comes from zero suppression.



10 |10000 characters needed characters left characters exceeded