Stacked column chart drill down to webi report

[system]

Hi,

Can someone pls let me know how can we achieve the below scenario -

Am working Dashboard designer 4.0. Created a stacked column chart which has open and close status displaying on x-axis.
stacked column for each status open or close shows HIGH/LOW/MEDIUM/VERY HIGH status.

When a user click on either open or closed status bar with High/ medium/low/very high status,
how can we capture whether open/ closed status is clicked along with
HIGH /LOW/MEDIUM/ VERY HIGH STATUS

These two parameters should be passed to the drilldown webi report-
for example user clicks on Open BAR for Very high status. then webi report should be called for PARAM1=OPEN and PARAM2=VERY HIGH…

Thanks

---

mam123 (BOB member since 2014-02-27)

[system]

please suggest me if anyone has a solution to this…thanks

---

mam123 (BOB member since 2014-02-27)

[system]

Have a look at the attached. It’s not exactly what you want, but shows you how to get your drill values into specific cells.

Then use the opendocument function to call webi and pass the cell values out as parameters.

Debbie
drill2.zip (11.0 KB)

---

Debbie (BOB member since 2005-03-01)