Sherman
JasperSoft
14 Answers:
1. put your database JDBC driver in the /drivers directory
2. start the workbench
3. set your JDBC driver class, URL, user name and password of your cube database under Preferences in the workbench
4. Create a new schema
5. Add the elements to the schema by right clicking, and change the details in the right hand panel
6. You can test the schema by running MDX queries against the schema
7. Once you are happy with the schema, you can add it into JasperServer through the user interface, and add analysis views with your starting MDX. See the JasperServer administration guide for details.
Sherman
JasperSoft
swood
Wrote: Hello Sir. I have doubt in using Schema workbench. I was able to connect to foodmart schema with mysql jdbc driver. When I am trying to connect to oracle db, it is showing "Mondrian connection successfull", but I am not able to view the tables in the db. It is showing database - null (oracle).
| Please post questions here that relate to JasperAnalysis, the relational OLAP engine and 'slice and dice' user interface that is part of JasperServer. A related tool is the schema workbench. Sherman JasperSoft |
quest_2009
Wrote:Sir, Though it is showing both oracle and mysql drivers are loaded successfully , it is showing database - null (oracle). No exceptions could be found on the batch file.
|
I couldn't find any exceptions. But it is showing JDBC Driver oracle.jdbc.driver.OracleDriver loaded successfully JDBC Driver com.mysql.jdbc.Driver loaded successfully. |
swood
Wrote: I didnt get any reply for my doubt sir. While working with schema workbench, though the mondrian connection is successfull with oracle, it is not displaying any tables in that database. Also at the bottom, it is showing database - null (Oracle). It is not showing any excepions too. so what is the problem and how it could be resolved.
| Please post questions here that relate to JasperAnalysis, the relational OLAP engine and 'slice and dice' user interface that is part of JasperServer. A related tool is the schema workbench. Sherman JasperSoft |
swood
Wrote: I made an xml file using schema wokbench with foodmart . The query run properly. I made an analysis connection using that schema file. It was successful. After that I was trying to create an analysis view using that connection. It asked for the query. It is showing an error while executing the query as follows
". Why is it so?
| Please post questions here that relate to JasperAnalysis, the relational OLAP engine and 'slice and dice' user interface that is part of JasperServer. A related tool is the schema workbench. Sherman JasperSoft |
| Code: |
select {[Measures].[cost],[Measures].[sales]} on columns,{[store]} on rows from [sales_cube]</td></tr></tbody></table> |
swood
Wrote:Why this error is desplaying "com.jaspersoft.jasperserver.api.metadata.olap.domain.client.MondrianConnectionImpl" while trying to run an mdx query after uploading an xml file created using schema workbench. This query works properly in schema workbench. Expecting a reply for this doubt at the earliest.
| Please post questions here that relate to JasperAnalysis, the relational OLAP engine and 'slice and dice' user interface that is part of JasperServer. A related tool is the schema workbench. Sherman JasperSoft |
| Code: |
The following is not a valid MDX Query: com.jaspersoft.jasperserver.api.metadata.olap.domain.client.MondrianConnectionImpl</td></tr></tbody></table> |
Hi all,
I have this error when I try to connect to oracle database:
database - null oracle
when I use workbench I see the table but when I connect MDX query I have the following error :
No Mondrian connection
Why? What I do in this case?
I have create a folder drivers for jdbc oracle driver.
I use C:\workbench-2.3.2.9247.
thanks for any help.
slug70
Hi, Sherman,
Is there any way to connect 2 schemas of oracle database ?
I have dimenstion tables in one schema and fact tables in another schema... in SQL developer we can give synonims to access other schema tables.. In the same how can I get field from other schema in work bench as the database connection allows only to connect one schema at a time ....
Thank you.
Sadakar
BI developer
Open source technolgoies.
