Here we explain the Business Intelligence tool STOlap.
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.
In this section we will see different concepts of STOlap.
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.
In this section we will explain the diferent layouts of the tool, the diferent features are already explained in the previous section. So here
we will go throught how the user actually uses those features in the tool.
We will explain briefly the next components:
Edit/View Switch Button
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.
In this section we will see the results obtained of the data selected in the previous section with the adition of a line chart.
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.