I notice in drill down it is bypassing one level of hierarchy.

[#1]

Hi Team

I notice in drill down it is bypassing one level of hierarchy.

For example:

I have the data with hierarchy Year->Half Year->Quarter->Month.

I created Drill down group “TimePeriod” with hierarchy level (Year->Half Year->Quarter->Month)

When I click on the drill down from Half Year it directly goes to Month instead of Quarter.

Observation: I notice this is specific case when we have single vales at the hierarchy level,

In this case I have one quarter-(Q3) data for Half Year- 2013-H2, when I click on the Half Year drill it directly goes to Month.

Such As

2013-H1 Drill goes to (Q1/ Q2)

2013-H2 Drill directly goes to Month.

Thank you.

[#2]

Hi All, thanks for reply, it the default behavior . But my bat I need to show the values even if it have single value.

[jagan]

Hi Satish,

You can do it manually by using dynamic dimension like this

If(GetSelectedCount(Quarter) > 0, Month,

     If(GetSelectedCount(HalfYear) > 0, Quarter,

     If(GetSelectedCount(Year) > 0, HalfYear, Year)))

Hope this helps you.

Regards,

Jagan.

[#4]

Thanks Jagan, I will try dynamic dimension but not sure how to incorporate this in the drill down.

[jagan]

Hi Satish,

There is no need of Drilldown, in place of DrillDown column just use this Dynamic Dimension.

Regards,

Jagan.

[yevgeniy]

Hi Satish,

You can do reload calendar 2013 year  end.

Other data reload  today.

May be it will help.