Re: Need Help to form the MDX-Statement
- From: "JHunter" <newsreply@xxxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 13:46:58 -0000
Chris,
NONEMPTY {[SourceDirectory].Children} ON rows
or
{NonEmpty([SourceDirectory].Children)} ON rows
should do it.
Jamie
"chris" <christi.ochs@xxxxxx> wrote in message
news:1164632562.342695.293850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- Prev by Date: How to create schema in Analysis server 2005
- Next by Date: Create a cube in analysis services out of more than one fact table.
- Previous by thread: How to create schema in Analysis server 2005
- Next by thread: Create a cube in analysis services out of more than one fact table.
- Index(es):
Relevant Pages
|
Loading
