Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unbalanced hierarchies in OBIEE+

621643Feb 21 2008 — edited Feb 21 2008
Hi everyone,

We're starting to research and learn OBIEE+ in an effort to see if it can compliment what we're currently doing with the Hyperion toolset and the first stumbling block that I've encountered is with unbalanced (ragged) hierarchies. Does OBIEE+ natively support building a business model with unbalanced hierarchies? My data model is basically a star schema and my dimensions are stored in parent / child relationship tables rather than generational tables. Second question is if there is any native functionality within the product to handle parent / child relationship tables.

Thanks!

Comments

wildmight
do search - There're few excellent blog posts describing in detail how to implement rugged hierarchies...

www.rittmanmead.com/2007/06/21/obiee-data-modeling-tips-3-ragged-hierarchies/

this one to get you started

Message was edited by:
wildmight
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2008
Added on Feb 21 2008
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
1,472 views