Hello Friends, I have a report based off of the cube and i should be able to drill thru to detail report when i click on chart.and i used member sets with drill behavior enabled to allow users to run the report @ summary level for various periods i.e last 7 days,30days....
with the current settings its actually drilling down,and users dont want to right click and select the drill thru link.
How do you want them to drill through if not with a right-click? You are already using left click as drill-down, and you can't use the same gesture for both operations.
Regards,
MF.
well they got used to one click that takes them to target report. i know that its not possible for one click drill thru while drill behavior enabled,but just want to make sure before committing to that,that it is not possible.Thanks
Give them a Crosstab that uses the same query as the Chart. The chart can be used for drilling down whereas the Crosstab can be used for drill-thru as it allows drill-thru/drill-down not only on the intersections but also on the Rows and Columns. Depending on your needs, use some of it for drilling down and the rest for drilling-thru.