I have created a WEBI report with "GL Hierarchy", "Revenue" field on top of a BEx query. I have a table & chart with these fields in my report. Now, I when I drill on my chart, my table also should drill down (expand), similarly when I drill on my table my chart should be drilled down.
For this, I did set "Synchronize Drill on Report Blocks" in preferences as well. But, this not working as expected. I did try the same on RDBMS data via universe , it's working fine.
Any ideas/workarounds how to implements this functionality for BEx data.