STPivot Open Source OLAP tool
Main Features an Download
You can download open source code from Github. We´ll be grateful of helping you in your Business Intelligence projects using Open Source tools if you need support, development and consultancy. We´d like to receive your feedback: firstname.lastname@example.org
We've created a new popup window where end users can easily select dimension values, measures, levels... for their queries. It includes a new search feature that improves value selection with high cardinality dimensions.
In your design window, end users can drag and drop their dimensions, filters and measures quickly and easily.
New search functionality
One of the best new features of STPivot is the ability of search dimension values easily, when you manage a great number of values.
This is very helpful when you need to identify your desired values on each level/dimension/hierarchy in order to include them in our query result.
Drag and Drop query design and build
If sometime you wanted to build your queries easily and quickly, with this visuall drag and drop design now it´s possible.
Filter and drill to detail
One of the best functionalities of any OLAP Viewer is the possibility of drill through any dimension and measure in order to get powerful insights about yor data models.
It´s included advance filters within the Selector, so you can leverage all the power of OLAP cubes, refining your queries and nesting each filter.
Ranking Top Count
Ranking Bottom Count
Graphics and Visualization
STPivot includes a great variety of graphic libraries (pie, chart, heatmaps, line, bar...) fully configurable with popup information for any of your analytical needs.
All the simplicity and power for end users, so they can directly create their own formulas with a friendly interface, in order to include them in their OLAP views.
Multidimensional analysis (OLAP) gives advanced users and analysts the full power of cross-checking data at all levels, getting key answers in almost real time.
From weeks to minutes so is the power of multidimensional OLAP solutions we work with. No need to rely on knowledge or technology departments, users can make their own advanced adhoc analysis.
Everything an analyst needs for a query, analytical reporting and decision making: charts, graphics capability, drill down, drill to detail, export to different formats, securization by roles, ...
The multidimensional analysis provides data access at high speed, thanks to its multidimensional design. One structe oriented to the analysis and decision making.
See some examples of OLAP cubes in operation in our Demos section.
Pentaho Open BI is the world's leading source solution. It has become a great alternative to costly traditional business intelligence systems such as Oracle, Business Objects, Cognos, QlikView or Microstrategy.
The reports are a key element distribution of information in any organization in different formats: predefined, dynamic, adhoc, guided, etc ... We have performed several Reporting projects, such as Italfarmaco, Universidad de Lleida, Amnistía Internacional...
In Stratebi, we know how important distribution of information in an organization is, both internally and externally and we create powerful and robust reporting solutions appropriate to each user profile, according to your needs and levels of securized access to information.
Static reports present information in a predetermined ways (sales by month and area). Dynamic reports allow users to interact with information through "drill down", filters, etc ... to drill down to levels of detail.
In Stratebi, we perform all kinds of reports, from those who have predefined format where the objective is to match the display parameters marked, even those in which users can interact with them, select dates (date picker), filter, ...
These reports can also be planned, so you can schedule your execution and delivery by mail (eg in PDF format) every month of monthly sales to each region manager with a (red, yellow, green traffic light coding) as a visual alert.
With a Data Warehouse we have a 'life insurance' for the progress of our company.
- Facilitate access to corporate information: The contents of the data warehouse should be understandable, navigable and access it must be characterized by high performance:
- 'Understandable' means properly labeled.
- 'Navigable' means that the desired destination is locatable on the screen and this is at a single "click away".
- 'High performance access' means that the waiting time is zero.
- Give consistency to the information of the organization.
- It is a "life insurance" to protect organizational information: The data warehouse not only controls access to the data effectively, but also provides the "owners" of great information control and powerful media about who uses and abuse of the data.
- It is the foundation for decision-making: The data warehouse has adequate data to carry out the decision-making process. The original name initially used to refer to what we know today as data warehouse systems help decision making (decision support system, DSS), shows clearly what is the purpose of these systems.