Jedox

New Palo Server 2.0 From Jedox Up To 10 Times Faster Than Previous Version

October 9, 2007 By BI Editor

Open Source Business Intelligence (BI) does not have to be slower than commercial solutions. On the contrary, the processing time of Palo Server 2.0 has picked up 10 times the speed compared to its previous version and in-memory OLAP database applications used for planning, reporting, consolidation and analysis run that much faster. In fact, BI applications based on Palo 2.0 may run faster than popular commercial BI solutions.

Palo Server facilitates high speed by keeping processed data in memory (In-Memory OLAP). Queries for base and also aggregated data cells take place in real-time and provide results quickly. With that, Palo Server provides a great contrast to popular multidimensional databases, which are based on relational technologies (ROLAP). Further, in-memory planning – both top/down as well as bottom/up – is supported by the functionality to write-back data into the cubes. [Read more…]

Palo: Business Intelligence for OpenOffice.org

January 31, 2007 By BI Editor

The Open-Source companies Jedox GmbH and Tensegrity GmbH, the Chemnitz University of Technology and the Australian company De Bortoli Wines started a cooperation for the development of a Business Intelligence Add-In for OpenOffice.org. They now seek additional sponsors to start the project.

A combination of Spreadsheet-Software plus a capable server for Business Intelligence and OLAP becomes more and more popular. While Microsoft offers the combination of MS Office and Office PerformancePoint Server as a comprehensive BI solution, there is a sophisticated and free alternative: the Open Source based Palo Server. For Palo version 1.5 there already is a free Add-In available which helps convert Excel 200, XP, 2003 and 2007 into a server based solution for analysis and planning.

More and more companies are realizing the value of using Open Source software in the enterprise. Since Palo was launched around a year ago, this Open Source product has not only been embraced by a large number of individual users, but also various larger organizations, such as the German Chamber of Commerce (Deutscher Industrie- und Handelskammertag), ALTANA Pharma Germany and now also De Bortoli Wines, one of Australia’s larger privately owned companies. [Read more…]

Open-Source Business Intelligence Makes its Way into the Pharmaceutical Industry

October 30, 2006 By BI Editor

German based ALTANA Pharma successfully implements full-scale scorecard solution based on Open-Source OLAP database “Palo”.

ALTANA Pharma Deutschland GmbH utilise Palo (www.palo.net) for their “Selling Excellence Program”. Palo, an Open Source database developed by the Jedox (www.jedox.com), is used as a centrally accessible data storage in an application which, based on Key Performance Indicators, depicts and analyses sales performance and trends for 36 sales regions with more than 400 sales districts.

In order to achieve this, Altana elaborated a catalogue of KPIs based on the “European Best Practice Approach”. These KPIs now serve as measurement categories for success and competitiveness. The scorecards, which are based on these KPIs, not only show quantitative measures but also visualise current trends in dynamically generated arrow charts. All scorecard data are held centrally in the multidimensional data model of the Palo server. Scorecards were rolled out to the field sales reps with the help of Worksheet-Server, an Excel-to-Web solution also offered by Jedox. Data are thus accessible for evaluation to all authorised team members through both Excel and a web browser.

“With Palo & Worksheet-Server, we have managed for the first time a system rollout during which User-Trainings and the information content, but not the technique were the main subject. With a small but efficient team of specialists plus Jedox, this project was realised in a uniquely short time”, says Gerhard Klingele, Director Finance and Controlling at ALTANA Pharma Deutschland GmbH.

Further information about this project is available on Jedox’s home page www.jedox.com, together with information on the whole range of solutions offered in the field of business analysis and planning.