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

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