Deutsch

Palo Pivot

The Palo Pivot provides browsing functionalities to view and edit Palo Server data, just like with the Palo Client. You can open cubes, change the dimensions assignment and change the selected element for the filter dimensions using the mouse. Nesting of dimensions and expand or collapsing of dimension hierarchies is also supported. The Palo Pivot also allows the access to XMLA based databases. This way you can access and view cubes from Microsoft Analysis Services Databases, SAP BW or Mondrian OLAP Databases. Cell Values or consolidated values can be edited. You can view multiple cubes in parallel.

Views can be saved and reloaded. Views created with the Palo Client can be imported by the Palo Pivot. Subsets already defined within the Palo Client can also be used to filter dimension elements within the cube browser.

The Palo Pivot does not provide modelling capabilities.

The Palo Pivot is developed using Ajax technologies. You only need a common browser and no additional software installation on the client is necessary. On the server side a Tomcat Applications Server is a prerequisite.

To top

Demo Palo Pivot 3.2

Integrated in a HTML site

The following example is integrated into the HTML code. Different elements of the web client can be shown or hide. The views of the reports can be edited like in the Palo Client.

For this demo report we have restricted the user rights so it is not possible to edit cell data or to save the view. The username and passowrd are "direct-link/direct-link"

Show integrated application with these options...

Navigator

View tabs

Auto login

Auto user

Open in a separate window

As a web application ´

Please click on the "Start Demo" button. After starting you will get to the database explorer to open cubes from different databases. To demonstrate different user situations please use one of the following credentials:

Login	Password
editor	editor
viewer	viewer

With the version that runs on our demo server, you can view a sample repository that we created for the evaluation of the Palo Pivot.

Expand the elements of the overview and create new views from cubes for viewing by clicking on it. Within this view you can drag and drop the dimensions and assign them to an axis and select new elements for the filter dimensions. You can create you own views and save them. The database is restored over night and therefore you changes will be lost after that is completed.

We recommend Firefox or Crome for best results and performance.

To top

Download Palo Pivot 3.2

Click on the button below to download the latest Palo Pivot and previous versions. Read the installation info provided in the file "install.txt".

To top

Features

Database Explorer

Single Sign On across multiple databases
View servers and databases
View cubes and views
Open a cube or view
Optional display of filter dimensions

Favorite View

To easily view and access frequently used views
User rights for forlder and views
Selection of Subsets, Aliasses and Hierarchies

Cube Browser

Open a cube for 'Slice and Dice' operations
Drag and Drop of dimensions into horizontal or vertical axes
Nesting of dimensions
Change of the selected element of the filter dimension
Collapse or expand a consolidation hierarchy
Write back cell values
Summierung der Hierarchien wahlweise unter- und oberhalb der Gruppe
Einsetzen von Subsets, Filter und Alias
Nullzeilen und -spalten Unterdrückung
Zeilen mit Regeln hervorheben
Dimensionen für den View Modus einfrieren

Reporting

Access of any number of viewers with different access profile.
Import views created with the Palo Client
New views can be created and saved and published this way
Simultanious viewing of different cubes or views using tabs

To top

Roadmap

Palo Pivot

not published yet.

Title bar	Toolbar	Filter	Horizontal axis
	Save button	Static filter	Vertical axis

Title bar	Toolbar	Filter	Horizontal axis
	Save button	Static filter	Vertical axis

Title bar	Toolbar	Filter	Horizontal axis
	Save button	Static filter	Vertical axis