Is it possible to selectively skip a level when drilling?

[26point2]

MSTR gods:
I have a conformed geography dimension with five levels in the hierarchy--- from country down to zip code. Some countries don't need all five levels--- they only need four. For records of such countries, the county and sub-county levels have the same data. When you drill down in Microstrategy, you would normally drill from country to state to county to sub-county to city and then zip code (which is the bottom). In those cases where there is only one child for sub-county (which means that there are really only four levels), we'd like to be able to drill past sub-county. In other words, is there a way to make MicroStrategy skip a level when drilling on a four level hierarchy? We want to still be able to drill from county to sub-county, but only want to skip it when there is one child between them.

What do you think?

Thanks,
26point2

 

[nlim]

There might be a way to do it. If you restrict access to the "unwanted" attribute by users, then this unwanted attribute should not show up in the drill hierarchy.

This capability to specify drilling by multiple conditions is not possible in other products, and is just hard...

 

[VBDemiGod]

nLim (and anyone else),

Could you elaborate on your previous post. I am attempting to do something similiar (refer to thread395-701684 for details) and need to limit certain clients from drilling at certain levels (most often the lowest level). I have attempted to put a security filter in place and set the bottom range element to that of the element above the element i wish to hide (member). It does not remove the element from the drill menu/hierarchy but when a user attempts to drill down to the 'Member' level, they get a report that never completes (just kinda spins its wheels). Now some clients should be able to access this 'Member' level and other clients should not. Can anyone give me any insight on this one????

Thanks,

Ray H

 

[nlim]

I would put an ACL on the Member attribute.

So, RMC on the member attribute, under security make sure that only the clients that can access member show up.

When the clients with no access sign in, they won't be able to even see the member attribute in the drill menus.

 

[VBDemiGod]

nLim,

I am a MSTR newbie and do not know what ACL or RMC mean. Can you elaborate on this?

Ray H.

 

[nlim]

Access Control List.
Right Mouse Click.

 

[VBDemiGod]

gotcha thanks nlim