You might also look and see if this[/url] will help with the file size limit.

Part of the issue that you might want to consider - user created report, an you are trying to replicate logic using more complex mdx.

So will users be able to apply this to another view they come up with?

When I look at Store being the level of display, Division Hierarchy goes directly to store, while Region Hierarchy does not include Division.

Which is the disconnect mentioned.