SAP Cloud ALM Extend with APIs (Part 5): Digital Boardroom with SAP Analytics Cloud

Moving to the cloud and managing mission-critical SAP systems in the cloud brings a lot of new and difficult challenges for SAP IT organisations.

SAP Cloud ALM helps to run your SAP Cloud systems with optimal cost, improved performances, and maximum values.

Built on the SAP Cloud for Analytics solution, a SAP Digital Boardroom can provide intuitive real-time navigation to your different ALM KPIs based on a single source of truth about your most important business metrics.

SAP Digital Boardroom enable executives to find insights and address ad hoc questions allowing you to make fact-based decisions to drive your business helping organisations effectively monitor and drive change in the digital economy SAP Cloud and hybrid solutions.

Step 0:  Understand Data Provider metadata

 Run the following OData calls to retrieve the metadata information for supported data providers.

{{SERVICE_URL}}/calm-analytics/v1/odata/v4/analytics/DataSet?
$filter=provider eq 'PROVIDERS_LIST' 
and query eq 'provider=DP_TASKS;
metadata=dimensions,measures,attributes'
&$select=d1k,d1v,d2k,d2v,d3k,d3v,d4k,d4v,d5k,d5v

You can test SAP Cloud ALM analytics API data providers from the SAP API HUB, with the data provider dataset with the following request parameters:

• provider eq ‘DP_PROJECTS’ and period eq ‘L1D’ and resolution eq ‘D’ to get the list of the projects.
• provider eq ‘DP_TASKS’ and period eq ‘L1D’ and resolution eq ‘D’ and query eq ‘project=f3639825-e409-43f0-9d42-ac8f96f5fbb0‘ to get the list of projects tasks.

Step 1: Create a connection from SAP Analytics Cloud

From your SAP Analytics Cloud, create a connection of type “OData Services”.

Enter the following information:

• Connection Name: name of your ALM tenant. (ex: my SAP Cloud ALM tenant)
• Data service URL: https://<tenant_name>.<region>.alm.cloud.sap/api/calm-analytics/v1/odata/v4/analytics/
• Authentication Type: OAuth 2.0 Client Credentials
• OAuth Client ID: client ID of ALM tenant.
• Secret: secret ID of ALM tenant.
• Token URL: https://<tenant_name>.authentication.eu10.hana.ondemand.com/oauth/token
  • ex: https://calm-demo.authentication.eu10.hana.ondemand.com/oauth/token

Step 2: Create a Data Model

From the SAP Analytics Cloud Modeler, you will be able to create your data model from your data source:

Select OData Services as Data Source.

Select your connection to your ALM tenant in the Connection field.

In the OData Services Query selection screen, enter the following values:

• Data: list of columns values.
• Filters:
  • Data Providers: name of the data providers (ex: DP_TASKS).
  • Period: (ex: L1W).
  • Resolution: (ex: W).
  • Query: projet=${guid} (ex: project=196dc37c-dcd1-4cc4-aed3-983fd1332e8x).

Press the Create button to create your model.

On the next screen, you can adapt the dimensions and measurements of your data model:

• Set correct types for timestamps and dates.
• Rename the generic column name: (ex: d{x}v and m{x}v …)
• Delete unwanted columns,
• Save your model.

You can repeat the data model creation to connect to different data sources or different objects from the same data sources.

Step 3: Create Story

The SAP Analytics Cloud story lets you create story to explore and visualise your data for reporting,  planning, and analysis.

Step 4: Create your Digital boardroom

SAP Digital Boardroom harmonises the view of company operations across all lines of business in one easy-to-consume, highly visual application fo collaborative decision-making.

SAP Digital Boardroom lets you import the content of your different stories.

Back to the first article in the blog series.

Next blog: here

Thanks for reading.