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

The 'NON EMPTY' should do the trick

SELECT {[Measures].AllMembers} ON columns,
NON EMPTY {[SourceDirectory].Children} ON rows
FROM [CheckstyleError]

- Jens

chris skrev: