I have a webi report created from a universe. This report has a stacked bar chart.
On X axis I have Region, on Y axis I have Count of employees(CNT). And then we have a stacked contents as Dept.
Hierarchy in Universe → Region → Dept
Preview 1 → See Attachment → Main Chart
Here FL is region, A,B,C are depts. That means FL has 20 employees in Dept A.
I have a drill down for this report. I drill by using the hierarchy Region-> Dept. Well and good, it drills down further to Dept and gives the counts.
Preview 2–> See Attachment–> Drilled Chart
What I wanted is when I stop drilling down at Dept like above for FL, if I click on the bar with Dept A, I want to go to another Webi report where it gives the details of the 20 employees in the Dept A. How can I achieve this?
Normally for a few other reports I used a hyperlink and used openDoc to open a webi report. But how should I get to a report after I do the drill down.
Please let me know if anyone knows how to do this.
I don’t believe you can ‘Activate’ a chart to allow it to opendoc.
The only way I can think of doing which is highly unlikely to work would be to define a custom hierarchy and at the bottom level put an object which creates an appropriate opendoc statement…but there isn’t any guarantee it’ll work.
Can you compromise and just show a link in an adjacent table when the user is at the appropriate level of drill?
How can we just show the link when it is at an appropriate drill level? How do you pass the info like if the user has clicked on ‘Region FL’ \ Dept A’ then we just pass on the FL and A as the parameter to report. Is there any variable within BO which holds that?
(BOB member since 2002-08-15)