Any Quality Open Source Olap ??

Post Reply
User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Any Quality Open Source Olap ??

Post by John Hobson » Mon Apr 09, 2012 10:03 pm

Now that Jedox seem to have left Palo OS to wither away are there any other OS Olap products out there that can offer a credible alternative to TM1 for planning?
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

User avatar
Alan Kirk
Site Admin
Posts: 5828
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Any Quality Open Source Olap ??

Post by Alan Kirk » Mon Apr 09, 2012 10:24 pm

John Hobson wrote:Now that Jedox seem to have left Palo OS to wither away are there any other OS Olap products out there that can offer a credible alternative to TM1 for planning?
Don't know of any open source off the top of my head. (Too much work for too little reward, I suspect, which is probably also why unpaid Palo was effectively dumped by Jedox.) Two commercial alternatives that I can think of are Infor and of course Ben Hills' Keystone.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Any Quality Open Source Olap ??

Post by John Hobson » Tue Apr 10, 2012 6:34 am

Is Infor what i knew as MIS Alea a while back?
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

User avatar
Alan Kirk
Site Admin
Posts: 5828
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Any Quality Open Source Olap ??

Post by Alan Kirk » Tue Apr 10, 2012 6:51 am

John Hobson wrote:Is Infor what i knew as MIS Alea a while back?
It's an ancestor; Infor acquired (indirectly) MIS a few years back. However I think it might be stretching the point to say that it's the same thing, any more than it is to say that there's more than a DNA connection between TM1 10.1 and the last keystrokes that left Manny's fingers all those years ago. It still has Grampa's eyes and hair colour, but the other features have doubtless changed quite a bit down the generations.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
tomok
MVP
Posts: 2481
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Any Quality Open Source Olap ??

Post by tomok » Tue Apr 10, 2012 12:15 pm

The open source model only works long term when you have a community of developers working together. With Palo, you have that community but they're not developing Palo, they're developing with Palo. The programmers at Jedox are the only ones doing any enhancement of the tool. It's kind of hard to justify paying someone to develop something you can't be paid for. I guess they weren't making enough money just charging for consulting and support. Can't say I blame them for going commercial.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Jamo
Posts: 2
Joined: Wed Feb 06, 2013 5:56 am
OLAP Product: TM1 Cognos Express
Version: 10.1
Excel Version: 2003 2010

Re: Any Quality Open Source Olap ??

Post by Jamo » Sun Mar 10, 2013 11:03 am

Taking a close look at Jedox 4 looks an improved interface, I am interested to know how well the excel to Web publishing goes.
The Web Excel however looks ok and I think this approach to building "Forms" looks like its flexible and can look very attractive.

Insight to me is just miles away, you simply cannot get enough information on one sheet, you are unable to reduce the size of the crosstab (font etc) plus the charts are minimal, surely for dashboards we need
some micro charting ability to see trends.

If someone has some limitations of Jedox be keen to hear, I'll be investing some time and effort soon to see if I can port my TM1 models over.

I hear it has not ability to "hold" for spreading, but that this is being worked on now.

Regards
Jamo

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Any Quality Open Source Olap ??

Post by John Hobson » Sun Mar 10, 2013 12:20 pm

Jedox have recently announced a change of policy as regards the OS and Premium versions of their product

With V5 due for release next month the two versions will move back into synch. For those of us who were disappointed by the build quality of the existing OS version this is great news.

The difference (I think) is going to be that the GPU processing, ETL and WEB components will only be available in Pro, so it ay be worth waiting a few weeks to see what comes out of this new initiative.

As a free OS tool Jedox 5 should prove pretty attractive to a lot of the smaller organisations (and maybe a few big ones too) as a risk free way of proving concepts. It is very easy to port models to and from TM1 and Jedox Palo.

AFAIK the existing OS version does not allow holds, and spreading is not as effective as in TM1 on calculated elements taht are enterd at N:. I don't know about Jedox V4

I had to fight a bit to get Manny Perez to accept that it was valid in TM1 to spread in a situation where for example you enter % Margin at N: and back calculate consolidations a C: levels but want to spread down from C: onto the entered N: levels.

Example :

Margin % N Product 1: 40% (entered)
Margin % N Product 1: 50% (entered)

Sales £ N Product 1: 100 (entered)
Sales £ N Product 1: 100 (entered)

Profit £ N Product 1: 40 (calculated)
Profit £ N Product 1: 50 (calculated)

Sales C: 200 (consolidated)
Profit C: 90 (consolidated)
Margin % C: 45% (calculated)

Spreading on that Margin % C: 45% is logically valid as its N: level components are all enterable.

As soon as Manny understood this he changed TM1 pretty quickly.

I haven't had the same success with Jedox so you still get illogical results when spreading on numbers like that conslidated % (It just splits is like a normal number)

