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