DS Scorecard Conditional Formatting with multiple columns

[Former Member]

Hello!

I'm using DS 1.6 with SAP HANA DB.

I have a table as below for example :

Based on the different flag values, I would like a different color on my ID.

For example : if Flag1 is Y, I would like ID to be red. If Flag 2 is Y I would like ID to be Green and so on.

I'm not sure how to accomplish this.

Any help would be really appreciated.

Thanks!

[Former Member]

Thank you all for your responses. I found a work around and concatenated the columns into one column in HANA. That did the trick.
Thanks again! 🙂

[former_member276213]

Hi

Why don't you use cross tab?

if you use a cross tab, then we can achieve this by below steps

1.Open hana view using analysis for office (ensure u use hana https: OLAP connection from BO)

2.Define conditional formatting in analysis for office for the respective field.

3.do a smart copy for AO

4.perform smart paste in design studio datasource (then design studio will point the data source using same hana http OLAP connection)

5.assign the datasource and turn on the conditionalformatting for cross tab in the design studio which should assign the alerts.

Br,

Lakshmikanth Adharapurapu

[howsy]

Hey Pavitra,

are you using a SAP HANA View directly? Or are you using a query (even tho the DB is HANA?). If you're using a query, you can achieve that by using Query-Exceptions. I know no way of achieving a dynamic-formatting of the Crosstab within DS 1.x, using directly a HANA View.
With Lumira 2.x, on the other hand, this is possible.

Regards,
Chris

[TammyPowlas]

First, I am not using HANA, but I found a possible option for you based on this JustBI blog: https://www.just-bi.nl/design-studio-conditional-formatting-on-sap-hana/