Dashboard Designer, embedding SAP Analytics Cloud (SAC) Stories into SAP Digital Manufacturing Cloud (DMC) Dashboards

In this blog post, I would like to share detailed information on how you can embed SAP Analytics Cloud (SAC) stories into SAP Digital Manufacturing Cloud (DMC) Dashboards using Dashboard Designer, to mix and match data and analytics from both products, enabling even richer dashboard creation.

Integration Diagram

But first, let´s review a couple of concepts:

Dashboard Designer

Dashboard Designer app helps you create interactive manufacturing dashboards using drag and drop on a wide variety of business and operational data.

Source: SAP Help Portal.

Now that you know a little bit more about Dashboard Designer, let´s see how it can be used to create a Dashboard showing a SAP Analytics Cloud (SAC) Story and combining it with Digital Manufacturing Cloud (DMC) data.

First, login to SAP Analytics Cloud (SAC) in order to create a new OAuth Client

Navigate to System > Administration

Go to App Integration tab, scroll down and click Add a New OAuth Client button

In New OAuth Client popup, enter a Name, select ‘Interactive Usage’ as Purpose and inform SAP Digital Manufacturing Cloud (DMC) URL +”/SacView” in Redirect URI field.

Ex: https://<subaccount>.execution.<region>.dmc.cloud.sap/SacView

Click Add.

A new OAuth Client is generated, including OAuth Client ID and Secret.

Click Show Secret to display it.

Go to Digital Manufacturing Cloud (DMC) subaccount in BTP Cockpit, open Destinations and click New Destination.

Create a New Destination as follows:

Where:

Name: SAC_OAUTH_DESTINATION

Type: HTTP

Description: Anything

URL: SAC URL + “/oauth/authorize”. Ex: https://<subaccount>.authentication.<region>.hana.ondemand.com/oauth/authorize

Proxy Type: Internet

Authentication: NoAuthentication

And add the following Additional Properties:

client_id: Client ID generated in SAC

client_secret: Secret generated in SAC

redirect_uri: https://<dmc subaccount>.execution.<region>.dmc.cloud.sap/SacView

sacDomain: https://<sac subaccount>.<region>.sapanalytics.cloud

tokenUrl: https://<sac subaccount>.authentication.<region>.hana.ondemand.com/oauth/token

Check Use default JDK truststore

Save the New Destination and click Check Connection.

Open Dashboard Designer app in SAP Digital Manufacturing Cloud (DMC) and create a new Dashboard.

And expand SAC Stories menu option.

If SAP Analytics Cloud (SAC) logon popup shows up, login accordingly

The list of available SAC Stories will show up, drag&drop a story to the dashboard.

If any extra data source authorization is needed, login popup will show up.

Click Save to save the Dashboard.

Click Create Tile to create and publish a new tile for this dashboard

Inform a Name and Description for the new Tile and click OK

Go to SAP Digital Manufacturing Cloud (DMC) Launchpad and click the tile to launch your Dashboard

Dashboard loads with the SAP Analytics Cloud (SAC) story embedded inside

Back to Dashboard Designer app, you can now Mix&Match SAC Stories with local Stories into SAP Digital Manufacturing Cloud (DMC) data.

In Layout Controls, drag&drop a Horizontal Divider.

Expand Transactional Data menu option, and drag&drop ‘Plan Vrs Actual Production’ object to the new divider space.

If needed, adjust ‘Plan Vrs Actual Production’ object filters, date, dimensions and etc.

Save and click Launch to launch the dashboard.

Dashboard will launch again, this time showing combined analytics of both products side by side.

In this blog post, you learned how to leverage SAP Digital Manufacturing Cloud (DMC) Dashboard Designer app to create dashboards that not only display SAP Analytics Cloud (SAC) stories embedded, but is also capable of combining SAP Digital Manufacturing Cloud (DMC) and SAP Analytics Cloud (SAC) analytics side by side, enabling even richer dashboard creation.

In order to do that, you created a New OAuth Client in SAP Analytics Cloud (SAC) and a new Destination in BTP Cockipt of the SAP Digital Manufacturing Cloud (DMC) subaccount, before using Dashboard Designer app to create nice dashboards combining data from both sources.

Do you like this post? Please let me know in the comments section what you think. Any feedback is highly appreciated.

Or, if you have any questions, please check SAP Community Q&A Area, or comment down below.

Thanks,

Manoel Costa