If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issue Passing Parameter to the Hierarchy

Started by simi, 10 May 2016 09:27:52 AM

Previous topic - Next topic

simi

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)