MDX Except function in where clause

Posted by rfders on Stack Overflow See other posts from Stack Overflow or by rfders
Published on 2010-03-24T21:08:56Z Indexed on 2010/03/26 19:53 UTC
Read the original article Hit count: 559

Filed under:
|
|
|

Hi, i'm having problem restricting a query in mdx, using except function at where clause. i need to retrieved a set of data but which not in an specific set. Then i created the next query:

select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,{[ManualProcessing].[All ManualProcessings].[MAGNETICSTRIPE], ManualProcessing].[All ManualProcessings].[MANUAL]} ON ROWS 
FROM [Transactions]
where except([Product].[All Products].Children,{[Product].[All Products].[Debit})

apparently this works fine, but when i try to add another restriction to slicer, i got this error: No function matches signature (Set,Member).

I'm currently working on mondrian 3.1

Is it possible to add multiple restriction to slicer when im sing the except funtion ? are there any other way to get this ?

thanks in advance.

© Stack Overflow or respective owner

Related posts about mdx

Related posts about pentaho