Friday, January 20, 2012

Using the ODI Adaptor for Hyperion Essbase is it Possible to Add Hierarchies into Attributes Dimension



Using the ODI Adaptor for Hyperion Essbase is it Possible to Add Hierarchies into Attributes Dimension [ID 820044.1]

 Modified 24-MAR-2011     Type HOWTO     Status PUBLISHED 

In this Document
  Goal
  Solution

Applies to:

Hyperion Data Integration Management - Version: 9.2.0.3.00 to 11.1.1.1.00 - Release: 9.2 to 11.1
Hyperion Essbase - Version: 9.2.0.2.03 and later    [Release: 9.2 and later]
Information in this document applies to any platform.

Goal


Using the ODI Adapter for Hyperion Essabse, is it possible to add hierarchies into attributes dimension?

Solution


The standard logical data store that is reversed from ODI would not have the correct columns for adding a hierarchy to the attribute dimension. But for ODI the columns are mapped directly to a dimension build and the load is what specifies how the rows/columns are built. So you could edit an existing data store or create a new one to match your DIM build rule to load the attribute dimension.

No comments:

Post a Comment