Need Help to form the MDX-Statement

[chris]

Hello, I have following Situation:
I have a Dimension "SourceDirector y", whis has Elements
"SourceDirector y1", "SourceDirector y2", ... until "SourceDirector y10".

My Statement in MDX is whis:
SELECT {[Measures].AllMembers} ON columns,
{[SourceDirectory].Children} ON rows
FROM [CheckstyleError]
It works. Now, how can I select all SourceDirectori es but not the
"SourceDirector y6", whis has only NULL-Values and I need't to see it in
my report.
I would be glad to have an early reply!
Thanks

[mladjo]

Re: Need Help to form the MDX-Statement

Hi.

I think you should try with non empty statement. That's look like this:
SELECT non empty

{[Measures].AllMembers} ON columns,

non empty

{[SourceDirectory].Children} ON rows

FROM [CheckstyleError]





"chris" <christi.ochs@g mx.dewrote in message
news:1164632060 .308017.216820@ n67g2000cwd.goo glegroups.com.. .

Hello, I have following Situation:
I have a Dimension "SourceDirector y", whis has Elements
"SourceDirector y1", "SourceDirector y2", ... until "SourceDirector y10".
>
My Statement in MDX is whis:
SELECT {[Measures].AllMembers} ON columns,
{[SourceDirectory].Children} ON rows
FROM [CheckstyleError]
It works. Now, how can I select all SourceDirectori es but not the
"SourceDirector y6", whis has only NULL-Values and I need't to see it in
my report.
I would be glad to have an early reply!
Thanks
>