Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Alternate Drill Down Paths
- Thread starter mid181
- Start date
Alternate drill down paths are a different way of viewing similar data. For instance, here is one dimension relating to sales and how an alternate drill down path can be used.
Country Sales Territory
Region Sales Office
City Manager
Sales office
Sales Person
The common link to this dimension is the Sales Person level. This is what is reffered to as the convergence level and it must contain unique values. The main path provides a 'geographical' representation and the alternate provides a 'regional' type hierarchy.
Keep in mind that perfornamce may be affected when using alternate drill downs because the alternat path is built into one partition and will not span partitions like main drill paths.
Hope this helps.
flex
Country Sales Territory
Region Sales Office
City Manager
Sales office
Sales Person
The common link to this dimension is the Sales Person level. This is what is reffered to as the convergence level and it must contain unique values. The main path provides a 'geographical' representation and the alternate provides a 'regional' type hierarchy.
Keep in mind that perfornamce may be affected when using alternate drill downs because the alternat path is built into one partition and will not span partitions like main drill paths.
Hope this helps.
flex
- Status
Similar threads
- Locked
- Question