Modules:Analytics New Stack
Upgrade Analytics Stack
The stack of Analytics is upgraded since version 1.3.0. In particular it contains new versions of Mondrian (220.127.116.11) and Saiku (3.7.4).
The new Analytics Stack requires the following:
- Openbravo Core module version must be 3.0PR16Q2 or higher.
- The JVM must use Java 7 (1.7) or higher.
- If database is PostgresSQL then its version must be 9.3 or higher.
This upgrade does not involve major changes in the operation of Analytics, as its main objective is to keep it working as before using the new stack, but there exist some changes which are worth mentioning.
Changes in the UI
The User Interface has barely changed. Then main changes are:
- The disposition of the Columns, Rows and Filters has been moved. Also, now the Measures are added in a separate section.
- It is possible to work with multiple tabs. Regarding this feature, now the refresh button, apart from refreshing the cubes, closes all opened tabs to prevent working with outdated cube definitions.
Besides, the OB Analytics toolbar includes two new buttons:
- Drill across on cell: allows users to find out more about a specific area of a query. You can see an example of usage here.
- Fullscreen: allow to display the results in full screen mode. It can be useful for presentations.
To finish with the changes within the UI, now the MDX mode has a parameter prompt which eases the testing of the parameterized queries.
Export charts into JPEG format
Together with PNG and PDF formats, now it is possible to export charts into JPEG format.
Week level in time dimensions
Now the time dimensions include a level that allows to see information split by week.
Query Model generation
Though version 1.3.0 of Analytics ensures backwards compatibility with the execution of MDX queries, this compatibility and the new Mondrian 4 schema definition required to redefine some cube definitions on the XML schema. This causes that the Query Model definition of some cubes can be different from previous Analytics versions.
Update the Query Model definition of an Analytics report can be easily done using the OB Analytics window. These are the steps:
- Go to the [OB Analytics] window and generate the same query that it is being launched in the report.
- Use the Save Query button of the toolbar to save the query.
- Navigate to the [Analytics Queries] window and look for your saved query.
- The content of the Query field contains the new Query Model definition. Copy and paste it into the corresponding record of the Report Query tab in the [Process Definition] window.