I am trying to write a query that will filter based on two members of the
same dimension.

Getting "duplicate dimensions accross independent axis" error when I try the
query below.

Any suggestions greatly appreciated:

SELECT
NON EMPTY {[Credited Card].[Standard].[All Credited Cards]} ON ROWS,
NON EMPTY {[Measures].[Amount]} ON COLUMNS
FROM [CreditCards]
WHERE ( [Transaction Type].[Standard].[Transaction Type].[Pay], [Transaction
Type].[Standard].[Transaction Type].[Charge] )

Got it to work using aggregate function:

Set [TranSet] as
'{[Transaction Type].[Standard].[Transaction Type].[Pay],
[Transaction Type].[Standard].[Transaction Type].[Charge]}'

Member [Transaction Type].[Standard].[All Transactions].[SelectedTrans] as
'Aggregate([TranSet])'

SELECT
NON EMPTY {[Credited Card].[Standard].[All Credited Cards]} ON ROWS,
NON EMPTY {[Measures].[Amount]} ON COLUMNS
FROM [CreditCards]
WHERE ( [Transaction Type].[Standard].[All Transactions].[SelectedTrans] )



"billd" wrote: