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
mburk1968Asked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
Two options:

1. Use Ragged Hierarchives, if appropriate. Here are some details: http://msdn.microsoft.com/en-gb/library/ms365406.aspx
2. Don't use duplicate attribute values, e.g. instead of "Closed Claims", use "Closed Claim - Status1" and "Closed Claim - Status2".
0
 
mburk1968Author Commented:
Awesome!  Thank you so much for the quick response.  For the specific issue I'm having, I tried using a different attribute name in the hierarchy where I'm having the issue, and it worked.  I also wee where I can use your tip on Ragged Hierarchies...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.