OBIEE Value Interaction Drill Down
829439Apr 11 2011 — edited May 10 2011Hi All,
I am trying to implement navigate report in OBI. I have a main report which have supplier, month, year, no of jobs, etc. I need this report to navigate to the detailed report.
I have given value interaction as navigate in supplier column and also given supplier column as prompted in detailed report. So when i click on supplier , it takes me to the detailed report corresponding to the particular supplier I clicked. But it displays all yearly data corresponding to that supplier.
I am interested to see corresponding Month and Year data of the supplier when I clicked on the particular supplier name. It is like when I clicked Oracle supplier for June 2010, I should navigate to June 2010 data of Oracle.So I had given Month, Year as prompted in detailed report. But after given this condition, I am not getting any data in the detailed report and it say no results.
Is my approach wrong?
Please help..