Solved

MDX Where Equivalent

Posted on 2007-03-27
2
267 Views
Last Modified: 2010-03-19
I have this MDX query:

SELECT NON EMPTY { [Measures].[Reflex Tests] , [Measures].[TOTAL RAN] ,
[Measures].[Incomplete] } ON COLUMNS,  
 {
   ( [Tbl ECONN ASSAY].[Assay Name].[Assay Name].ALLMEMBERS,
   [e Conn Instrument].[Salesman Code].[Salesman Code].[116],
   [e Conn Instrument].[Salesman Name].[Salesman Name].ALLMEMBERS,
   [e Conn Instrument].[CUST NO].[CUST NO].[131326],
   [e Conn Instrument].[Customer Name].[Customer Name].ALLMEMBERS )
}  ON ROWS  
  FROM  [Detail Usage] WHERE {  [ALL TIME].[TIME SID].[20070101] : [ALL TIME].[TIME SID].[20070301]  }

I would like to modify it to exclude some Assay Name values. The in T-SQL I would use the WHERE clause something like this:

WHERE AssayName NOT LIKE '%whatever%'

What is the MDX Equivelant syntax for this? Can I filter out certain assay names from the MDX result set somehow?
0
Comment
Question by:Charles Baldo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 18814236
Perhaps the Except function will do it for you.

WHERE {  
[ALL TIME].[TIME SID].[20070101] : [ALL TIME].[TIME SID].[20070301],
Except([Dim Assays], [Dim Assays].[AssayNameToExclude])
}

Not sure give it a go
0
 

Author Comment

by:Charles Baldo
ID: 18815257
Thank You not the answer but the right direction
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query to Add Late Tolerance 10 85
create insert script based on records in a table 4 29
Sql Server group by 10 57
tempdb log keep growing 7 55
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question