How can I create multiple SSAS hierarchies while avoiding attribute values appearing more than once in some hierarchies but not others?
We have so many ways that our users need to drill down to see their data. I am creating various hierarchies to accomplish this. However, I keep running into attribute values appearing more than once in some hierarchies. I can understand why this would happen, but am looking for a solution as to how to avoid this. Please see the attached... Experts-Exchange-Hierarchy-Question.docx