PDA

View Full Version : Need help here....



narou
02-21-2008, 02:11 AM
Please teach me step by step how to connect mondrian with
sql server and hsqldb thx.....

bugg_tb
02-21-2008, 02:32 AM
Either give more specifics or look at the documentation and forum posts like everyone else

http://sourceforge.net/projects/pentaho

http://wiki.pentaho.org/dashboard.action

narou
02-21-2008, 03:30 AM
i've successfully created an odbc named MondrianSQLServer, this is my connection string, please correct it if its wrong because when i try the Jpivot pivot table page (testpage.jsp?query=mondrian) all i got is null value after i drilled down the table, thanks.

in mondrian.properties
mondrian.test.connectString=Provider=mondrian;Jdbc=jdbc: odbc:MondrianSQLServer;
JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;Catalog=/WEB-INF/queries/FoodMart.xml;

in web.xml
...
<context-param>
<param-name>connectString</param-name>
<param-value>Provider=mondrian;
Jdbc=jdbc: odbc:MondrianSQLServer;
Catalog=/WEB-INF/queries/FoodMart.xml;
JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;
RoleXX='California manager';
</param-value>
</context-param>
...
<init-param>
<param-name>connectString</param-name>
<param-value>Provider=mondrian;
Jdbc=jdbc: odbc:MondrianFoodMart;
Catalog=/WEB-INF/queries/FoodMart.xml;
JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver;
RoleXX='California manager';
</param-value>
</init-param>
...

in arrows.jsp, colors.jsp, fouhrier.jsp, mondrian.jsp
<jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc: odbc:MondrianSQLServer" catalogUri="/WEB-INF/queries/FoodMart.xml">

thx again :D