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

    OLAP cube with Day dimension YYYY-MM-DD

    mike.scholman

      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