[Mondrian] Saiku Mondrian 4 builds

Thu Oct 25 18:39:37 EDT 2012

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/20121026/201f9d36/attachment-0001.html 