Oracle Business Intelligence Client

This is an Online Analytical reporting client for Oracle data marts. The user interface is web-browser based, allowing easy access over LANs and WANS.

A variety of data cubes are configured in the Oracle database, using simple tables and relationships corresponding to the Kimball style STAR schema.

The front-end application interrogates the database to make the cubes available to the user.

Reports are configured by users, via a simple wizard system. XML is used internally to store the definition of the report.

Report format, CSV, HTML. Transactional data, or grouped. Support for Excel Pivot charts and tables.

The system is implemented in VB6 as 3-tier COM DLLs, and make use of MSXML 4.0.

The database tier is oracle 8/9i Enterprise edition, and makes use of bitmap indexes, star transform, materialized views and query re-write.

p1.jpg (65440 bytes)

Main Menu Screen

 

p2.jpg (106426 bytes)

User can select/create a new report

p3.jpg (101475 bytes)

Report definition wizard. Dimensions are selected for current cube.

p4.jpg (84852 bytes)

Report is executing.

p6.jpg (83394 bytes)

Report executed and ready for download.

 

p7.jpg (74539 bytes)

Excel PivotChart report download.