Welcome!

The PalOOCa Project offers the first complete Open Source MOLAP-Stack for fast, flexible and intuitive Office-based Business Intelligence. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Open Source OLAP Server Palo via Calc.

Download

Download PalOOCaDownload PlusDownload OpenOffice.orgDownload PlusDownload Palo

see more on page downloads.

Project News


6 Oct 2014: PalOOCa 5.2 is released:

-Usability improvements
-Bug fixes

The plugin is recommended in combination with the Colibri Open BI Appliance: see http://proclos.com


8 May 2014: PalOOCa 5.1 is released:

-New support for Jedox 5.1 OLAP servers.
-Enhanced Options
-Bug fixes

The plugin is recommended in combination with the Colibri Open BI Appliance: see http://proclos.com


9 Jul 2013: PalOOCa 5.0 Release

This new version is heavily optimised for navigating large views containing many thousand filled cells. Additionally many bugs have been fixed.
It is designed for interaction with palo server 5.x but is backwards compatible to palo 3.2.
It also supports other OLAP servers via XMLA protocol, such as Mondrian and others.


17 Oct 2008: PalOOCa 1.1.0 Release

The next important PalOOCa version is now ready to be downloaded.

It includes several usability enhancements and fixes. Some function names were displayed incorrectly and have been corrected now.

A new menu item can be found in the Palo menu, allowing to "snapshot" the current document. This will remove any formulas and/or disable all control element so that the document can be used offline without a connection to the Palo server.

The modeler has been enhanced with a flat element list to allow easier consolidations.

Thanks for your interest and continuing support!


3 Jul 2008: PalOOCa 1.0.0 Release

It's done! We present the 1.0.0 of PalOOCa.

This release includes some small changes and an extended installation guide.

Special thanks to all of our supporters!


14 May 2008: PalOOCa 0.9.1 Release

After some more feedback from users a few bugs have been identified and fixed. Thanks for your support!

The changelog in detail:
- Added an Edit-button to the connection manager (instead of the hint explaining the double click)
- Fixed spelling of "Modeler"
- Fixed deletion of dimensions not immediately updating the tree
- Fixed deletion of consolidations not correctly updating the former parent element


15 Apr 2008: PalOOCa 0.9.0 Release

This new release mainly concentrates on the modeler but also fixes some other bugs reported by users (thanks to all who help improve this project!). The change log reads as follows:

Modeler:
- Added consolidation handling
- Added dimension selection to the element view
- Changed the connection combo box to automatically trigger the connection
- Fixed cube creation

Addin:
- Fixed write-back of cells with zero-value
- Fixed crashes on Gnome

Please keep making suggestions for improvements!


28 Feb 2008: PalOOCa: Version 0.8.0 Release

PalOOCa is a Java based OpenOffice OLAP Add-On intended to be used with OpenOffice Calc. It is supposed to be the equivalent to the Palo Add-in for MS Excel (http://www.palo.net).

It took a while longer before I was able to test this release but finally it is done.
Version 0.8.0 includes a first version of the promised modeller aswell as the ability to localize most of the dialogs. I also localized it into German to give an example how it is done.


17 Nov 2007: PalOOCa 0.4.0 Release

Another update towards Excel compatibility: matrix functions and import functions have been introduced. The complete change log is as follows:

- Added matrix functions:
* DATABASE_LIST_DIMENSIONS
* CUBE_LIST_DIMENSIONS
* DIMENSION_LIST_CUBES
* DIMENSION_LIST_ELEMENTS
* ELEMENT_LIST_CONSOLIDATION_ELEMENTS
- Added import functions:
* SETDATA
* EADD
* EDELETE
* ERENAME
* CLEARDIMENSION
- Added GUI to control the import
- Added missing/incomplete descriptions

As usual, please report back any problems or wishes.


9 Oct 2007: PalOOCa 0.3.0 Release

We are making large steps towards a 1.0 Release. There are still several things to do (like data import and the modeler) but the new 0.3.0 Beta can already serve analytical purpose.
The main new feature introduced in this version is the "Create View". It allows to fill a spreadsheet from a constellation of dimensions and their elements. You can then modify the data or just alter the view (by expanding and collapsing elements or by completely redesigning it with the "Edit View" dialog). The design is completely based on the OpenOffice.org Format settings so you can change them easily.

Stay tuned for further updates and please report any bugs or inconveniences you encounter.

Screenshot Management Cockpit with PalOOCa 01

click to enlarge, see more on page details.

What Is It All About? - Introduction For Business Intelligence Newbies


Chemnitz University of Technology Logo Proclos Logo Get PalOOCa OpenOffice Extension for Palo at SourceForge.net. Fast, secure and Free Open Source software downloads