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

Preventing drill down after query runs

I have an Order query with a hierarchy attached to the infoObject. I created select-option on the Hierarchy node with a node variable. When the query runs if we tell it to display 1 level it works as desired by showing the node name and total. The problem here is the user can then drill down on the hierarchy and we don't want that because we have three summary queries in a workbook and a grand total number at the bottom.

We like the summary number but can we turn off the drill down?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2005 at 03:08 PM

    Hi Richard,

    in the workbook properties you have the option to disable the olap funtions for the users. If you choose to do that they will also not be able to filter, change the display etc. right mouse click on the wb go to properties and uncheck enable interactive functions. do not know if there is an option to prevent the user from activating the option again.

    regards,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2005 at 12:11 PM

    Dear Richard,

    have you found a solution to your problem that does not count on the users not knowing how to reactivate interactive features. If yes I would appreciate to hear from you.

    Thank you very much!

    Marcus, marcus.kronen@thyssenkrupp.com

    Add a comment
    10|10000 characters needed characters exceeded

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.