I have 2 fact tables joined to same dimension table. One fact table has current data only and other fact table have historical data
I have two different filters with two different data from same dimension table (current and historical attributes).
My question is should I have two different cubes? please suggest me.
From your description, it seems you need to define many-to-many dimension relationship. Please take a look at the following articles:
The Many-to-Many Revolution 2.0:
If you have any feedback on our support, please click
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?