[Mondrian] Mondrian 4, Pentaho 6 CE, Saiko

Wed Apr 6 08:58:34 EDT 2016

Yeah, I didn’t quite expect that reaction, but was an interesting spectator sport!!
So, clearly it’s possible ;-)
Any pointers on achieving the same?
I.e. Mondrian 4 in BI Server CE 6 with Saiku plugin
Thanks for the time in looking into this
Conrad

From: <mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>> on behalf of Tom Barber <tom at analytical-labs.com<mailto:tom at analytical-labs.com>>
Reply-To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Wednesday, 6 April 2016 at 13:03
To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Mondrian 4, Pentaho 6 CE, Saiko

Look at this hornets nest your stirred up Conrad! ;)

Anyway back to the topic in hand, I played around this morning, it needs a biit more work to tidy it up, but

https://ibin.co/2cox8ELbkPLy.png

[cid:ii_imot2q030_153eb7471d4a71cd]

There's Saiku 3 running Mondrian 4 in Pentaho 6.

Tom

--------------

Director Meteorite.bi - Saiku Analytics Founder
Tel: +44(0)5603641316

(Thanks to the Saiku community we reached our Kickstart<http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/> goal, but you can always help by sponsoring the project<http://www.meteorite.bi/products/saiku/sponsorship>)

On 6 April 2016 at 11:46, Julian Hyde <julianhyde at gmail.com<mailto:julianhyde at gmail.com>> wrote:
Pentaho is doing a fine job of maintaining Mondrian 3, but the changes are just refinements and bug fixes, nothing radical.

There are quite a few companies investing in OLAP on Hadoop and I think they would be interested in developing Mondrian if it had an Apache license, a more open governance model, and the opportunity for more radical change.

On the subject of governance. Over the last couple of weeks I've been trying to get olap4j functioning as a community again. This means going through the backlog of pull requests and committing the ones that are ready. It means making releases, including source code and javadoc, of olap4j and olap4j-xmlaserver, on Maven Central. Because that's what people expect these days.

And it's working. There's been a surge in interest on the olap4j-devel mailing list, and in github, and pull requests are coming in with improvements people have been making to the XMLA server.

I next plan to get an olap4j 2.0 release out, so that people can access the entities and attributes added to recent versions of XML/A. That includes Mondrian features such as measure groups and attribute hierarchies.

I'll be asking to make a release of Mondrian 4 -- off of a side branch, with a version number like 4.6.0-olap4j2 -- so that olap4j has a reference implementation to work against.

Julian

On Wed, Apr 6, 2016 at 3:26 AM, Dan <dan at dankeeley.co.uk<mailto:dan at dankeeley.co.uk>> wrote:

It's not the license it's the ownership. Why would your competitors contribute  to your product?

Put it in Asf, maintain your own quirks if you must (and proprietary interfaces fine! ) and everyone contributes to a common goal.

There's no doubt you would get more comitters in Asf. Maybe even jasper /tibco ☺

Sent from my phone

On 6 Apr 2016 10:47, "Pedro Alves" <pmgalves at gmail.com<mailto:pmgalves at gmail.com>> wrote:

I think the problem is that there's tons of stuff shared between m3 and m4, but I'm not a legal guy. I'll ask...

However, I kinda don't understand what stops that work to happen over the existing EPL license....  But like I said, my knowledge around legal stuff is pretty much inexistent... :(

On Apr 6, 2016 10:43 AM, "Dan" <dan at dankeeley.co.uk<mailto:dan at dankeeley.co.uk>> wrote:

Pedro that's a great point.

What if others would help with m4?

Why not put m4 (not 3) into Asf? (Apache software foundation)  You'd get loads more support and help.

Plus the cynic would say you'd get great pr.

Well?

Sent from my phone

On 6 Apr 2016 10:33, "Pedro Alves" <pmgalves at gmail.com<mailto:pmgalves at gmail.com>> wrote:

Guys, simply put, pentaho uses and will continue to use Mondrian 3.

For the needs of our users (customers and community) m4, unfortunately, isn't ready yet and to get there there's a heavy investment involved that we're not sure if makes sense for us to do alone. To be clear, by "it's not ready", I'm talking about functionality parity to what can be done today with m3. While it's clear to be that, architecturally speaking, m4 may be superior, in the field that's not reason alone to make such an important decision.

My recommendation is, within pentaho, use Mondrian 3. It's what we maintain, fix and improve

-pedro

On Apr 6, 2016 10:23 AM, "Tom Barber" <tom at analytical-labs.com<mailto:tom at analytical-labs.com>> wrote:
Bleh, I might have been lying that might be EE only. 10 mins, I'll see what I can dig up.

--------------

Director Meteorite.bi - Saiku Analytics Founder
Tel: +44(0)5603641316<tel:%2B44%280%295603641316>

(Thanks to the Saiku community we reached our Kickstart<http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/> goal, but you can always help by sponsoring the project<http://www.meteorite.bi/products/saiku/sponsorship>)

On 6 April 2016 at 10:22, Tom Barber <tom at analytical-labs.com<mailto:tom at analytical-labs.com>> wrote:
FWIW the stuff in the blog post doesn't work for Saiku in 5.x either :)

Basically the later versions of 5.x and 6 ship Mondrian 4 for the Mongo stuff, you can't drop the libs in, the question is though, can we expose that engine to Saiku as a BI Server plugin. I added some connectivity stuff to tell Saiku to use mondrian 4 with certain data sources in the BI server, but I don't think the OSGI based Mondrian 4 engine is available.

Tom

--------------

Director Meteorite.bi - Saiku Analytics Founder
Tel: +44(0)5603641316<tel:%2B44%280%295603641316>

(Thanks to the Saiku community we reached our Kickstart<http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/> goal, but you can always help by sponsoring the project<http://www.meteorite.bi/products/saiku/sponsorship>)

On 6 April 2016 at 10:18, Conrad Crampton <conrad.crampton at secdata.com<mailto:conrad.crampton at secdata.com>> wrote:
Thanks for comments so far (and the offer Tom).
So, as it stands currently my choices appear to use BI Server 6 CE with Mondrian 3.11 (with Saiku too) or move down to 5.x with 4 (following the blog post mentioned previously).

I’m interested in the comment ". Pentaho 6 ships Mondrian 4 in the OSGI land” - does this mean that I can simply drop in the Mondrian 4 libs into BI Server lib directory?

Thanks
Conrad

From: <mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org>> on behalf of Tom Barber <tom at analytical-labs.com<mailto:tom at analytical-labs.com>>
Reply-To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Date: Wednesday, 6 April 2016 at 08:29
To: Mondrian developer mailing list <mondrian at pentaho.org<mailto:mondrian at pentaho.org>>
Subject: Re: [Mondrian] Mondrian 4, Pentaho 6 CE, Saiko

For Pentaho 5.x I did the CM4 plugin which sorta worked for a while. Pentaho 6 ships Mondrian 4 in the OSGI land, if someone has the time, or wants to sponsor an investigation into exposing that library to Saiku, we'll be able to hook up to it with little difficulty, just depends how easy it is to access.

Tom

--------------

Director Meteorite.bi - Saiku Analytics Founder
Tel: +44(0)5603641316<tel:%2B44%280%295603641316>

(Thanks to the Saiku community we reached our Kickstart<http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/> goal, but you can always help by sponsoring the project<http://www.meteorite.bi/products/saiku/sponsorship>)

On 6 April 2016 at 08:27, Dan Keeley <dan at dankeeley.co.uk<mailto:dan at dankeeley.co.uk>> wrote:

This is a good question, unfortunately there's no easy answer. I suggest posting it on the Pentaho community mailing list though, you may get more traction.

Essentially Pentaho just haven't got the guts (or confidence in their test team) to move to Mondrian 4 - everything they've done recently shows no commitment to it.  Even to the point where new features are still going into Mondrian3.  I spoke to the head of dev about it a few years ago and he just said why do you want mondrian 4? he couldnt see why I was asking.

But more often than not they do surprise us.  So I could be wrong :)

On Tue, 5 Apr 2016 16:30:50 +0000, Conrad Crampton <conrad.crampton at SecData.com<mailto:conrad.crampton at SecData.com>> wrote:

Hi,
I’ve read the blog post [1] by Will Gorman which discusses Mondrian 4 installation into Pentaho 5.1, but this is from June 2014. I am looking for something a bit more recent that points in the direction of using the latest Pentaho 6 CE with Mondrian 4 (and preferably with Saiku).
I have the Mondrian in Action book which is based on Mondrian 4 so coming to this a new it makes sense (to me) to start on v4, but I am a little frustrated by Pentaho CE only having Mondrian v3.11 with it. I haven’t tried it (so that may just be the answer) but will the instructions in [1] get me to where I want to be with Mondrian 4 and BI Server 6 CE (and will Mondrian be able to be work with all the other data sources)?
Sorry for all the questions, just trying to get started from a new installation with little knowledge.
Thanks
Conrad
[1] http://www.willgorman.com/?p=58

SecureData, combating cyber threats

________________________________

The information contained in this message or any of its attachments may be privileged and confidential and intended for the exclusive use of the intended recipient. If you are not the intended recipient any disclosure, reproduction, distribution or other dissemination or use of this communications is strictly prohibited. The views expressed in this email are those of the individual and not necessarily of SecureData Europe Ltd. Any prices quoted are only valid if followed up by a formal written quote.

SecureData Europe Limited. Registered in England & Wales 04365896. Registered Address: SecureData House, Hermitage Court, Hermitage Lane, Maidstone, Kent, ME16 9NT

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

***This email originated outside SecureData***

Click here<https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ==> to report this email as spam.

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>
http://lists.pentaho.org/mailman/listinfo/mondrian

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org<mailto: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/20160406/189d9476/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled.png
Type: image/png
Size: 34448 bytes
Desc: Untitled.png
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20160406/189d9476/attachment-0001.png 