yes i did it in OLAP model by using physical join between parent and child columns.
However while creating of hierarchy when i was trying to drag child column under parent it throws an error.Please advise
Scoring disabled. You must be logged in to score posts.