Two Different Dimension Attribute values filtaration

• raghavag7

  SSC Veteran

  Points: 203

  More actions

  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.

• PB_BI

  SSCoach

  Points: 17464

  More actions

  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