Skip to Content
Product Information
Author's profile photo Adem Baykal

Let SAC track your KPIs: Send “Data Change Insights” based on SAP BW/4HANA live data via mail or to the home screen!

Update 2023: Please note that this feature is now fully available with the Unified Story! 🙂

Today I want to use a nice SAC feature which is called “Data Change Insights” together with a “SAC Application” based on a live connection to SAP BW/4HANA (Note: though I am using SAP BW/4HANA as data source, this should also work with SAP BW on HANA or SAP S/4HANA as live data source).

The Data Change Insights feature helps you discover chart-level data changes that are important and relevant to you when you aren’t opening and using analytic applications. It needs to be enabled by application designers, so that application users can set daily, weekly or also monthly subscriptions and configure value ranges to trigger data change insights.

In addition, data change insights can be triggered when there’re value changes across thresholds, value changes across reference lines and top N member changes. For different types of data changes, different chart types are supported.


How the users will be notified? You can receive notifications from SAC within a configured period via emails (one with data change insights, the other with a PDF attachment of the corresponding analytic application) or SAP Analytics Cloud notifications.

Please note that Data change insights is under the license of scheduling.

For more details about the Data Change Insights feature please check the SAC help: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/294a10a9e1004d49a83cfd4e5d67d361.html?locale=en-US

Now let’s start. First I need an analytics application created within the SAC Analytics Designer. Let’s use one, which I have created a while ago. It is a simple application based on a live connection on SAP BW/4HANA. Let’s see, what we can do.

In the next step I switch to the “edit mode”, to change a few settings.
Let’s look into the “Analytic Application Details“:


Scroll down and select “Enable Data Change Insights“. Click “Save” and leave the settings:

A few changes happened. One of them is, that you will see

A few changes happened. One important change is the new “Data Change Insights” folder in the scripting area with an item inside. In the settings you can specify which version of the analytics application will be used by the Data Change Insights feature. You need to select one version. If you don’t do it and save your analytics application again, you will have a new version and the snapshots can’t be created. So only one version at a time will be compared.

There is one important step which needs to be performed as well. For each widget which needs to be tracked by SAC, you need to enable the “Data Change Insights” Feature in the properties of the widget.


Now we can run our Analytic Application.

During the runtime of your analytic application you can activate Data Change Insights for each tile, by just subscribing to it. We will do this only for the Gross Revenue!

We can also set a subscription range by selecting “Set Subscription Range” in the menu.
Let’s use it.


Finally we can set a range. SAC will track the data changes according our settings.
I will set a fixed value for the Gross Revenue:


I leave the settings with “OK“. Now we are ready to continue. Select “Tools” -> “Subscribe Data Change Insights” from the menu:


We can now maintain a few settings (name, date, time, recurrence, receivers).


Set the details for the recurrence:


If the SAP BW Query contains variables, you can edit prompts by clicking on the “Edit Prompts“:

If anything is done, we finally create the subscription:


You will see a popup which will guide you to the calendar. You can open the calender also from the navigaion panel on the left side. There you will find the events related to your subscription.


Once the event status wents to “Successful“……….


…. I receive “two” emails from SAC. The first email has a snapshot as PDF inside. The second one shows some details.


But currently nothing happened, as there was not data change on BW side.
We still see the same value as on the screenshots before.


One day later we did some changes on SAP BW/4HANA side. Our Gross Revenue is now higher:


As we use SAC in a live mode, we can see the new data from SAP BW/4HANA in our application. In this case the higher Gross Revenue value:


As you remember, we have created a schedule a few steps ago, where we set a recurrence range around three days. And the next schedule was planned to start one day later.

And one day later SAC checked the snapshots of the data and I have received a notification via email that numbers has been changed 🙂


We know that you can be notified via email or SAC notifications. There is also a way to leverage the script API in the SAC Analytics Designer to build some cool stuff around this Data Change Insights feature within applications. But there is another, much simpler way to consume this notifications in SAC – via the SAC home screen.

Since Q1 2022 users can now add Data Change Insights as a tile on the SAP Analytics Cloud Home Screen to include:

  • Subscripted data changes across applications
  • Ability to search a certain data change
  • Ability to filter data changes with different criteria (top N, time range, importance, and the like).

All you need to do is to go to the SAC home screen and there you can maintain the “Home Screen Settings“:


In the next step you need to activate “Data Change Insights“:


Finally you can see a new tile on your home which shows the Top Data Chance Insights.


If you click on a number, you will see a chart with details:


The SAC Home Screen is really cool and as you know you can move any item on the screen:

The following video shows only the resultnot the process:

Cool stuff 🙂

Please note that the snapshos will be saved by default in the “Local Tenant Storage(A).
SAC Administrators can add their own Data Repository (B) if requested.


Let’s summarize the blog content.

