EXISTS FUNCTION IN MDX

  • Hi,

    please I am using the exists function, but it seems its not filtering, as the query in sql works well, this i query I am using below

    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]

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply