I am using a SSAS Cube as my data source for a SSRS report. In the cube I have created a Time dimension which has the following attributes, Date, Year, Quarter, Month, weekofyear, weekofmonth....
When I browse the cube in SSAS the weekofYear field seems to sort correctly. However, in the reporting services when I browse the report it appears to be treating the weeknum field as a string. I know their's a solution for this but I can remember how to correct this.
Your help will be appreciated.