Showing results for 
Search instead for 
Did you mean: 

Analysis for excel not showing values in master data table

0 Kudos

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


View Entire Topic
0 Kudos


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



0 Kudos
No we do not use Zero Suppression but query shows only booked Data