MicroStrategy error when adding yearOfDate to page-by: type mismatch

Hi,

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?

(DataWarehouse: Oracle)

Thanks very much in advance!
neatworkAsked:
Who is Participating?
 
neatworkAuthor Commented:
Hi,

I solved the problem by setting the YearOfXY attribute not to text or datetime format but to numeric. If done so it works fine. Even if MicroStrategy in complaining about a type mismatch when changing the attribute type to numeric - it works fine.
0
 
James MurrellProduct SpecialistCommented:
unsure but i have never been able to do it year first..... so i think its a no go
0
 
TolomirAdministratorCommented:
these days Microstrategy 9 went live.

Maybe give it a try under the new version...
0
 
TolomirAdministratorCommented:
That Microstrategy check is no problem, as long as you don't get an SQL error during executing of the report it's no problem at all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.