Reportive Studio

Data cubes generator

Reportive's version 9 proposes a new offer, Reportive Data Analyzer. This solution requires a cube to enable advanced analysis features. If your company has multidimensional servers, you're ready to start. Otherwise, Reportive Studio offers a simple way to generate a local cube to allow for multidimensional analysis.

                                        Construction of a local cube and distribution of a dynamic report

The design principle is simple. A cube is composed of dimensions and fact tables. A dataset is prepared for each dimension, containing the analysis axes for the dimension. Reportive Studio's calculation engine allows you to prepare a numerical index for each dimension in order to make cube processing faster. The fact table contains only the indexes and numerical indicators.

By default, the easy-to-use interface performs 80% of operations involved in creating the cube. This module includes a data quality analysis feature that detects mistakes commonly made when creating cubes.

                                                                        Cube design interface

You can also create formulas, sets or KPIs (Key Performance Indicators), thanks to simplified interfaces:

• Formulas can be used to perform simple or advanced  operations at all aggregation levels. For instance, you can calculate the variation of sales depending on the period, moving totals (MAT) or fixed totals (YTD, QTD...).

• Calculated members define groupings (e.g. "PSA" = "Peugeot" + "Citroën") or dynamic values ("last month", "last date of sale"...).

• Sets are used to define a set of items of data, whether static ("Europe" = "France" + "Germany" + ...) or dynamic ("Top10 Vendors", "Most stored products"...).

• KPIs are used to define a set of indicators that give the objectives, status and trend of a specific indicator.

Reportive Designer's integration into Studio makes it possible to create a dynamic analysis report and to distribute the package containing the report, its dependencies (logo, background images...) and the local cube to users that have Reportive Analyzer installed on their workstations.

For custom deployments, it is possible to distribute the data for a sales rep in charge of a specific area along with the aggregated data for adjacent areas, or for higher hierarchical levels, without including detailed (and therefore confidential) data. This allows sales reps to compare themselves anonymously.

The generation of the cube uses the following drivers: "Microsoft Analysis Services 2008 OLE DB for OLAP", "Microsoft ADOMD.Net Client Programming" and "Microsoft Analysis Services 2008 Management Objects".