]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 · · · Index · Login/Register

Contents

5 registered users
 in last 24 hours

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




References to this Page: en:list_tables Categories: Database Tables (Contents)

Please take a moment to complete this form to help us improve our service.

Did this page help you to achieve your goal?
 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?
 1  2  3  4  5
Not
useful		       Extremely
useful