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


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.


28 Sep 2007: PalOOCa 0.2.0 Release

PalOOCa 0.2.0 is now available. It includes write-back support as well as GUI related features like the "Insert Element" and "Insert Function" wizard. Also several new functions were added to enhance the compatibility with the Palo Excel addin.
Please test this version and report back any bugs you may find.


11 Sep 2007: PalOOCa 0.1.5 Release

Version 0.1.5 is a huge step from the previous Alpha3. The code got restructured and is now split in several classes. Also the connection manager was (nearly) completely rewritten and now includes an user interface to manage profiles and connect/disconnect the associated connections. This also extends compatibility with the Palo Excel plugin, as they now use a common connection string.
Several addin functions got a rework too, to show a more standardized behavior. For example it does no longer show exception messages.
There is still much to do, but a read-only version with most of the required (UI) functions will be available soon.

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