1 Reply Latest reply on May 31, 2013 4:14 PM by Tracy Rodgers

    OLAP cube with Day dimension YYYY-MM-DD


      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?


      Thanks, Mike