Hi All,

I have managed to create alternative drill down paths in analysis services.
I am currently using Cognos to display the cube.
However there is a problem
I have three dimensions in Analysis services
i.e.
Date.Week
Date.Month
Date.PrevMonth

If I built the cube in Cognos this type of hierachy will be displayed as
follows
All Dates
Week
Month
Prev Month

But when I create this in analysis services and link to Cognos I get the
following results

Dates
Week 1
Week 2
Week 3
Month
Prev Month

I need this to display the dimension in a sub folder of Dates

ie.
Dates
Week
Month
Prev Month

If one was to expand it then you should get
Dates
Week
- Week1
- Week2
- Week3
Month
Prev Month

Please can someone help !!! Noone seems to know how to do this