How to filter 2 dimension values

  • i have two dimesion tables tables (Country and State) .i want amount based on country and state filteration using with member clause in mdx query.

    For Example : Country-india ,State -Andhara -(5000)

    send to me one sample mdx query based on that filtration.

  • Create a set of the two members in a crossjoin and then do a sum on it.

    So something like

    WITH MEMBER [YourCalculation]

    AS

    SUM

    (

    {([Country].[Country].&[India] , [State].[State].&[Andhara])}

    ,

    [Amount]

    )

    Although of course you have provided very little detail so I've had to provide a generic example - in other words don't just copy and paste that code, it won't work. Also it's pretty poor form for you to just ask people to write your code for you 😉


    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

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