Installing Palo BI Suite 3.0

Palo is an open source MOLAP server. It's primarily designed to work with excel, coming with an excel add-in. There's also an openoffice extension, palo for openoffice add-in, that can be used for integration with openoffice calc.

Prerequisites
.NET framework 2.0
MS Excel or OpenOffice calc

Versions used
Palo 3.0
OpenOffice calc 3.1.0
Palo for openoffice addin 2.0.1

Steps

1. Download the Palo BI suite from the palo website, jedox.com
2. Run the setup file
3. Install to c:\Palo
4. Download the palo for openoffice addin from http://extensions.services.openoffice.org/en/project/PaloOpenOffice
5. Start openoffice calc
6. Select the Tools | Extension manager menu
7. Click on the Add button and select the PalOOCa.oxt file downloaded.
8. Close calc after the addin has installed
9. Open calc
10. You'll have a new menu in the menu bar named Palo
11. Click on the Palo | Modeler menuClick on the edit connection icon to edit the details for the localhost connection. Set the port to 7921, username to admin and password to admin.
12. Click on the connect to server icon to connect to the server on localhost.

To connect to a mondrian schema, and use OpenOffice to browse mondrian olap cubes,

• Click on the Palo | Modeler menu
• Click on the create connection icon. Fill the following for the host and port, or similar values corresponding to the mondrian server setup

Host – localhost:8080
Port – mondrian/xmla

• Click on the connect to server icon to connect to the mondrian server
• Click on close once the connection is established
• Click on the Palo | Insert View menu
• Select the appropriate database and dimensions to view then click on the create button