Skip to Content
avatar image
Former Member

DS Scorecard Conditional Formatting with multiple columns

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!

dummy-table.png (3.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 11 at 09:40 AM

    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/


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 11:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 02:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12 at 06:11 AM

    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! :)

    Add comment
    10|10000 characters needed characters exceeded