I am creating a picklist in reporting services as below

WITH MEMBER [Measures].[ParameterCaption] AS '[Dim].[Attrib].CURRENTMEMBER.
MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Dim].[Attrib].
CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Dim].
[Attrib].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption],
[Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Dim].
[Attrib].[all].children ON ROWS FROM CUBE

The Value for this parameter in reports is ParameterValue and Label is
caption.

Problem is that this dimension is ragged and when th attrib name is null, the
report shows the uniquename. How can I make the report dropdown show only the
non null attributes? I tried using an IIF to select null when the
currentmember.name is null, else uniquename - but that does not work - the
currentmembwe.name never returns null. I also tried isempty and that did not
work either.

thank you!


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200508/1