Posted by mladjo on 11/27/06 19:25

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@gmx.de> wrote in message
news:1164632060.308017.216820@n67g2000cwd.googlegroups.com...
> Hello, I have following Situation:
> I have a Dimension "SourceDirectory", whis has Elements
> "SourceDirectory1", "SourceDirectory2", ... until "SourceDirectory10".
>
> 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 SourceDirectories but not the
> "SourceDirectory6", 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
>

• Next in forum: Some XQuery/SQL Server 2005 help please
• Prev in forum: Re: Xquery Help SqlServer2005
• Thread view: Re: Need Help to form the MDX-Statement

[Reply to this message]