View source | Discuss this page | Page history | Printable version   

Modules:OB Analytics View


OB Analytics

Through this Window it is possible to visualize the information based on the Cube Definitions. In order to do so, Openbravo relies on an external technology called Saiku. Saiku is always used in Openbravo to show the Analytical Information, through this Window or other Windows implemented by different Modules.


Note. The first time any Window using Saiku is opened in an environment, some processes are launched before showing any information. Depending on the environment and the amount of data it has, this process may take a long time to finish. But this only happens the first time. Afterwards any Window using Saiku should be opened in a reasonable amount of time.

Note: before using the OB Analytics window it helps to read this additional information on multi-currency and date time mapping.



The Toolbar of Saiku allows to perform several actions, all of them are explained in the Saiku Documentation.

Some of the most notable ones are:

Cubes, Dimensions and Measures


Note: the Refresh Button in the top-right, it can be used to refresh the schema if the cube definition has changed. Normally it is only relevant when changing the cube definition in the user interface.



This area, along with the Dimensions and Measures, is the main area in which queries are created and results are shown.

It has two different parts, in the upper area is where the Rows, Columns and Filter axes can be found. By dragging Dimensions and/or Measures into this axes, the query is built. In the lower area the result is shown.

An Element of a Dimension or a Measure can be placed into any of the three axes. By placing it in the Rows or Columns axes, the Dimension or Measure will be shown in the Rows or the Columns or the Report accordingly.

The Filter axis works in a different way, though. By placing a Dimension or a Measure in the Filter axis, the results shown are a slice of the Cube that corresponds to that Dimension or Measure only. For example, by placing the Organization in the Filter, and filtering the Organization to show only values for F&B US, the results shown in the Report would represent only values for the Organization F&B US.

This is also useful for working with the Measures. For example, by placing Unit Sales Measure in the Filter axis, the values in the Report would represent the Unit Sales.

When a Dimension is placed in any Axis it is possible to filter this Dimension or to order it. By clicking on the arrows icon, a Dimension can be sorted. By clicking on on magnifying glass icon, a pop up will be shown with the available Members of the Dimension. By dragging any of them to the column on the right and clicking on the OK button, the Dimension will be filtered by that Member.




In the right upper corner of the Window, there are some buttons that allows to show the values of the Report represented with graphics.

It is more extensively explained in the Saiku Documentation.

Retrieved from ""

This page has been accessed 6,717 times. This page was last modified on 13 July 2014, at 01:18. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.