PALO BI suite is a commercial open source solution, providing an In-Memory OLAP Server, a web-based excel client, an ETL server and an Excel client.

PALO enables you to overcome the limitations of excel. It is still an application business users can master and extend, without need for help from the IT department, but at the same time it saves you from spreadsheet hell.

Its strong excel roots enables a quick adoption of the solution by business users. Its simplicity enables quicker development times, delivering results after days and not months. However it avoids the pitfalls of an excel-based solution in providing

• Server based data repository
• Data Access Security
• Web based forms
• proper modeling tools and analytic possibilities to avoid errors

Thanks to In-Memory technologies, changes to the cubes are immediately effective, which makes it particularly suitable for reporting scenarios. The ease at which you can create web-based forms only confirms this impression.

The ETL server enables automated data submission, enabling you hybrid solutions where you manually feed some figures, yet have other parts automatically submitted.

PALO has some similarities with other In-Memory OLAP servers, such as TM1, ALEA, MIK, etc. but its open-source business model makes a clear competitive advantage. An open-source solution makes you less dependent on the vendor, as the source code is freely available. In addition, the lower license fees will not stop the deployment of the application within your company.

For detailed information, have a look at www.jedox.com!