STPivot is an open source web based OLAP viewer, developed by Todo BI – Stratebi, based on default Pivot viewer provided by Pentaho, writen on top of JPivot. The idea behind this project was to improve JPivot user's experience, by taking advantage of free user interface libraries and technologies (such as jQuery and Ajax).

STpivot Web


Although default Pivot viewer in Pentaho have successfully pass the test of time (fully simple, functional and crossbrowser), in Stratebi our clients constantly asked for improved versions (closer to the state of the art). That´s why we develop STPivot, giving special attention to user interface and interactions (foreground).

 

Main features included are:

  • Ajax interface
  • Use of jQuery to handle user interactions
  • Highlighted MDX syntax in the editor
  • Easier edition of charts (resizing with mouse, icons for options)
  • New set of icons
  • Formula Editor
  • Min, Max, AVG, SUM
  • Save Option
  • UI improvements
  • Set of documents and samples
  • Clickable members

 

 

You can see a Video Demo:

Web Content Display Web Content Display


Web Content Display Web Content Display

     

  • STPivot improve user experience and adds key features of Pentaho OLAP viewer.
  • A powerful and intuitive formula editor, calculations on the fly (sum, avg, max, min) and many other new features.