How to create a Hierarchy on 3 dimension tables
809759Jun 2 2012 — edited Jun 2 2012Hi,
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