Is there a way to limit Drill anywhere options or allow option to drill to same field?
I have several fields I would like to be able to drill down to the same field. So we can look at customers then drill down to see item numbers for the customers or we can look at departments then drill down to item numbers in the department, etc. To my knowledge this isn't possible unless I copy the item number field multiple times and set a hierarchy for each one.
Other option is to allow drill anywhere but this allows the user to drill to any dimension and some of the dimensions don't make sense to drill to.