COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: simi on 10 May 2016 09:27:52 AM

Title: Issue Passing Parameter to the Hierarchy
Post by: simi on 10 May 2016 09:27:52 AM
ALL,

I have one requirement with both the functionality of Drill through and Drill up/down.

the summary report will have  bar chart with count  of activities for the employee who runs the report. There is drill through enabled in this chart. this will take to the detail report and show the bar chart. Chart in the detail report should have Drill up/down behavior with employee level.

I have 10 levels in Employee hierarchy

If level 3 employee is running the summary report then detail report should show Level 4 by default. from there it should drill down up to level 10.  Basically report should drill up/down between level 4 and level 10.

i was using this function, but it was showing all the levels with the single view

descendants ([emp hierarchy],#prompt('emp_levle','integer','0')#,after)