<div>
unsure but i have never been able to do it year first..... so i think its a no go
</div>


unsure but i have never been able to do it year first..... so i think its a no go

<div>
these days Microstrategy 9 went live.<br />
<br />
Maybe give it a try under the new version...<br />

</div>


these days Microstrategy 9 went live.

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


<div>
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.<br />

</div>


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.


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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 &quot;type mismatch&quot;. It happens in MicroStrategy Desktop as well as on the web report view.<br />
Did anyone else had the same problem or any idea why this might happen?<br />
<br />
(DataWarehouse: Oracle)<br />
<br />
Thanks very much in advance!
</div>
</div>


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!

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

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.