Skip to Main Content

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!

How to create a Hierarchy on 3 dimension tables

809759Jun 2 2012 — edited Jun 2 2012
Hi,

I have a one doubt on Hierarchy in 11g.
I have 6 tables 5 dimensions and 1 Fact. The Fact contains all the 5 dimensional table Keys.
And In every dimension i have only key and 1 column. Here the requirement is i have to drill the 1 dimension to another dimension columns.I need to do this for 3 levels(3 differant dimension columns)

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details