Home Forums Data Warehousing Analysis Services Combine two measures with two common dimension plus time RE: Combine two measures with two common dimension plus time
Sushil Dwivedi
SSC Eights!
Points: 973
More actions
February 26, 2014 at 8:43 am
#1692319
i would suggest to use date dimension as a confirmed dimension with 2 fact tables. Create a dateid key in inventory fact table and use date dimension as confirmed dimension(shared dimension)