How can we make a hierarchy from multiple dimensions ? I am not able to select attributes from another dimension. – Sreekumar KP
Ans : The doubt arise here is because there is no relation defined between tables in DSV. If there is no table level relationships defined, then we should consider making logical relationship. Once you define logical relationship between tables, then you define the dimension, attributes from related dimensions will come there, and you can simply select the hierarchical attributes.
If you make this change after creating the dimension then it may not reflect there, you may need to go back and recreate the dimension again.