Skip to Content
Author's profile photo Ingo Hilgefort

Feature Highlight – Dynamic Conditional Formatting in SAP Analytics Cloud

Some of you might have already used the conditional formatting in SAP Analytics Cloud before and you might have been a little “disappointed” because all you were able to configure were static number ranges.

 

As shown above, we could easily create a conditional formatting based on a measure and define the number ranges, define the color, and select a icon …

… but the problem is that these are static and in case the granularity changes or the dimension changes, or we use a drill down then the threshold we defined becomes invalid because it does not adjust to the new scenario and the threshold values we defined are not applicable to the changed scenario.

So we need to be able to make the threshold dynamic, which is now possible in SAP Analytics Cloud.

You can now setup threshold rules, where you compare 2 measures against each other and then define the threshold values based on the percentage value.

 

For example, above we compare the original price with the discount value and based on the discount we configure the different threshold values.

So why is the option to configure this in a dynamic way important ?

Lets take a very simple example:

Above we can see a table with our product hierarchy and we can see the discount column leveraging the configured threshold. So on the top level of our hierarchy, all our product categories give us a red flag.

So when we then drill down to the next level…

.. we can recognize, that not all our products are in the red zone but instead we now can see the threshold values adjusting – based on the dynamic rules we defined – to the lower level in the hierarchy.

 

Hope you enjoy those new options.

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kannan Ramaswamy
      Kannan Ramaswamy

      Great to know. Thank you.

      Author's profile photo Cristina Talmaciu
      Cristina Talmaciu

       

      How could you manage to change the color of the triangle? If I choose the triangle and try to change the color it switches automatically to circle and it allows me to change the color only for circles, not for triangle or square.

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Cristina,

       

      when you select the icon, click on the arrow next to it, then click on More and then you can set the color.

       

      regards

      Ingo

       

       

      Author's profile photo Eric Gleiss
      Eric Gleiss

      Hi Ingo,

       

      great blog post! I would like to add a dynamic threshold to compare with another measure, but the "measure" option is greyed out. What could be the reason for that?

      Best regards, Eric

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hi Eric,

       

      I would guess that your data source is a BW Live connection ?

      if so, that option is not supported with BW Live yet.

       

      Regards

      Ingo

      Author's profile photo Shreyas Balakuntala Srinivasa
      Shreyas Balakuntala Srinivasa

      Dear Ingo,

       

      Any idea when this will be available for BW Live connection?

       

      Shreyas

      Author's profile photo Ivelina Kirilova
      Ivelina Kirilova

      Just to add - 02.2022 and it's still unavailable. The status is For Long-term Consideration.

      Author's profile photo Comercial CINFA OSS
      Comercial CINFA OSS

      Hi,

      any idea when this will be available for BW Live Connection?

      Thanks!

      Author's profile photo Miquel Fornieles Moreno
      Miquel Fornieles Moreno

      Hello Ingo,

      Thanks for your blog.

      I have just tried to use a threshold and compare 2 measures but unfortunaterly it doesn't work. I would appreciate if you can help me. I want to compare 2 measures.

      • Calculated measure "Proj M".
        Restricted measure "1".

      If Measure "1" is greater than or equal to measure "Proj M" -> green light.

      If Measure "1" is less than measure "Proj M" -> green light.

      I have created a threshold and it is activated but SAC doesn't show colours.

      Thanks in advance.

      Regards,

      Miquel

      Author's profile photo Amritha R
      Amritha R

      Hi Ingo,

       

      Is this functionality available for Live S/4 hana connection - measure was greyed out.  I wanted to achieve a scenario wherein a measure of this year should compare with previous and if greater - will be green. How can i achieve this?

       

      Thanks

      Amritha

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Amritha,

       

      you would have to check on the latest supported elements from SAC for the S/4 Connection in the online help to see if it is supported

       

      Regards

      Ingo Hilgefort, SAP

      Author's profile photo Hassan Mustafa
      Hassan Mustafa

      Hi Ingo,

       

      Thanks for post, I have one question though, is it possible to take threshold percentages as dynamic from a dimension as currently they ll have to be set as static percentages.

       

      Thanks again.

       

      Hassan

      Author's profile photo Orlando Ledezma
      Orlando Ledezma

      I have the same question. We need an option to make threshold percentages variable as well as the labels in the legend and chart

      Author's profile photo shilpa MukG
      shilpa MukG

      is it possible to compare the measure 1 against another measure 2 with numerical range

      +5 or -5 ranges not in percent value range.

       

      Ex:  Measure 1  is 40

      Measure 2 is  38.20 now this falls under -5 to 0 ranges