I am visualizing data stored in an OLAP cube in Microsoft SQL Analysis Services where the values in the 'Day' dimension are in the format YYYY-MM-DD
I want to be able to show data for Today's date or current month or the last n days, etc...
I tried using 'Change Data Type' to say the 'Day' dimension is a date, so that I could use it in a relative date filter, but when I apply the filter I get the following error:
Analysis Services database error 0x80004005: The following system error occurred: Type mismatch.
Is this because of the difference in date format?
How can I accomplish what I want to do?
One way to change your Day field would be to create a calculated member:
Hope this helps!