Flag based color coding in cross tab

[Former Member]

Hi,

I have a dashboard which has cross tab as main component, in the back end a flag has been setup with the logic and condition based on thresholds which color needs to colored to a specific cell based on the value of the cell. How do i use this flag and setup color coding for the measure in the cross tab in SAP design studio?.

Thanks

Harish

[MustafaBensan]

Hi Harish,

We will need more information to answer your question:

1. What version of Design Studio are you running?

2. What is your data source: BW BEx, HANA or a Universe?

3. A screenshot of the data source initial view showing the structure, including the flag and measures you are referring to.

Regards,

Mustafa.

[Former Member]

Hi Mustafa,

1. 1.6 SP3

2. BWBeX

[MustafaBensan]

And what about the screenshot I requested?

Have you defined Exceptions in the BEx Query?

[Former Member]

Hi Mustafa,

I cannot take a screenshot and send you as it is restricted.

Regards

Harish

[MustafaBensan · Accepted solution]

Hi Harish,

Without further details it is difficult to provide you with a specific solution. Based on the limited information provided, you can try either of the following options:

1) You can define Exceptions in your BEx Query and then set the Conditional Formatting Visible property of the Crosstab to true; or

2) Apply the dynamic CSS method for Crosstab as described in the following post:

https://blogs.sap.com/2016/07/05/generate-css-code-dymanically-in-design-studio-with-the-community-p...

Regards,

Mustafa.