Your key takeaways:

  • The Data Change Insights feature helps you discover chart-level data changes that are important and relevant to you when you aren’t opening and using “analytic applications”. SAC stories are not supported.
  • Data change insights can be triggered when there’re value changes across thresholds, value changes across reference lines and top N member changes. For different types of data changes, different chart types are supported.
  • You can track the change of absolute values and the deltas!
  • You will be notified via email and SAC notifications
  • You can also be notified on the SAC home screen (Data Change Insights from different applications can be shown)
  • Data change insights is under the license of scheduling. If you’re an admin, refer to Configure Scheduling of Publication.
  • SAC will compare different snapshots of the data. There can be only 1 snapshot a day. If you create more than one a day, the last snapshot will be overwritten.
  • Application Designers can enable Data Change Insights and leverage Script APIs.
  • Application Users can subscribe to Data Change Insights and view Data Change Insights.
  • Application Designers has some more options using the Script API. I can recommend the blog post from Aleksey Salinin for further details and examples.
  • On application level, no date changes insights will be generated and users will get a warning if:
    • The application gets modified during subscription period (two snapshots from different document save versions).
    • The application view is a different one.
    • The model variables from the URL parameter are changed.
  • On chart level, the comparison within a chart will be ignored if:
    • A chart’s model variable is changed.
    • A chart’s filter is changed (except for dynamic datetime filter).
    • A chart’s calculated measure’s referenced script variable is changed.

I hope you liked the blog and let’s see, what we will see in the next one. 🙂

Best regards to all SAC fans out there.

Adem

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martijn van Foeken
      Martijn van Foeken

      That's a great blog Adem! Thanks for sharing!

      Author's profile photo Edgar Kim
      Edgar Kim

      Thank you for this blog post Adem.

      FYI: according to this answer: Data Change Insights is not available for live connections yet.
      I have tested with SAC version 2022.8.14: the option to activate data change insights on a chart is still not available.

      Author's profile photo Adem Baykal
      Adem Baykal
      Blog Post Author

      Hi Edgar,

      As discussed, this feature works with the BW Live connectivity.
      To make it work on your side, please configure the Cloud Connector and then it should work. 🙂

      In the blog there was a hint:

      Hope that clarifies everything.

      Best regards,

      Adem

      Author's profile photo Florian Decker
      Florian Decker

      Awesome blog Adem. Thank you so much for sharing!

      Author's profile photo Jove Shi
      Jove Shi

      Really great article to list DCI recent new features! Look forward to getting more feedbacks to continuously improve it!

      Author's profile photo Blaz Zabukovec
      Blaz Zabukovec

      Great content Adem!!! Thx!

      Author's profile photo Josef Hampp
      Josef Hampp

      Great blog, Adem. Thanks!

      Author's profile photo Younes Hasba
      Younes Hasba

      Hello Adem,

       

      very nice Blog as always. thanks!

       

      we have tested this with BW Live on Hana but i can only subscribe to the changes from the Menu “Tools” -> “Subscribe Data Change Insights

      but not in from the Charts, is there any restrictions in terms if the Live Connection is based on Hana or BW/4Hana?

       

      thank you

      best regards

      Younes

       

      Author's profile photo Adem Baykal
      Adem Baykal
      Blog Post Author

      Hi Younes,

      Thanks for your feedback.

      It seems that I missed to mention an important step in the blog which is available in the video.
      For each widget which needs to be tracked by SAC, you need to activate this feature in the properties of the widget:

      I have updated the blog accordingly. Thanks for giving me the hint. 😊

      Best regards,

      Adem

      Author's profile photo Younes Hasba
      Younes Hasba

      Thanks Adem, that's the solution!

       

      Best regards

      Younes

      Author's profile photo Adem Baykal
      Adem Baykal
      Blog Post Author

      Great to hear that Younes.
      Best,

      Adem

      Author's profile photo Beat Andreas Honegger
      Beat Andreas Honegger

      Thanks a lot for this detailed Blog.

      Questions:

      1. Which Data sources are supported? Is there a PAM about that?
      2. Did you already checked that out with the unified Story

      Thanks for your Feedback

      Beat

      Author's profile photo Adem Baykal
      Adem Baykal
      Blog Post Author

      Hi Beat Andreas Honegger,

      Thanks for the feedback. The feature is independent of the data source. It should work with SAP BW, SAP HANA, SAP S/4HANA etc. It comes as a no code feature into the Unified Story (Optimized Design Experience).

      In the Optimized Design Experience you can activate Data Change Insights in the “Story Details”. If you did that, you can activate it in the builder (right side) via “Quick Menus” for the required widget.

      You can also convert an existing SAC Designer application to the new Optimized Design Experience and can test it also.

      Best regards,

      Adem

      Author's profile photo Sergey Berkovich
      Sergey Berkovich

      Useful blog post, Adem. Thanks a lot!

      Meanwhile I could not understand how to add more views (View 2, View 3, etc.) to send each view to the distinct specified users/team.

      Is it possible?

      Compared to general Schedule Publication, there is no "+ Add Another View" button here in Data Change Insights Subscription form.

       

      Thanks for your assistance.

      Best regards,

      Siarhei

      Author's profile photo Bartłomiej Poteraj
      Bartłomiej Poteraj

      Thanks for demonstrating the feature.

      Are Data Change Insights supported for SAP Datasphere live connection?