Knowledge Global chose Oracle BIEE, Oracle Hyperion Essbase, and Oracle Data Integrator to build the EMMA.
The following diagram demonstrates how EMMA integrates data from various data sources (predominantly raw utility meter data) into the EMMA operational database (OLTP). Small queries can be issued onto the OLTP database but large cross-sectional queries will be inefficient and slow.
This very granular data is then summarized into a data mart structure that allows fast interrogation by the OBIEE toolset.
The data mart data set is further summarized into the OLAP database, which allows real slicing and dicing of the data at a macro level. All three databases are able to be queried through the same toolset (via the OBIEE semantic ...