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: 595
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