Cognos 10.2.2 Report Studio - Source Dynamic Cube - Drill Up and Down

[GeethaKL]

Hi All,
Hope All is well.
I have a requirement and trying to work on it for a couple of days and haven't arrived at a solution.

Basically I have a report where in its divided in to 2 sections. (Section 1 is easy. Struggling to get Section 2 working as per requirement).

Section 1: 2 Charts with a  measure each , 2 Crosstab reports with a measure each. It will Drill Up and down based on Hierarchy Structure.
                Hierarchy Structure: Division(Level 1) --> Branch(Level 2)--> District(Level 3) --> Region(Level 4) -> Area(Level 5) etc.

Section 2: Should be able to able to show hierarchy Structure (level wise) as I drill up and down the charts in Section 1.

For ex:
If I drill down on Division in charts Section 1, It should show Level Names as below in Section 2
           Division --> Branch
If I drill down on Branch in charts Section 1, It should show as below in Section 2
           Division --> Branch   --> District.

Also if I click any Level it should drill up in Section 2.

Is this achievable?

Please let me know

Thanks in advance

Regards
Geetha

[GeethaKL]

Hi All,
Please anyone has any idea on how to achieve drill up and down on the data items?
Please advise
Thanks in advance
Regards
Geetha

[Francis aka khayman]

not sure if it is doable.

the best thing i can think off top of my head is section 2 should be a drill through report.

[Andrei I]

What happens if you point your Section 2 Layout object (say List) to the same query as your Charts from the Section 1.
Does it change when you drill in the Charts?