View Full Version : Mondrian Sql server question

10-09-2003, 09:13 PM
hi, I download jpivot.war and mondrian foodmart data (access database), everything works fine under tomcat. then I want to test if
it works in Microsoft Sql server, I just create a database "foodmart" in sql server and import the MondrianFoodMart.mdb to the database, then create a ODBC data source "Mondrianfoodmart" (the old one was deleted) pointed to this sql database, everything stays as before in webapp.
but when I run jpivot with mondrian foodmart example, errors occur with :
org.apache.jasper.JasperException: MDX object 'USA' not found in dimension '[Store]'
I use the same data, just under different database.
how can I fix this problem?
Thanks first.

10-13-2003, 04:27 PM
This is caused by a bug: Mondrian cannot read nvarchar columns: