Blogs / Business Intelligence / Dashboards / Conditional Formatting in SAP Design Studio For Data From SAP HANA

Conditional Formatting in SAP Design Studio For Data From SAP HANA

Nov 11, 2016

SHARE

Conditional formatting is a feature that alerts BI users about leading and lagging indicators within a report or a dashboard. This feature supported by tools such as SAP Business Objects Analysis for Office (AAO) and Business Explorer.

To use conditional formatting in a crosstab component in SAP Design Studio, you need to set the thresholds for exceptions in Business Explorer or AAO and copy the data source in SAP Design Studio before assigning it to a Crosstab. However, when the data source is a HANA view, conditional formatting is not available out-of-the-box, and we need to perform some scripting to achieve the desired results.

We recently had a customer scenario where the user wanted exception-based color coding on SAP Design Studio that consumed SAP HANA views. To achieve this, we tried leveraging CSS and scripting, but the efforts soon became cumbersome and complicated. So we ended up using Visual BI’s Table component (which comes as part of the Visual BI’s VBX Product Extensions) instead

The formatting Conditions were as follows:

  • Less than equal to 80%: Red
  • Between 80% and 90%: Yellow
  • Greater than 90%: Green
Conditional Formatting in SAP Design Studio For Data From SAP HANA

The data as seen within the SAP Design Studio:

Conditional Formatting in SAP Design Studio For Data From SAP HANA

The Table component delivered a lot of flexibility in defining the exceptions on the front-end. For example, we could replace a number <80% with a stop sign.

Conditional Formatting in SAP Design Studio For Data From SAP HANA

The quick configuration saved a lot of time & effort.

Conditional Formatting in SAP Design Studio For Data From SAP HANA


It was very exciting to deliver a quick turnaround using VBX Product Extensions, especially for something which was not supported out-of-the-box in the standard SAP Design Studio. The VBX Product Extensions comes with a much more elaborate library of components packed with powerful set of features like the above.

Click here to learn more about Visual BI’s Extensions (VBX) for SAP Design Studio.

You may also download the trial here


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This Blog!

Share this blog with your friends and colleagues!