Hope this helps
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

Jamo
Posts: 2
Joined: Wed Feb 06, 2013 5:56 am
OLAP Product: TM1 Cognos Express
Version: 10.1
Excel Version: 2003 2010

Re: Any Quality Open Source Olap ??

Post by Jamo » Sun Mar 10, 2013 4:09 pm

Hi John,

Thanks for the reply,
I am pretty committed to testing Jedox V4 with my complex budgeting and planing model to evaluate the functionality, I'll post a comprehensive report once its all done as its a pretty massive job to fully evaluate and it seems others may be wanting to look a this option now its starting to mature nicely.

Its the overall business case that I am questioning now in terms of the licensing TOC etc

My hope is that as a younger more agile company who are focused on the one product, maybe we can see some inovation based on feedback from us developers and users.

I think its worth my investment, Just downloaded the suite to test now so in the next month I will se how it manages my TM1 modules....

Regards
Jamo

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Any Quality Open Source Olap ??

Post by John Hobson » Wed May 08, 2013 8:09 am

Unfortunately Jedox appear to have hobbled the OS version of V5 to such an extent that it won't even load my models any more.
They have taken out significant functionality (like use of attributes)

Be very careful of using this product if you think you may need an upgrade path, as changes like that, which simply break models could give you a very nasty shock!

Ah well - TM1 is looking good again LOL.
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

lotsaram
MVP
Posts: 3121
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Any Quality Open Source Olap ??

Post by lotsaram » Wed May 08, 2013 9:25 am

John Hobson wrote:Unfortunately Jedox appear to have hobbled the OS version of V5 to such an extent that it won't even load my models any more.
They have taken out significant functionality (like use of attributes)
Was always going to happen, Jedox's concept of "open source" seemed to be always in name only and more of a marketing ploy than anything else.

User avatar
Martin Ryan
Site Admin
Posts: 1952
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Any Quality Open Source Olap ??

Post by Martin Ryan » Wed May 08, 2013 9:51 pm

There's no sight like hindsight.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Any Quality Open Source Olap ??

Post by John Hobson » Wed May 08, 2013 9:56 pm

Ain't that the truth :roll:
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

User avatar
John Hobson
Site Admin
Posts: 329
Joined: Sun May 11, 2008 4:58 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007
Location: Lytham UK
Contact:

Re: Any Quality Open Source Olap ??

Post by John Hobson » Mon May 25, 2015 8:29 am

Any recent developments in Opens Source OLAP I ought to know about?
John Hobson
The Planning Factory

TM1 10.2.0 / Win7 / XL 2010

User avatar
Alan Kirk
Site Admin
Posts: 5828
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Any Quality Open Source Olap ??

Post by Alan Kirk » Sat Jul 18, 2015 12:49 am

John Hobson, almost 2 months ago, wrote:Any recent developments in Open Source OLAP I ought to know about?
I think the breeze flowing around the long-abandoned livery stable, the small dust clouds near the decrepit hitching rails, and the tumbleweeds rolling past the weathered woodwork of the former saloon are in themselves an eloquent answer to this.

I'm wondering if open source anything has in fact reached its zenith and is at the start of a long, slow decline. It's easy to be generous with your time and write cool code when you're getting a respectable salary for doing similar work during the day. But with IT work also devolving to "a lower overall cost structure" (and we all know what that's a euphemism for), it's harder to justify spending your hours doing much work for no return. (Or no return aside from a limited value of fame.) I honestly can't imagine why anyone would want to put in the time to develop a new open source OLAP project these days.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
jim wood
Site Admin
Posts: 3598
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Any Quality Open Source Olap ??

Post by jim wood » Mon Jul 20, 2015 12:04 pm

I think the whole "get rich quick" phone development stories haven't helped either. Historically getting free code out there used to be a good way to get known in the coding community. These days you just have to write an app.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

ninow
Posts: 2
Joined: Fri Jun 10, 2011 12:41 am
OLAP Product: PowerOLAP and TM1
Version: 9.1
Excel Version: 2007

Re: Any Quality Open Source Olap ??

Post by ninow » Tue Jul 21, 2015 3:06 am

Hello Colleagues,
I played with Palo in the early days up till 3.2 but never trusted it to be supported long term as open source.
I do not know of good open source but I have had a long standing relationship with PARISTechnologies who make PowerOLAP.
I have implemented PowerOLAP with serious clients using big models and at all times have had excellent support from PARISTech.
They do offer a 'personal edition' that has a limitation on number of cubes, dimensions and members and very inexpensive for the smaller business. (This makes it 'almost' free).
I have done a lot of development with TM1 and Hyperion so I do understand and know the products.
This may be of interest, I would be pleased to know of anyone's experiences if they try it.
Cheers
Ray

Post Reply