In order to be able to create custom reports for your organization, you need data. This data can be obtained from various sources. Depending on your requirements, you may also need to manipulate the data.
The fact tables contain measurements, identification numbers, and results that are derived from ongoing operations. They reflect performance, effort (time) etc. and can become very large.
This data only makes sense when it is put into a context.
Example: The processing time is evaluated in different process steps. The fact table contains foreign keys to the dimension entries that define their meaning.
W_Step
with a reference to C_Process
The dimension tables contain the "descriptive" data. They are relatively static and normally much smaller than the fact tables.
Consider:
Whom is the report intended to serve? A carefully planned report provides information that can serve as a basis for decisions and action.
Which questions are to be answered by the report?
The data can be obtained from multiple sources.
It can be useful to create new views of related data.
Only data that is to be displayed should be collected.
Query variables allow the user to select which data to display in the report.
XBOUND database (main database)
Sample report: Capture Statistics
Sample report: Detailed Capture Statistics
Sample report: Processing Report