Skip to Content

Design Studio 1.6 SP3 Conditional Formatting Not Working w/ BEx Query

Nov 10, 2016 at 08:52 PM


avatar image

SAP BusinessObjects 4.1 SP5
SAP Design Studio 1.6 SP3
SAP BEx 7.40

Trying activate conditional formatting on an info chart and crosstab but cannot get the conditional formatting to take effect in my dashboard. I have done due diligence on searching SCN, SAP Support and the web in general but cannot get this to work.

I have configured the exceptions in the BEx query and they work in the BEx web reports. BusinessWarehouse is hosted on a HANA server but I do directly to BW so that should not - in my opinion - make any difference. Here is how the BEx query exceptions are configured:

The Info chart is configured this way:

and the crosstab is configured this way:

The results are no conditional formatting in either the chart or the crosstab.

I am using a custom CSS file but hope that that would not nullify this feature.

Any assistance is greatly appreciated!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Jun 13, 2017 at 12:05 PM

Hi Jeff,

Did you sort this one in the end? I was seeing the same thing with BOBJ 4.2 SP3 Patch 7, Design Studio 1.6 SP3 Patch 1 and BW 7.4 SP5 Patch 1.

It appears that if the exception was created in the query after the data source was added in Design Studio, it will not affect conditional formatting. I tried editting initial view with no success but deleting the data source and recreating meant that the exception showed in conditional formatting of crosstab.



10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Nov 10, 2016 at 10:22 PM

Interesting - what happens if you remove the custom CSS? Does conditional formatting appear then?

10 |10000 characters needed characters left characters exceeded
Jeff White Jul 26, 2017 at 07:14 PM

I have not yet resolved this but the dashboard which would use it has been put on hold so I have other dragons to slay. Thanks for the input!

10 |10000 characters needed characters left characters exceeded