I m aware that the hierarchies can be defined with in members of individual dimension.
Below is my hierarchy with in cluster dimension
companyid -> acctdid -> products..
But I want to show the companyname instead of companyid during drill down and drill through across that hierarchy..Company name is present in a different table other than the cluster dimension.
How can I define hierarchy as companyname -> acctdid -> products.