Relationship views

23-11-2018  0 Comment(s)


This will be simple task if customer’s age is calculated by current year minus the birthday but he is trying to show this report by years in the past up to now. In this case, the what-if parameter or calculated measure could not help us cause we need ages as a field or calculated column. So I’d like to propose my approach as workaround solution in this case with 2 keys.

  • Multicast the date data
  • Using advantage of cross filter direction (bi-directional) in data model

What I have so far: AdventureWorksDW database

  • FactInternetSales as a fact table
  • DimCustomer (I choose randomly 10 customers to easy cross-check the result in transaction with my output)
  • DimDate (I will filter years to get data from 1980-1995 for demonstration purpose and for another reason that i will explain in disadvantage of approach part)

Comment Here


No Comments to Show