|
Hello Comunity. I downloaded Saiku server and tried to configure a datasource for my SQL Server sample database. The server started successfully, and I can access the web application included in Saiku Server without problems. In the cube selector combobox, I can choose the cube and then when I try to drag&drop the dimension members to the Rows, Columns or Filter sections, I get the following message in Saiku Server Console: ...Sql Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name "DimensionTableName" where "DimensionTableName" is the table name from which I'm trying to do the drag&drop operation. Does anybody know why the server can't recognize the tables? I would appreciate any help on this issue. |
|
Fixed!!! The problem was that the user must have the database set as the default one. i'm glad you got it working :)
(19 Sep '11, 13:45)
pstoellberger ♦♦
|
|
Replicate the same example in mysql and it worked correctly, which makes me think is a connection problem. Does anyone know where is the error in my connection string? type=OLAP I would appreciate any help!! |
|
have you tested the schema with schema workbench or any other tool that can talk to mondrian? most likely it has something to do with your schema configuration. e.g. surrounding quotation marks missing or in case of SQL server you often have to put "dbo" as schema prefix to the table names its weird that the bug only occurs after the connection is established already.. -paul |
|
please don't hijack other threads. yes, just drop it in there (the ojdbc14.jar) you can get schema workbench from here: http://sourceforge.net/projects/mondrian/files/schema%20workbench/3.2.2-stable/ it helps you develop mondrian schema files that can be used in saiku |
|
francogriba can you possibly email me: tfahland@verdezyne.com i am trying to connect to sqlserver and having problems and saw your post. something is wrong with my connection string, trying to connect to a sqlserver database on a machine dataweb (i dropped the driver file into the lib directory,sqljdbc4.jar ) type=OLAP name=analytics driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jdbc:sqlserver://dataweb:1433;databaseName=Analytics;Catalog==../webapps/saiku/steelwheels/analytics.mondrian.xml;JdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver; username=xx password=xx |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Tags:
Asked: 14 Sep '11, 17:06
Seen: 574 times
Last updated: 23 Jan, 16:59
