STPivot is an open source OLAP viewer tool developed by Stratebi company. It is based on the OLAP Pentaho JPivot Viewer. The idea behind this project was to improve the user experience of JPivot, through the use of graphic Libraries and Open Source technologies (for example, jQuery and Ajax).
Although the default viewer that provides Pentaho has managed to pass the test of time (completely simple, functional and crossbrowser), in Stratebi our customers ask constantly for improved versions. This is why we decided to develop STPivot, a tool in which we have take care about the visual details (UI) and interactivity with the end user.

When STPivot was initially defined, its main goal was to build a user-friendly solution (user friendly), especially focused on simple and intuitive management by the end user.

JPivot users will find a lot of matches when using STPivot, because it reuses most of the hard work done by JPivot, changing some parts of their visual appearance. The main features of STPivot are:

• Reordering the user interface.
• Ajax-based user interactions.
• Easy-to-use graphics.
• Fast, easy-to-get statistics.
• Best MDX Query Editor.
• Improved formula editor.

In the following points, we will learn more about each of them, including some of the minor additional features.

By clicking on the icon above (Olap) in the toolbar, we see on the left side a 'selector', which will allow us to choose which measures, dimensions, formulas and values, etc. will be shown in our report.

As we see in the image below, at the top of the Olap selector, we have a drop-down menu that allows us to select the cube with which we are going to work (for example, the SteelWheelsSales cube).
To its right we have:

• Which will allow us to select very easily the measures, concepts that go to rows, columns and how they are ordered.
  
  
  
  


• Refresh: Which returns us to the initial selection.

The 'Cancel' and 'Ok' buttons are very important. Once you have made changes to Columns, Rows, Slicer, Unused or Formulas, you must press Ok to be reflected in the report (table or graph) or in Cancel if not Want to keep the changes.

The way the Olap selector works is by drag & drop, so you have to select which concepts (Measurements, Geography, Time, Client...) will go on each axis: Columns, Rows, Slicer (to restrict values) and Unused (not used in the report).
To select within each concept (Measurements and dimensions), we have to click on each one of them and a selection screen appears.
For example, for 'Measures', we will see a selector like this, where in the left part we can select the members and in the right part use the' Formula Editor ',' Calculator 'or' What if ...
When finished, always press the green tick in the upper right.

MDX is the acronym of MultiDimensional eXpression, which is a query language for multidimensional databases.
STPivot uses this language to interact with the data source and display the tables or graphics.

For example:

select NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
NON EMPTY TopCount({[Markets].[Territory].Members}, 10, [Measures].[Quantity])
ON ROWS
from [SteelWheelsSales]
where {[Order Status].[Resolved]}

We can modify the code manually and press on the green tick, so that the changes are reflected in the table. You may also use the the options Functions, History or Cube in order to modify the MDX sentence..

We are going to be able to change the settings for graphics and tables.

• - For graphics (CHART), we see that you can change the chart type, size, the title, the x and y axes, etc.
  
  
  
  
• - For tables (TABLE), we can change options such as showing parents, indent members, hierarchy header, etc.