[Mondrian] Saiku Mondrian 4 builds

Paul Stoellberger p.stoellberger at gmail.com
Mon Jan 14 12:44:00 EST 2013


We had some hardware issue with our CI server recently and I had to recreate the Mondrian 4 build.
While I was at it I fixed a few outstanding issues:

- olap4j-xmlaserver is now included in the plugin because olap4j has a dependency on it (I think that class - xmlahandler / xmlaextra or something shouldn't live in xmlaserver per se, as its a util class)
- update eigenbase dependencies to the latest versions

Saiku-Server and Saiku-Plugin with Mondrian 4 can now be downloaded again from: http://ci.analytical-labs.com/job/saiku-mondrian4/

Luc/Julian, I had to put the jdks into <exclusions> for the mondrian dependency, they are still getting pulled and put into the WAR by default.
I couldn't find the JIRA where we discussed the changes necessary to the pom.xml, but this definitely needs fixing

I tested the plugin on a clean pentaho 4.8 server and the standalone seems to work fine as well (standalone comes with new foodmart.xml)

Like before the build should be triggered every day once at midnight to pull latest mondrian 4 / foodmart.xml!

Let me know how that works for you or if you found any bug I didn't see!

-Paul



On Oct 26, 2012, at 12:39 AM, Paul Stoellberger <p.stoellberger at gmail.com> wrote:

> This is not a bug. Its a missing feature ;-)
> Mondrian wasn't capable of doing that at some point and the olap4j query model doesn't support it.
> I'm currently creating a new query model for olap4j that can do much more than the old one.. including working with hierarchies rather than dimensions.
> Made some good progress already this week, but I'll send out more info once its evolved a bit further.
> 
> Yeah would be great!
> Feel free to pile up a list and send it my way or create github issues. Either way is fine by me.
> 
> Glad I could help!
> 
> -Paul
> 
> On Oct 26, 2012, at 12:29 AM, William Back wrote:
> 
>> Thanks, that fixed it.  I have other things I consider to be errors in the handling of things, splitting attribute hierarchies across rows and columns for example.  Would you prefer I list those as potential bugs on the Saiku site?
>> 
>> This saves me literally hours of effort this week, so thanks for creating the plug-in.
>> 
>> Bill.
>> 
>> On Oct 25, 2012, at 3:11 PM, Paul Stoellberger <p.stoellberger at gmail.com> wrote:
>> 
>>> Ah, seems like I forgot to fix the dependencies in the plugin correctly.
>>> Can you try again?
>>> 
>>> You will most likely see some errors from the platform trying to create a mondrian connection (in case you open any of the other platform olap tools), but saiku should work now
>>> 
>>> -Paul
>>> 
>>> On Oct 25, 2012, at 11:47 PM, William Back wrote:
>>> 
>>>> Apologies in advance if this is the wrong forum…
>>>> 
>>>> I've installed the biserver plugin into Pentaho 4.5 and get the following error when attempting to load a Mondrian 4 schema.  I've tried with and without the metamodelVersion attribute.  
>>>> 
>>>> mondrian.olap.MondrianException: Mondrian Error:Internal error: Schema version '4.x' is later than schema version '3.x' supported by this version of Mondrian
>>>> 	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:964)
>>>> 	at mondrian.olap.Util.newInternal(Util.java:2316)
>>>> 	at mondrian.olap.Util.newError(Util.java:2331)
>>>> 	at mondrian.rolap.RolapSchema.checkSchemaVersion(RolapSchema.java:458)
>>>> 	at mondrian.rolap.RolapSchema.load(RolapSchema.java:408)
>>>> 	at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
>>>> 	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:207)
>>>> 	at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:63)
>>>> 	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
>>>> 	at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:90)
>>>> 	at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
>>>> 	at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
>>>> 	at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:135)
>>>> 	at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
>>>> 	at mondrian.olap4j.FactoryJdbc4Impl$MondrianOlap4jConnectionJdbc4.<init>(FactoryJdbc4Impl.java:104)
>>>> 	at mondrian.olap4j.FactoryJdbc4Impl.newConnection(FactoryJdbc4Impl.java:32)
>>>> 	at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:132)
>>>> 	at java.sql.DriverManager.getConnection(DriverManager.java:582)
>>>> 	at java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>> 	at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:70)
>>>> 	at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:46)
>>>> 	at org.saiku.datasources.connection.SaikuConnectionFactory.getConnection(SaikuConnectionFactory.java:29)
>>>> 	at org.saiku.plugin.PentahoSecurityAwareConnectionManager.connect(PentahoSecurityAwareConnectionManager.java:181)
>>>> 	at org.saiku.plugin.PentahoSecurityAwareConnectionManager.getInternalConnection(PentahoSecurityAwareConnectionManager.java:72)
>>>> 	at org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:93)
>>>> 	at org.saiku.datasources.connection.AbstractConnectionManager.getAllConnections(AbstractConnectionManager.java:119)
>>>> 	at org.saiku.datasources.connection.AbstractConnectionManager.getAllOlapConnections(AbstractConnectionManager.java:139)
>>>> 	at org.saiku.olap.discover.OlapMetaExplorer.getAllConnections(OlapMetaExplorer.java:127)
>>>> 	at org.saiku.service.olap.OlapDiscoverService.getAllConnections(OlapDiscoverService.java:56)
>>>> 
>>>> Thanks,
>>>> 
>>>> Bill.
>>>> 
>>>> On Oct 25, 2012, at 12:36 PM, William Back <wback at pentaho.com> wrote:
>>>> 
>>>>> Excellent, thanks.  I've been using Saiku for Mondrian 4 testing and this will definitely make things easier.
>>>>> 
>>>>> Bill Back.
>>>>> 
>>>>> On Oct 25, 2012, at 11:03 AM, Paul Stoellberger <p.stoellberger at gmail.com> wrote:
>>>>> 
>>>>>> Mondrian 4 is considered beta so it's about time people start using it.
>>>>>> 
>>>>>> For those of you interested playing with Mondrian 4, I have created a special saiku build that includes it.
>>>>>> You can get the saiku-server including the new foodmart schema or the saiku-plugin ready to use in the biserver here: http://ci.analytical-labs.com/job/saiku-mondrian4/
>>>>>> 
>>>>>> The build is triggered daily so new Mondrian 4 improvements get included over time.
>>>>>> 
>>>>>> The sooner you discover bugs the sooner they can get fixed!
>>>>>> 
>>>>>> Enjoy,
>>>>>> Paul
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> _______________________________________________
>>>>>> Mondrian mailing list
>>>>>> Mondrian at pentaho.org
>>>>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> 
>>>>> _______________________________________________
>>>>> Mondrian mailing list
>>>>> Mondrian at pentaho.org
>>>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>> 
>>>> _______________________________________________
>>>> Mondrian mailing list
>>>> Mondrian at pentaho.org
>>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>> 
>>> _______________________________________________
>>> Mondrian mailing list
>>> Mondrian at pentaho.org
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>> 
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130114/a536efee/attachment.html 


More information about the Mondrian mailing list