Need Help to form the MDX-Statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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

.



Relevant Pages

  • Need Help to form the MDX-Statement
    ... I have a Dimension "SourceDirectory", whis has Elements ... My Statement in MDX is whis: ... FROM [CheckstyleError] ...
    (comp.databases.olap)
  • Need Help to form the MDX-Statement
    ... I have a Dimension "SourceDirectory", whis has Elements ... My Statement in MDX is whis: ... FROM [CheckstyleError] ...
    (comp.databases.ms-sqlserver)
  • Re: Need Help to form the MDX-Statement
    ... I have a Dimension "SourceDirectory", whis has Elements ... My Statement in MDX is whis: ...
    (microsoft.public.sqlserver.datawarehouse)
  • Brauche Hilfe beim Formulieren der MDX-Anfrage
    ... Ich habe Dimension "SourceDirectory", diese hat Elemente ... FROM [CheckstyleError] ... wie kann ich alle SourceDirectories selectieren ... daher braucht man diese in der Analyse nicht zu sehen. ...
    (comp.databases.olap)