Palo Web

• Palo Spreadsheet
• Palo Pivot
• User Manager
• ETL Manager
• File Manager
• Report Manager
• OLAP Modeller

Palo Spreadsheet

Palo Spreadsheet is a powerful Web Spreadsheet Front-End, which optimizes access to Palo OLAP data.

Palo Spreadsheet offers in the web the well-known interface and handling of Microsoft Excel, but adds new features like the DynaRanges ( a dynamic formatting technology). The Palo Dyna Ranges offer the consequential method of combining spreadsheet calculation and formatting with dynamic database functions.

As the Palo Spreadsheet is very much like Excel, users are able to work productively after a brief introduction, and to create reports or planning templates in the very same way they are used from Excel. The difference is that the database will be updated in real time as soon as data is inserted – for example, if an element in a dimension is added.

In addition, Palo Spreadsheet offers functions for filtering and sorting the data from the database. The client administration system within Palo Spreadsheet, which is easy to handle, ensures that only authorized personnel can access or deal with a report. The client administration system supports, for e.g., Single Sign On by Windows Security.

Palo Spreadsheet represents a clear advancement in comparison to most spreadsheet based products

These products mostly are dynamic solutions which use Excel as a fence, but do not accomplish to amplify Excel. These products usually use their own formatting and formula, and therefore Excel functions and formula cannot be combined with the database attached.

Static products also are at disadvantage to Palo Spreadsheet. While offering the possibilities of storing data – which is better than storing them in Excel – they imply manual updating each time data changes or new data is added.

  top