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
>

Quick Fact Check on Clustering SQL Server

Am I correct in my assumption? If I am creating a two-node SQL Server 2000
active\active cluster configuration, (cluster will be built on Windows 2000)
I can have a maximum of one virtual server name per node and up to 16 named
instances per node if I do not use the Default Instance.
Thanks
Steven S. Warren [MVP Windows]
MCDBA, MCSE, MCSA, CCA
Close. You get up to 16 instances per cluster. You can have 1 default and
15 named or just 1 named instances. You can arrange them on the host nodes
however you see fit.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steven S. Warren" <swtechworksnomorespam@.tampabay.rr.com> wrote in message
news:%23209KlbvEHA.2536@.TK2MSFTNGP11.phx.gbl...
> Am I correct in my assumption? If I am creating a two-node SQL Server 2000
> active\active cluster configuration, (cluster will be built on Windows
2000)
> I can have a maximum of one virtual server name per node and up to 16
named
> instances per node if I do not use the Default Instance.
> Thanks
> --
> Steven S. Warren [MVP Windows]
> MCDBA, MCSE, MCSA, CCA
>
|||Thanks...Back to designing my cluster...I am enjoying this.
Thanks
Steven S. Warren [MVP Windows]
MCDBA, MCSE, MCSA, CCA
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OI$YfUcvEHA.612@.TK2MSFTNGP15.phx.gbl...
> Close. You get up to 16 instances per cluster. You can have 1 default
> and
> 15 named or just 1 named instances. You can arrange them on the host
> nodes
> however you see fit.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steven S. Warren" <swtechworksnomorespam@.tampabay.rr.com> wrote in
> message
> news:%23209KlbvEHA.2536@.TK2MSFTNGP11.phx.gbl...
> 2000)
> named
>