Skip to Content
author's profile photo Former Member
Former Member

Query Double Click

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2005 at 04:04 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 10, 2005 at 04:06 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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 😊)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.