How To Disable The Double Click Option For Drillthrough Action In Ssas Cube

I have requirement to create the DrillThrough Action in SSAS Cube. Along with we will give DrillThrough Actine in excel report for few program not for all. We have made the Action

Solution 1:

I believe you can disable this function by doing the following:

1. Connect to Analysis Services Using SSMS & Browse to the Correct Database/Cube.
2. Go to the user role(s)
3. Select Cubes page
4. Change Local Cube/Drillthrough Access to None
5. Click OK.

Solution 2:

You can capture the double-click event and cancel the default action (in your case drillthrough tabs) before query took place in the macro of the excel workbook. Simply put the below events in the "ThisWorkbook" object:

PrivateSub Workbook_SheetBeforeDoubleClick(ByVal Sh AsObject, ByVal Target As Range, ByVal Cancel AsBoolean) 
 Cancel = TrueEndSub

All double-click events will be cancelled for the whole report, including any drillthrough tabs that would appear.