Calculate amount based on two dimension tables filteration values

• raghavag7

  SSC Veteran

  Points: 203

  More actions

  September 23, 2014 at 12:58 am

  #150240

  i have 2 dimension tables (Time,Product) and 1 fact(Sales),i need amount based 2 dimension table filtrations.

  Suppose time table i have year column value :2014

  product table product name value:Dell

  Need Amount using this values filtration using with member mdx query.

  can u please help me anyone.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  September 23, 2014 at 2:42 am

  #1747333

  You asked the same question, and it was answered, a few days ago http://www.sqlservercentral.com/Forums/Topic1612945-17-1.aspx

  ---

  I'm on LinkedIn