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.
