Analysis services and Excel

G

Graham Toms

Hi all

I have a cube in MSSQL 2000 Analysis Services which I am querying from
Excel, however it is behaving strangely. When I choose a certain dimension,
only the rows with associated data are returned. The listbox on the top of
the column displays all the possible dimensions, but the rows without data
are missed in the actual pivot table.

When I query this same cube from Crystal Reports 9, it behaves as expected,
that is, all the rows are displayed regardless of whether there is data for
the row or not.....

Any thoughts as to how I can make Excel display ALL the dimension rows,
regardless of whether they have data or not?

I am using Excel 2003 although the same behaviour has been exhibited on
Excel 2000 and Excel XP.

Thanks in advance!
Graham
 
Top