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?
RonKyle
SSC-Dedicated
Points: 31552
More actions
September 19, 2013 at 6:47 am
#1651485
- Account 2 +: DatePK 20130901, AccountPK 22, Value 20- Account 2 +: DatePK 20130901, AccountPK 23, Value 20
- Account 2 +: DatePK 20130901, AccountPK 22, Value 20
- Account 2 +: DatePK 20130901, AccountPK 23, Value 20
Why doesn't this account have the same PK? This adds an extra 20, which would account for the difference between 60 and 80.