]po[ treats dynamic reports, [data-warehouse cubes] and performance indicators as objects. This allows using ]po[ general permissions.
Static reports (pieces of TCL code written manually) are not represented as report objects. Instead, a menu item is associated with each static report to control name, URL and permissions.
Table |
Cols |
Rows |
Description |
---|---|---|---|
[im_indicator_results] |
10 |
1421 |
Stores the evaluation history for indicators. |
[im_indicators] |
10 |
24 |
Indicators represent a special type of report that return a single numeric value. These numeric values are stored over time, allowing to draw a "fiber chart" showing the historical development of the Key Performance Indicator. Indicators also specify warning and critical low- and high watermarks. |
[im_reporting_cube_values] |
6 |
177 |
Stores multidimensional aggregates for [data-warehouse cubes]. |
[im_reporting_cubes] |
7 |
72 |
[Data-Warehouse Cubes] represent a special type of report based on ROLAP multidimensional storage. The multidimensional aggregates are stored in the im_reporting_cube_values table. |
[im_reports] |
9 |
29 |
Dynamic Reports represent the super-class of all reporting objects. At the same time, it implements a basic "dynamic report" consisting mainly of a piece of SQL that is rendered as a HTML table. |
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com