Ragged Dimension

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.aspx/sql-server-reporting/200508/1I have seen people in the group say to try isnothing ... rather than
isnull or isempty
"Angie via SQLMonster.com" wrote:
> 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.aspx/sql-server-reporting/200508/1
>