Query Designer Exception

[Former Member]

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.

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Preethi,

Means that i'm not able to insert customize color like blue or other color ?

And regarding the 4 colors that you state in your reply, could you please elaborate further on the 4 colors ?

Thanks.

Regards,

Jonathan

[ravi_chandra3 · Accepted solution]

Hi Tan

U have to use only that colors only u do not insert any customize color.

U can set color based on some condition on keyfigure .

Suppose if u have amt in ur infoprovider as the keyfigre and u set the condition to the amount based like as shown below

amt > 10000 ===>Good1

if amt < 10000 and amt > 8000 ====> good2

if amt > 5000 and amt < 8000 ===> medium2

if amt < 5000 ======> bad3

the above example will have 4 Exception and u will have 4 colors.

the o/p will be based on the condition of the keyfigure

Hope it helps,

Regards

RaviChandra

[Former Member · Accepted solution]

Hi Ravi,

Thanks for the quick reply. I know i can do that. Just seeking possibility to use customize color other than red, amber and green.

[ravi_chandra3 · Accepted solution]

Hi Tan

U can' use other than that colors.

[Former Member · Accepted solution]

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

[Former Member]

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.