Two hierarchies in my dimension are sharing the same attribute :
Hierarchy 1 : Country (Key) -> Sub Region -> Region ->
Hierarchy 2 : Country (Key) -> Sub Area -> Area -> Great Area ->
How can i design realtion ship of related attribut ?
There must not be a many-to-many relationship between Region & Bloc nor between Great Area & Bloc....
View Complete Post