Query Double Click

[Former Member]

I have a CCA query that has the following

Costcenter and Cost Element in the "rows"

Fiscal Year, Controlling Area and Currency Type in the Filter area.

When the users run the query it displays

Fiscal Year,Key Figures,Cost Center,Cost Element at the top and the cell is shaded. The users can the double click on these and it seems to remove that "filter" from the report. So for example if we click on Cost Element it removes that filter and shows it at the Cost center Level.

Any way to prevent this?

[former_member188975]

Hi Richard,

This is std BEx functionality...what SAP calls the drilldown or navigation capability. You can get the Cost Center back in the report by double clicking it again. Tp prevent the users from doing this, you can hide these rows and save as a workbook and then allow them to run the workbook only.

Hope this helps...

[Former Member]

Hi Richard,

Here are two other ways to achieve your objective (preventing user from double-clicking to remove filter):

1. instead of hiding the rows (user can see that you hid the rows and unhide them), move the 2 cells that comprise the filter cells for that characteristic to another worksheet and hide the worksheet (user is less likely to notice a hidden worksheet). Of course, you can move all filter cells to the "other" worksheet if you want. If you want even more security, make the sheet "very hidden" (which can only be done and undone from the Visual Basic Editor). Very, very, very few Excel users would know how to unhide the sheet.

2. Launch query Properties dialog. On Interaction tab, unselect "Enable interactive functions". The downside of doing that is that now the user cannot use ANY OLAP functions.

- Pete

[Former Member]

Hi Richard,

The easiest way to do this is ,,,

after running the query ,,,

Business Explorer -> Layout -> Move Result Area.

then select another work sheet .

Refresh the query if you need.

That's it,you no need to hide or do any thing else.

Hope this helps.

Sudh

(Award Points If this helps )

[Former Member]

Hi Richard,

If you don`t want to see those Objects and keyfigures listed on the top you could save the query as a workbook and in the workbook hide the rows where these show up..

So whe the user executes the workbook he won`t see those listing..hence won`t "Double Click"..

Let me know if this solves your problem.hope I interpreted it correctly,

Ashish.