Instance Reporting OLAP Cubes

There are three OLAP cubes provided with ActiveBatch, named as “Event Audits”, “Instances” and “Objects”. The Instances cube has eight (8) dimensions and two (2) measure groups. The measure groups are associated with two (2) fact tables; Instances and ObjectTags. The ObjectTags fact table is in fact, a factless fact table, since it does not have a single primary key. The Instances cube schema is shown below:

 

 

The following measures are created within the measure groups:

 

Measure Name Associated Measure Group

Total Wait Time

Instances

Total Run Time

Instances

Total Cpu Time

Instances

Total Memory Peak

Instances

Total Disk Writes

Instances

Total Disk Reads

Instances

Restarted

Instances

Succeeded

Instances

Completed

Instances

Failed

Instances

Canceled

Instances

Object Tags Count

Object Tags

 

Within the Instances cube, the following dimensions are used:

 

  • Dates

  • JobSchedulers

  • Machines

  • States

  • Times

  • Users

  • Objects

  • Tags

 

Finally, the following calculated members are created:

 

  • AverageCpuTime

  • AverageRunTime

  • AverageJobWaitTime

  • AverageMemoryUsage

  • AverageDiskWrites

  • AverageDiskReads

  • RestartRate

  • SuccessRate

  • FailureRate

  • CanceledRate

 

In addition to the Instances cube, the Objects cube has only two measures as follows:

 

Measure Name Associated Measure Group

Object Count

Object Aggregations

Object Tags Count

Tag Aggregations

 

These measures are related with the following four dimensions:

 

  • Objects

  • JobSchedulers

  • Users

  • Tags

 

The Objects cube schema is depicted below.

 

 

The Event Audit cube contains the following measures:

 

Measure Name Associated Measure Group

Information

Event Audits

Warning

Event Audits

Error

Event Audits

Object Tags Count

Tag Aggregations

 

These measures are related with the following dimensions:

 

  • Dates

  • Categories

  • JobSchedulers

  • Times

  • AuditUsers

  • Objects

  • Tags

  • Severities

  • Messages

 

The Event Audits cube schema is depicted below.

 

 

On the other hand, the Instances, Objects and Event Audits cubes for Oracle can be viewed and maintained by using the Analytic Workspace Manager software provided by Oracle for free. The Reporting Manager helps the users to create an analytic workspace along with the cubes, dimensions and measures. The cubes for Oracle are shown below.