Problem with MDX query in Schema Workbench

[cl019]

hi

i'm pretty new at jasperintelligence and just desinged my first cube. B) now i want to test the cube with some queries in the MDX query in the schema workbench, but i don't have the right settings.

 

"Mondrian Connection could not be done ..." is the error message

 

my settings in the mondrian.properties look like this:

 

# MySQL: needs user and password set in JDBC URL

mondrian.<first field>.jdbcURL=jdbc:mysql://localhost:3306/<second field>?user=root&password=mypassword

mondrian.jdbcDrivers=com.mysql.jdbc.Driver

#driver.classpath=D:/mysql-connector-3.1.12

 

now my questions

1) what i have write in the first and second field?

2) is there anything else i have to regard?

3) are the settings at my jasperserver maybe wrong?

 

greatings

cl019

Post edited by: cl019, at: 2007/07/19 14:23

[sbirney]

you can try using these two lines in your mondrian.properties for the workbench:

 

mondrian.foodmart.jdbcURL=jdbc:mysql://localhost:3307/foodmart3?user=root&password

=XXX

 

mondrian.jdbcDrivers=com.mysql.jdbc.Driver

 

or, even easier, you can just set your JDBC connection settings in the workbench, under the Tools menu, then click Preferences. This is what I did, without editting mondrian properties.

 

Once you use the schema in JS, you will need to create the metadata for a datasource and connection, as described in the user guide.