Post reply

Two Different Dimension Attribute values filtaration

  • September 11, 2014 at 1:11 am

    #150724

    Hi,

    I have 2 different dimensions and fact table,but i want amount based on 2 dimension Attribute filtration names.

    Member [Measures].[Revenue_Budget_Amount]

    AS Sum(

    {([Finance Indicator].[Fin Indicator Desc].&[Budget] ,[Particulars].[Particulars].&[Revenue] )},

    [Measures].[Amount_Value])

    i wrote this query its not working filtration ,can u pls help me on this.

    Regards,

    Raghava.

  • September 11, 2014 at 2:27 am

    #1744656

    Are both of your dimensions related to the fact in your Dimension Usage tab in SSDT/BIDS? How is it not filtering? What is the expected result? What is the result you are getting?

    There's nothing syntactically wrong with your calculation so my guess is that you might not have dimension-fact relationships set up properly.

    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