Home Forums SQL Server 2005 Business Intelligence SSAS - How do I handle dimensions with valid duplicates? RE: SSAS - How do I handle dimensions with valid duplicates?
Koen Verbeeck
SSC Guru
Points: 259085
More actions
September 16, 2013 at 5:53 am
#1650385
Why don't you use the ID field of the groups-account dimension as a surrogate key in your fact table?
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP