Implementing OBIEE parent-child hierarchies

user4109719

I'm unclear on how OBIEE parent-child hierarchies are supposed to be implemented.  The examples I see involve creating a parent-child hierarchy on top of a table that contains the measures we want to roll up.  For example, an EMPLOYEE table which includes a SALARY column and has the ID of each employee's manager, which defines the hierarchy.  In the RPD, the parent-child Dimension is created in connection with the EMPLOYEE table.  Finally, the hierarchy relationship table (with the ANCESTOR_KEY, DISTANCE, IS_LEAF and MEMBER_KEY columns) is created or the parent-child Dimension, in order to roll up the SALARY column.  All the examples I see are done this way.

My question is:  If the table with the measures such as SALARY is separate and joined to the EMPLOYEE table on the column containing the MEMBER_KEY value, will it still roll up the measures?

Thanks.

Gianni Ceresa

OBIEE doesn't care much if it's the same table to 2 tables as long as you have a clear join between the 2.

The logic will not really change, things will work fine even with 2, 3, ... 10 tables.

Don't worry, give it a try

André-Nogueira

Dont know, if i get.

But anyway, if somehow the obiee dosent show what you expect in a union state, ( or the other cube dont have equal's dimension ) you just put "NULL" in the dimension on presetation layer (or sum(0) )

But you need at least one dimension equals on each cube.