How do I link the date dim to fact table in my cube

See more:

SQL-Server

SQL-Server-2008

, +

Hi there;

I am creating a new cube in Visuel Studio & the dimension calnder is linked to the fact table thorugh transaction date in the fact table & dates in the dimension , both data types are date type , the cube basically retrieves the sales per product per date , the cycle hierarchy is year-->month-->week-->date , but the problem is that the sales are shown in all years not each in it's perspective date like even if i choose a certain year all the sales are shown , like the transaction date is not linked to the dimension though it's linked in the data sourse , is there any thing that could be missing ?

Appreciate your help