Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1169
  • Last Modified:

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!
0
neatwork
Asked:
neatwork
  • 2
1 Solution
 
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
 
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
 
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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now