I have create a dimdate dimension on my SSAS database.
I get the wrong results from my SSAS database.
My dimdate dimension has the following hierarchy:
But when I pick the weekofyear filter from the reports then I get
previous years data also.
For example when pick the 33th week of the year 2010 then I get
the 33th week sales of my fact table.
I have attached a screenshot and I am sure that you will easily
understand my problem when you look at this png file.