Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: clarification...

  1. #1
    Join Date
    Mar 2003
    Posts
    207

    Default clarification...

    1) I can get mondrian 0.5 to compile on any platform.. BUT I can't for the life of me get the rdbms tests to suceed under linux (under win32 it worked). Are the tests hard-coded for odbc under win32 or something??? After failing the tests, I could connect to oracle (after reconfiguring the test queries etc - although there seems to be some hard-coded odbc stuff there too..).. so I'm confused.
    2) Also, another question. if I want to use different databases... do I need to recompile mondrian - after changing mondrian.properties (and build.xml??) ??
    3) is it possible to connect to multiple databases - ie obtain data from multiple sources, or must all tables be in a single database instance --- if possible, then how????
    4)... offtopic... but has anyone had trouble compiling jpivot? It refuses to resolve the mondrian class symbols.. (

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

    Default RE: clarification...

    1. The only dependency upon ODBC is via Sun's JDBC/ODBC driver. Change your driver list (part of the connect string, and also the mondrian.jdbcDrivers property, which defaults to "sun.jdbc.odbc.JdbcOdbcDriver,org.hsqldb.jdbcDriver,oracle.jdbc.OracleDriver,com.mysql.jdbc.Driver"), and you should be okay.
    2. No, you don't need to re-compile mondrian.
    3. Currently all tables in a given mondrian schema need to be within the same database. We could allow tables to be in different schemas (what Oracle calls 'users', and what SQL Server calls 'databases'), and if so, log an RFE. But we do need to join fact tables to dimension tables, and we can't do that efficiently if the tables are in different locations.
    4. You need to copy mondrian.jar into $MAVEN_HOME/repository/mondrian/jars. (You may need to rename it to mondrian-0.5.jar, too.)

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.