Multiple Hierarchy Drill Down in Matrix Possible?

Hi Anonymous 

I tried that option as suggested and the output is still not working as I was hoping

Right now my [Rows] are set up as follows

So there is one Hierarchy on top of another column

HOME_FACULTY_SHORT_DESC

-HOME_FACULTY_SHORT_DESC

-SUBJECT1_SUBJECT_DESC

-OUAC_PROGRAM_DESC

-PROGRAM_ID_NUM

-ACAD_QUAL_CODE

-PROGRAM_TITLE_DESC

-TRANSCRIPT_TITLE_DESC

And right below this Hierarchy is another column

OUAC_CHOICE_GROUP

What I was hoping to see was BOTH the HOME_FACULTY_SHORT_DESC and also the OUAC_CHOICE_GROUP display at the same time but also have HOME_FACULTY_SHORT_DESC still be drillable

Right now the closest I can get is by NOT using the hierarchy and showing both rows

So this is my first attempt

The two columns on the left are what I was hoping to display BUT in this case HOME_FACULTY_SHORT_DESC is NOT a drillable hierarchy.

When I do try to use a hierarchy for HOME_FACULTY_SHORT_DESC, it looks like it HAS to drill down from top to bottom and show all the values in between. Its either show just the PARENT, or show ALL the children

So with the hierarchy+ OUAC_CHOICE_GROUP when I drill I get the following

1) HOME_FACULTY_SHORT_DESC

2) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC

3) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC

4) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC->PROGRAM_ID_NUM

5) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC->PROGRAM_ID_NUM->ACAD_QUAL_CODE

6) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC->PROGRAM_ID_NUM->ACAD_QUAL_CODE->PROGRAM_TITLE_DESC

7) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC->PROGRAM_ID_NUM->ACAD_QUAL_CODE->PROGRAM_TITLE_DESC->TRANSCRIPT_TITLE_DESC

Then finally

8) HOME_FACULTY_SHORT_DESC->SUBJECT1_SUBJECT_DESC->OUAC_PROGRAM_DESC->PROGRAM_ID_NUM->ACAD_QUAL_CODE->PROGRAM_TITLE_DESC->TRANSCRIPT_TITLE_DESC->OUAC_CHOICE_GROUP

Its only after going through starting from the top can I drill down to OUAC_CHOICE_GROUP.

So in my current tool (OBIEE) I am able to do the following

The hiearchy in this display is fully broken out AND there is still the OUAC_CHOICE_GROUP column grouping.

I hope that makes sense, as I was really hoping for some ideas/guidance