Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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
0
mburk1968
Asked:
mburk1968
1 Solution
 
Phillip BurtonDirector, 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now