Hello, Please is it possible to use the exist function on different dimension, I am trying a query like this
with
member
measures.lil
as
count(
Exists
(
{([Transaction].[RPC Count].&[1],[Transaction].[Account ID].[Account ID])}
,
{([Account].[PAYMENTSTATUS].&[0],[Account].[Account ID].[Account ID])}
))
select
measures.lil on 0
FROM sax
or is there a better way
Thanks
- Edited by I4QR1A Tuesday, September 08, 2015 2:30 PM