I have the following MDX in reporting services for a dataset:

SELECT non empty {[Plant].Members} on rows , non empty{[Measures].qty }
on columns from Sales

This query in the MDX Sample applications displays as follows:

All Plant 111245.09
ABC 120.50
DEF 1189.90
GHI 9900.00

But in reporting Services the above shows as follows:
111245.09
ABC 120.50
DEF 1189.90
GHI 9900.00

This causes problem to me I have a parameter defined on plant called
pplant which I have set default to All Plant but in the above query
there is no All Plant it does not work.

I would be very thankful if somebody can show me how I can get All
Plant to appear in reporting services.

Thanks
Karen

I guess the All Plant is what you see in the MDX Sample Application?
You might want to try something like this:

With member [Measures].[MyCaption] as
'[Plant].CurrentMember.Properties("Caption")'
SELECT non empty {[Plant].Members} on rows , non empty{[Measures].qty,
[Measures].[MyCaption] }
on columns from Sales

This will get you a column with all the captions, including your All Plant.

Kaisa M. Lindahl Lervik

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote

Many thanks Kaisa

Kaisa M. Lindahl Lervik wrote: