STOlap is an open source OLAP viewer tool developed by Stratebi company. It is based on the OLAP Pentaho pivot4J Viewer.

With this tool we provide:

• Better and more intuitive UI
• Better interaction with end user.

We enumerate some of the most relevant features of this OLAP Analysis tool:

• STOlap is Pentaho plugin for visualizing OLAP cubes.
• Deploys as Pentaho Plugin
• Supports Mondrian 4!
• Improves Pentaho user experience.
• Intuitive UI with Drag & Drop for Measures, Dimensions and Filters
• Adds key features to Pentaho OLAP viewer replacing JPivot.
• Easy multi-level member selection.

On the home page of the Pentaho User Console, you have to clic on the STOlap button.

Then you have to select the scheme and afterwards select the cube.

Once you have done that you will be redirect into the development page, from where you can design which information to watch and how.

At the top we can see the following options:

On the left side, we can see the icons of OLAP and MDX:

• From here we have the hability to create new measures or modify existing ones, once we clic it three more icons shows up, the first one will display this window.

  

  From there we can create a new measure.
  The next icon is used to modify the agregation used in the rows and columns of the data displayed. The menu throught the one we can accomplish that task look like this.

  

• We have two icons in this field, first one is and it allows us to modify the queries over the measures of the cube we have already selected, once we clic it we can see this wizard.

  

  The second one is and it is useful to format the result we are going to analyse, for example setting certain calculation to a red color because it is bellow 0. The wizard looks like this

  

• From here we can select which visual we would like to have to show the data.

• From here we can modify a few caracteristics of the table that will contain the data. Like pivot the rows and the columns, allows drill-down or not showing blank cells...

  

• From here the end user is able to export, automate the refresh, see the history or email the data.

  

We will explain briefly the next components:

• Toolbar
• OLAP Navigator
• Edit/View Switch Button
• Rows Layout
• Columns Layout
• Filters Layout

There is a bar in which we can select the feature we as users want to use:

This component has two parts, above we have a dropdown selector where we can change the cube we are analysing and bellow this we have all the measures and dimensions of the cube listed.

This button basically allows the end user to switch from the page where they select which information show to the actual page where that information shows up, including the chart selected.

• Edit Button, when marked as active means we are on the page to select the information we need to see.

• View Button, when marked as active means we are able to see the information and the chart we selected previously.

  

It is placed between the OLAP Navigator and the Filters Layout, here we can drag and drop fields of the dimensions of the cube, so when printed it will show for the rows the diferent values of that field.

In the above image we have the "Product Subcategory" field from the "Product" dimension.

It is placed above the Filters Layout, here we can drag and drop fields of the dimensions of the cube or measures, so when printed it will show for the columns the diferent values of that field or the calculation of that measure for the diferent value of the pertinent row.

In the above image we have the measure "Store Invoice".

It is placed bellow the Columns Layout, and next to the Rows Layout.

In the image we have a filter about the year we want to show which is 1997.

We will see in the next image the way this tool prints the data.

As we can see on the rows we have the Product Subcategory extended to see the inferior levels of the hierarchy, and for the columns we can see the calculation of the total Store Invoice produced by each product.

We will see in the next image the line chart of the information selected.