BI - Essbase Integration

Essbase as a data source

Hyperion Applications Data store:

  • Scenarios
  • Versioning
  • Write back
  • Ease of loading GL Data
  • Excel based analysis using Smart View
  • Drill down

Cube or a Data Mart:

  • Dimension Hierarchies
  • Drill Down
  • Aggregate Storage technology
    • Aggregate Storage databases provide the following key ingredients for an Analytic Data Mart to rival, and arguably surpass, the traditional RDMBS-based alternative
    • Virtually unlimited dimensionality and inter-dimensional complexity
    • Outlines containing tens of millions of members
    • Designed to efficiently handle large volumes of sparse data
    • Dynamic aggregations that provide near-instantaneous upper-level data requests
    • Highly advanced calculation engine
    • Expansion of aggregate storage metadata volumes to 264 bits
    • 64-bit computing support with the Intel Itanium™ processor
  • Scenarios
  • Versioning
  • Write back
  • Excel based analysis using Smart View

BI - Essbase Integration Services

  • BI Administration Tool is used to add a multidimensional data source to the Physical layer of a repository.
  • Multidimensional data sources that Oracle BI Server can connect to include:
    • Essbase
    • Microsoft Analysis Services
    • Data from multidimensional sources can be used in analyses and Oracle BI interactive dashboards.

Multidimensional Versus Relational Data Sources

  • The primary differences between setting up multidimensional data sources and setting up relational data sources are in the Physical layer.
    • Each cube imported from a multidimensional data source is created as a single physical cube table in the Physical layer.
    • Oracle BI Server imports cubes with corresponding metrics, hierarchies, and levels
  • The setup processes in the business model and presentation layers for multidimensional data sources and relational data sources are almost identical.