I'm trying to include date and time in my MicroStrategy reports by using the integrated date and time functions (year, month). When including the date/time metrics in my report everything works fine in case I do it as a row (month, year). In case I try to set year/month as page-by functionality in my report I get the error "type mismatch". It happens in MicroStrategy Desktop as well as on the web report view.
Did anyone else had the same problem or any idea why this might happen?
Thanks very much in advance!