Reporting
Layer 1 – Data Warehouse
Our reporting services begin with data collection. Data is consolidated into a common structure using Oracle views and snapshots of data called materialized views that can then be queried by the user in a common way. This has the effect of masking some of the complexity and language differences between database systems, and gives the user a consistent way to access data regardless of the original source. When a new source of data is required, appropriate views are put in place and the same interface can access it without significant modification.
Layer 2 – Application Express
Next, Oracle Application Express provides a way for the user to query the data in a flexible way. A single report begins with default settings, but users can quickly drill into greater detail prior to producing a hard copy report of their findings. Graphs, aggregate functions, highlighting, control breaks, sorting, filtering, computations, and even the ability to flashback to a prior point in time for historical reporting is available. Output to PDF, MS Word, MS Excel, and HTML with no additional steps.
The following sample report some of the options available:
Layer 3 – Advanced Report Output
When basic reporting is not enough, RTF (rich text format) templates are designed in Microsoft Word that integrate with your query output. Click a button and your custom-formatted reports are available with the data that you have selected.
