Hierarchy & Drill down capabilities for time dimension
830342Jan 17 2011 — edited Jan 18 2011i have created time dimension hierarchy in rpd in terms
year->quarter->month->week->day
when am trying to drilldown for year.i.e.,,,,,,,,,,,, when am clicking every time on year column.............its giving columns in order.
1st time clicking on year it drill downs to quarter and report displaying with order
year->quarter
when 2nd time clicking on year column it self it drill downs to month.but order of displaying columns is
year->Month->quarter
when every time clicking on year it giving order in the terms of
year->day->week->Month->quarter
but i want order in this format when am clicking on year every time
year->quarter->month->week->day
can u suggest solution for displaying this order of columns in report
year->quarter->month->week->day
instead of
year->day->week->Month->quarter.