]po[ Reporting Tables

]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.

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com