Mondrian connection

sebjak · 2019-12-19 13:39:21

Hello
I have a problem with a mondrian connection

I have create a MYSQL connection datamart
URL : jdbc:mondrian:Jdbc=jdbc:mysql://localhost:3306/datamart

properties :
type=OLAP
name=datamart
driver=mondrian.olap4j.MondrianOlap4jDriver
jdbcDrivers=com.mysql.jdbc.Driver

Schema : generated withe pentaho workbench

when I run the report I have this error

net.datenwerke.gxtdto.client.servercommunication.exceptions.ServerCallFailedException
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl.loadCubesFor(SaikuRpcServiceImpl.java:121)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
 at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
 at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
 at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1598)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Unknown Source)
 Caused by: java.lang.NullPointerException
 at mondrian.rolap.RolapSchema$PhysLink.deriveSql(RolapSchema.java:2046)
 at mondrian.rolap.RolapSchema$PhysLink.<init>(RolapSchema.java:2004)
 at mondrian.rolap.RolapSchema$PhysSchema.addLink(RolapSchema.java:945)
 at mondrian.rolap.RolapSchemaUpgrader.registerRelation(RolapSchemaUpgrader.java:3013)
 at mondrian.rolap.RolapSchemaUpgrader.convertHierarchy(RolapSchemaUpgrader.java:2800)
 at mondrian.rolap.RolapSchemaUpgrader.convertDimension(RolapSchemaUpgrader.java:2707)
 at mondrian.rolap.RolapSchemaUpgrader.convertCubeDimension(RolapSchemaUpgrader.java:735)
 at mondrian.rolap.RolapSchemaUpgrader.convertCube(RolapSchemaUpgrader.java:201)
 at mondrian.rolap.RolapSchemaUpgrader.convertSchema(RolapSchemaUpgrader.java:2208)
 at mondrian.rolap.RolapSchemaUpgrader.upgrade(RolapSchemaUpgrader.java:125)
 at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:254)
 at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)
 at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
 at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
 at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)
 at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
 at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
 at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
 at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
 at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
 at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
 at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:139)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:340)
 at net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCubes(OlapUtilServiceImpl.java:141)
 at net.datenwerke.rs.saiku.server.rest.SaikuRpcServiceImpl.loadCubesFor(SaikuRpcServiceImpl.java:118)
 ... 51 more

And it's not possible to choose the Cube
Thank's for your help

eduardo · 2019-12-19 15:15:11

Hi sebjak,

currently, reportserver supports mondrian 4 cubes only, please check here: https://reportserver.net/en/tutorials/upgrade-30/

"In ReportServer 3.0.3, the Saiku and Mondrian libraries were upgraded to 3.8 and 4.x, respectively. These are in most of the cases not backward compatible. This means the following:
Pivot table variants: you have to create new variants, configure them, and save them again.
Mondrian datasources: if your Mondrian XML schema is defined in reportserver, you shall upgrade the schema to version 4, i.e. it must contain: "<Schema name="YourSchema" metamodelVersion="4.0">". More information here."

Your schema definition seems not to be version 4.0 ( no metamodelVersion="4.0" )

Thus said, we are working on support of Mondrian 3 datasources too.

Regards,
Eduardo

sebjak · 2019-12-19 15:52:53

Tnanks for your return
Maybe you know if a schema workbench soft exist for version 4 ?

eduardo · 2019-12-19 22:09:29

Hi sebjak,

I would recommend you to use the pivot report of a dynamic list. Internally, a mondrian cube is created dynamically and you have all advantages of a dynamic list + mondrian without having to write / maintain the XML cube manually. And the interface is the same interface you have with cube reports. Internally, as I mentioned, a pivot report is a cube report. The only difference is that the XML schema is created and maintained by reportserver. Please take a look at this: https://reportserver.net/en/guides/user … amic-List/
All the ad-hoc reporting advantages of the dynamic list are of course available in pivot reports too.

Regards,
Eduardo

sebjak · 2019-12-20 13:19:28

Hi
thank's for the answer
I have a look about the solution ! Sorry but I have a new question ?
on the left of the screen you have Pivot/preview
On m'y screen, I only have preview !

Have I miss something during the setup ?

Thank's

eduardo · 2019-12-20 14:51:07

Hi sebjak,

you first have to activate the pivot mode, like this:

https://reportserver.net/en/guides/user … amic-List/

"To switch to Pivot mode choose the Pivot option from the toolbar and acknowledge the subsequent check. This will trigger a reload of the Dynamic List now in Pivot mode. The effect is that the aspects list configuration and preview have been replaced by Dimensions/Measures and Pivot/Preview. The aspects parameters, computed columns and pre filter remain visible and are identical to before.

"

You should see a "pivot" button in your dynamic list.

Regards,
Eduardo

sebjak · 2019-12-20 15:05:19

Sorry but I don't have the button in the toolbar
I have
Export excel / Send to / Schedule !

eduardo · 2019-12-20 15:22:17

Hi sebjak,

this is an enterprise feature, you may use an enterprise evaluation to take a look at the functionality, or you can take a look at the demo system here:
http://demo.raas.datenwerke.net/?locale=en (demoadmin, demoadmin)

You should see the "pivot" button in every dynamic list.

Regards,
Eduardo

sebjak · 2019-12-23 09:17:29

Hello
Ok I understand why now. I use the community version for the moment, in order to understand the soft.
If I want an OLAP, I must writh the xml Schema in mondrain version 4.

Thank's for your help

eduardo · 2019-12-23 15:46:05

Hi sebjak,

in order to understand the software, I would recommend the enterprise evaluation version. There you can see how easy it is to use pivot reports, you don't have to maintain xml cubes by hand, it is done automatically you can download a 45-day trial enterprise version from here: https://reportserver.net/en/get-enterprise/

Regards,
Eduardo

ReportServer Forum

#1 2019-12-19 13:39:21

Mondrian connection

#2 2019-12-19 15:15:11

Re: Mondrian connection

#3 2019-12-19 15:52:53

Re: Mondrian connection

#4 2019-12-19 22:09:29

Re: Mondrian connection

#5 2019-12-20 13:19:28

Re: Mondrian connection

#6 2019-12-20 14:51:07

Re: Mondrian connection

#7 2019-12-20 15:05:19

Re: Mondrian connection

#8 2019-12-20 15:22:17

Re: Mondrian connection

#9 2019-12-23 09:17:29

Re: Mondrian connection

#10 2019-12-23 15:46:05

Re: Mondrian connection

Board footer