• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

MDX Where Equivalent

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
Charles Baldo
Asked:
Charles Baldo
1 Solution
 
nmcdermaidCommented:
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
 
Charles BaldoSoftware DeveloperAuthor Commented:
Thank You not the answer but the right direction
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now