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

Posted on 2009-02-20
Last Modified: 2012-05-06

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!
Question by:neatwork
    LVL 31

    Expert Comment

    by:James Murrell
    unsure but i have never been able to do it year first..... so i think its a no go
    LVL 27

    Expert Comment

    these days Microstrategy 9 went live.

    Maybe give it a try under the new version...

    Accepted Solution


    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.
    LVL 27

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to recover a database from a user managed backup

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now