如何在SSAS多维数据集中禁用DrillThrough Action的双击选项 [英] How to Disable the double click option for DrillThrough Action in SSAS Cube

问题描述

我需要在SSAS多维数据集中创建DrillThrough操作.伴随我们，我们将在excel报告中为DrillThrough Actine提供一些程序，而不是全部.我们基于此进行操作，并且仅对那些程序和其余程序数据具有有限的DrillThrough功能，​​用户无法通过右键单击来获取其他数据选项.

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 based on that and we have limited DrillThrough feature for those program only and rest of the program data ,user can't able to get additional Data option by right clicking.

但是问题出在那些程序上，即使用户无法通过右键单击来查看钻取操作以获取其他数据，但是用户双击那些受限程序所提交的值，即使它在新工作表中显示了rillthorugh数据.

But the problem is for those program even user can't see the drillthrough action by right click to get additional data, but user double click on the value filed for those limited program, even it is showing drillthorugh data in new sheet.

我想禁用双击选项，以获取那些受限程序的追溯操作，或者我可以禁用整个报表的双击选项，从而提供DrillThrough数据.

I want to disable the double click option for getting drillthrough action for those limited program or I can disable double click option for entire report which is giving DrillThrough Data.

请紧急告知该修复程序需要做什么.

Please advise urgently what need to do for that fix.

推荐答案

我相信您可以通过执行以下操作来禁用此功能:

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

1. 使用SSMS&连接到Analysis Services浏览到正确的数据库/多维数据集.
2. 转到用户角色
3. 选择多维数据集页面
4. 将本地多维数据集/钻取的访问权限更改为无
5. 单击确定".

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.

这篇关于如何在SSAS多维数据集中禁用DrillThrough Action的双击选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！