SQLTeam.com | Weblogs | Forums

Duplicate records in MSAS Cube when using diamension DimDate calender year


#1

I have created a cube which consist of a Dim Date dimension , which is related to the measure table using transaction date(transaction table) and Full date alternate key(Dim time table).While browse the cube if i use the calendar year the records are getting duplicated.For example i am having data for only 2015 year but the records are repeated for all the years i am having in dim date table. do i missing any thing ? any help appreciated.