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

Query Prompt is Greyed out

Hi Expert,

I have created an dashboard based on BEx query, in which the user will select the input for fiscal year and posting period in combo box and it will be passed to prompt in query browser. But while I am trying to select an cell for this selection in excel it seems to be greyed out. but when I remove the Cost Centre Hierarchy I could able to use the fiscal year and posting period prompt without any issue.

so could you please suggest an solution.



Ramesh Jothimani

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 11, 2015 at 11:08 PM

    Hi Ramesh,

    This is a known limitation with query browser on bex query.

    If we have a BW variable as well as a prompt defined at the dashboards level then we have an issue in binding to excel and is grayed out.

    Either we can have filtering done at BW or at Dashboards level but not at both.

    Please check KBA

    2103395 - BW variable greyed out in the query browser in



    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.