Hierarchy Developer's Guide for Oracle Billing Insight > Hierarchy Manager and OMF Architecture >

Working with Reporting

To run reports for hierarchy structures, changes made to hierarchies must be synchronized to the OLAP database. In addition to hierarchy tree structure, each OMF object linked into hierarchy must be synchronized. Each OMF object has implemented an OLAP handler to handle their specific synchronization logic for being linked into a hierarchy.

Changes made to the OLTP hierarchies are categorized into different types of events. An event handler is called directly by the hierarchy API code to process the corresponding event. As a result, the same changes are then be propagated into the OLAP side of the hierarchy tables. The changes made in OLTP and OLAP are bounded into a single transaction to guarantee the data integrity between the OLTP and OLAP databases, using distributed database transaction management.

For each OMF object that must be linked into Hierarchy Manager, you must implement the ILinkTargetEventHandler interface defined in the com.edocs.common.api.hierarchy.connector package. Figure 14 shows the database synchronization of hierarchy changes.

Figure 14. Database Synchronization of Changes to Hierarchies