Palo Client

The Palo Client provides complete modelling and administration capabilities for the Palo Server.

The database explorer, contained in this application, allows the fast access to all elements of the databases residing in multiple Palo Servers. You can easily manage cubes, dimensions or elements by double clicking on the item in the database explorer using the intuitive screens to edit the database items.

An adhoc browser allows the viewing and editing of cube data. Within this browser or cube editor you can assign dimensions to the vertical or horizontal axes and you are able to nest those. The filter dimensions or slice elements can be selected from the remaining dimensions using tree selection boxes. Often used views can be saved and restored for future use. A favorite view allows an easy access to these views. For the more intuitive editing of rules a new view for editing and creating rules is available within the Palo Client.

Palo Client

The Subset editor allows the dialog based editing and creation of subsets. The editor offers the same subset options as the subsets within the Excel Add-in. They are also saved in the same location on the server. The Client also benefits from the load on demand option of the API. Metadata will only be loaded on demand and cached locally. This approach speeds up the access to large databases.

Another highlight is the access to XMLA databases. If you connect to an XMLA database, you have the same options for viewing OLAP Cubes like with Palo Cubes. XMLA is supported upon other by Microsoft Analysis Services, SAP BW or Mondrian. XMLA based databases can not be modelled within the Palo Client since this is not supported by the XMLA interface.

All Features of the Palo Server are supported. The client can run standalone or be integrated into the Eclipse Development Environment. Check the Demo below, which is also provided as an 'Web Start' application.

Palo Client Pie Chart

• Tree view of all objects (Databases, Cubes, Dimensions, Elements, Views...) of the Palo Server
• Open selected elements for editing the contents

• Drag and Drop of dimensions into the horizontal or vertical Axis
• Nesting of dimensions
• Change the Point-of-View by selecting an element from a filter or slice dimension
• Expanding and collapsing of consolidation hierarchies
• Editing of multiple cube browsers or views in parallel by using tabs
• Filter dimension elements
• Write back of values
• Usage of aliases
• Usage of XMLA-Hierarchies
• Formatting by using attributes

• Comfortable modelling by using intuitive dialogs for creating, editing and deleting elements, dimensions, cubes and databases.
• Editing of consolidations
• Creating, editing and deleting of attributes and aliases
• Definition of subsets (filtered element lists) for usage within the cube browser
• Definition of rules by using an intuitive rule editor
• Graphical modelling view to view dimension hierarchies and subset or dimension dependencies

• Creation of views out of the cube browser.
• Subsets and local filter s
• Internationalisation by using aliases
• Top-Down/Bottom-Up view of sums
• Favorites View
  Management of a user dependent list of favorite views
  Group views by using folders
• Formatting Views
  Formatting of rows or columns using fonts, background colors or number formats
  Suppress empty rows or columns

• User and group management
• Assignment of rights for reading, writing or editing of database objects
• Configuration of access rights

Palo Client 2.0 for Windows
(Build 2.0.0.214)

Palo Client 2.0 for Linux
(Build 2.0.0.214)