Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

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.



    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 10:22 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • 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!

    Add comment
    10|10000 characters needed characters exceeded