That worked out perfect. Not sure why I was missing from before when it tried a similar solution but now I know the right way.

Thanks!

James

Thanks for the reply. I'm still no connecting the final dots to apply it my query. Could you write the code/psuedo code for what the mdx query wouldl look like...

Please note. I tried a process full on the cube and that did not change the results (or lack thereof) of the drillthrough. Any thoughts or things to look for...