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

Hi Chris,

this should work:

SELECT EXCEPT( {[Measures].AllMembers}, {[Measures].[SourceDirectory6]}) ON
columns, ...




--
CS Result GmbH
Bischof-von-Henle-Str. 2
93051 Regensburg


"chris" wrote:

Hi Bernhard,

or if you intend to remove all empty values you might use the NON EMPTY
keyword or NonEmpty() function:

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

Helmut Knappe
Business Intelligence Ware GmbH
Muenchen


"Bernhard Saemmer" <BernhardSaemmer (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news:888A6794-E168-473B-A69F-FDE8FB26D790 (AT) microsoft (DOT) com...