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

OLAP Prompt Screen - Default Settings?

Is there a way to default the OLAP Prompt screen to have the settings Show All and Expand optional prompts enabled? Right now as our system is setup every user would have to click two extra times just to get to the point where they can begin entering their prompt values (if they aren't required, which defaults to Shown and Expanded). I couldn't find a setting anywhere in OLAP that set these as a default, even after I turned them on and saved the report it kept going back to only showing the required fields expanded. Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 16, 2014 at 08:21 PM

    Hello Jonathan

    Please refer to section 7.6 of the Analysis OLAP Administrator Guide.

    There is a property in the file "" which should be changed to true.

    This will display all prompts. You will still need to do "Expand All".

    The current behaviour of defaulting to "Required" only (which are expanded by default) and not showing "Optional" prompts (which are collapsed by default) is based on customer feedback and significantly simplifies the prompt dialog.

    Another way of optimising prompts is to use variants (these are created within the prompt dialog). Each user can set up their own varient (or use public varients) and they can also choose one to be a default.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Djawad

      Sorry, there is no option to display all prompts expanded.

      By viewing and expanding all Required and Optional prompts, we return to the bad old days of how we used to present prompts in previous products. It was through extensive design sessions with customers that we arrived at the current design which focuses on the required prompts and automatically expands them (because you must fill these values to continue).

      We became aware of some users who wanted to at least display all prompts by default so we added a property so that the prompt dialog defaulted to show the All tab instead of the Required tab, but at least this still only expands the Required prompts... which helps to reduce complexity and highlights which prompts must have values.

      If your users want to expand all optional prompts, this can be easily done by one click on the "Settings" icon on the right of the Prompt dialog and choose "Expand optional prompts".

      If your users are regularly using the optional prompts then maybe there should be consideration to change these to required prompts? However a more flexible solution is to make use of the Variants feature in the prompt dialog. Each user can define their own prompt values for each AOLAP workspace and set the variant to be the default when they open the report. That way each user can just populate the prompts they need without having to enter their values each time they open the report.

      Kind Regards

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.