Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Mondrian Sql server question

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Default Mondrian Sql server question

    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]'
    why?
    I use the same data, just under different database.
    how can I fix this problem?
    Thanks first.

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Mondrian Sql server question

    This is caused by a bug: Mondrian cannot read nvarchar columns:
    https://sourceforge.net/tracker/inde...02&atid=414613

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.