Any Quality Open Source Olap ??
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Any Quality Open Source Olap ??
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
The Planning Factory
- Alan Kirk
- Site Admin
- Posts: 6622
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Any Quality Open Source Olap ??
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.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?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: Any Quality Open Source Olap ??
Is Infor what i knew as MIS Alea a while back?
John Hobson
The Planning Factory
The Planning Factory
- Alan Kirk
- Site Admin
- Posts: 6622
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Any Quality Open Source Olap ??
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.John Hobson wrote:Is Infor what i knew as MIS Alea a while back?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 2834
- 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 ??
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.
-
- 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 ??
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
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
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: Any Quality Open Source Olap ??
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
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
The Planning Factory
-
- 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 ??
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
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
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: Any Quality Open Source Olap ??
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.
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
The Planning Factory
-
- MVP
- Posts: 3684
- 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 ??
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.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)
- Martin Ryan
- Site Admin
- Posts: 1989
- 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 ??
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
Jodi Ryan Family Lawyer
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: Any Quality Open Source Olap ??
Any recent developments in Opens Source OLAP I ought to know about?
John Hobson
The Planning Factory
The Planning Factory
- Alan Kirk
- Site Admin
- Posts: 6622
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Any Quality Open Source Olap ??
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.John Hobson, almost 2 months ago, wrote:Any recent developments in Open Source OLAP I ought to know about?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Any Quality Open Source Olap ??
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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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 ??
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
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
- Elessar
- Community Contributor
- Posts: 394
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Any Quality Open Source Olap ??
Hello everybody!
10 years have passed, so I want to revive this topic.
Is there any open-source OLAP with planning capabilities now? Jedox has become commercial, leaving the last open-source 5.1 version in 2015.
10 years have passed, so I want to revive this topic.
Is there any open-source OLAP with planning capabilities now? Jedox has become commercial, leaving the last open-source 5.1 version in 2015.
-
- Posts: 117
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Any Quality Open Source Olap ??
The only thing that comes to mind for open source OLAP is this recent blog post: https://community.ibm.com/community/use ... source-tm1
-
- MVP
- Posts: 3684
- 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 ??
Well there's tinyolap https://tinyolap.com/
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Elessar
- Community Contributor
- Posts: 394
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Any Quality Open Source Olap ??
Wow many thanks!lotsaram wrote: ↑Thu Jun 29, 2023 2:01 pm Well there's tinyolap https://tinyolap.com/
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.