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

Query Designer Exception

Hi,

In query designer 3.5, the exception is available in 3 traffic light color --> red, amber and green.

Is there any setting that we can include other color in the exception ?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2011 at 06:39 AM

    Hi Jonathan,

    You said that you are using Query Designer 3.5. Exception in the Query Designer of 3.5 version has 9 levels of alerts (GOOD, MEDIUM, BAD with 3 different levels in each). This means that you can have 9 different Exception condition. Each of which will have different color in the report.

    Even though you cant change the fixed 9 colors that are in the Exception, you can try different combination of ALERT LEVELS so that you can get 4 different colors as you wish to have in your report.

    Hope it helps you.

    Warm Regards

    Preethi R.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can change the colours by modifying the css/stylesheet within the Web Template. I am not sure how many different colours are used within the Exceptions. It could be 3, it could be 9.

      This blog explains what you can do by changing the css. /people/shantanu.garg/blog/2007/05/24/altering-colour-themes-for-bi-70-web-templates

      However, the dashboard guru Stephen Few's current thinking is your reports should only have one colour to highlight data: red!

      George

  • author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2011 at 07:24 AM

    Hi Jonathan,

    *In Exception of BEx Query Designer 3.5, you can't have customized color as you wish.

    *As i told you earlier, there are 9 different Alert levels. Just try using all these 9 alert levels in any sample report, so that you can see what are the 9 different colors that you can get in your reports.

    As per you initial question, you wanted to have an additional color in the exception apart from the basic three. You can have that using any 4 different Alert levels of the whole 9levels.

    (NOTE: You can use some other advanced reporting tools, where you can have the option of changing the colors in the alerts as you wish)

    Hope it helps you.

    Warm Regards

    Preethi R.

    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.