Skip to Content
User Experience Insights

Integration of SAP Analytics Cloud Stories into Microsoft Teams

Introduction

Many of our cutomers are using Microsoft Teams (MS Teams) for their collaboration and coordination across different business processes. Additionally the SAP Analytics Cloud (SAC) is used by many of those to create meaningful dashboards and stories for reporting and controlling purposes or to create powerful planning applications.

Though the SAC already provides tools for collaboration, I thought about if it was possible to combine the power of both tools in order to provide an integrated solution for reporting and planning access with direct utilization of enhanced collaboration functionalities from the daily business workflow.

The goal was to provide interactive access to the stories, dashboards, analytical and planning applications and planning workflows, developed in the SAC from within MS Teams through dedicated channel access.

Sounds great, does it? You may be surprised, that there is a very easy and straight forward way for such a use case, which comes with zero coding effort for the integration part.

Let´s start!

 

Prerequisites

In order to integrate SAC into MS Teams, you need the following components

  • Access to a SAC tenant
  • Access to a MS Teams environment with a desktop client

 

Prepare MS Teams

We will start the process from the MS Teams side. To be able to create a channel, you need a team. You can either use an existing one or create a new one. This can be done from your Teams menu.

Create%20a%20team%20in%20MS%20Teams

Create a team in MS Teams

 

By default, a “General” Channel will be created with a new team. You can either use this channel or create a new one. Inside that channel, create a new tab and select the tab type “URL”. After selecting the tab type, a configuration window for the tab appears. Leave this open for now.

Create%20an%20URL%20tab%20on%20your%20channel

Create an URL tab on your channel

 

Select SAC Content

Now it is time to select the content, you want to integrate into your MS Teams channel. For that, switch to your chrome browser and access the SAC tenant, you are using for your applications. Log on with your user credentials and navigate to the story or application you want to integrate. Open the story and click on the share button. In the pop-up window, copy the share link to your clipboard.

Copy%20the%20share%20link%20to%20the%20story%20or%20application

Copy the share link to the story or application

 

Integrate SAC Content to your URL tab

With the link copied to you clipboard, switch back to your MS Teams instance. Paste the link to the URL field and provide a name for your tab. In case you want the other team members to be informed about the creation of the new tab, check the option, otherwise uncheck it. Click on Save to finally create the tab.

Maintain%20the%20URL%20tab%20parameters

Maintain the URL tab parameters

 

After saving, you should initially see the log on screen from your SAC tenant. You can log on using you usual credentials.

Log%20on%20to%20SAC%20from%20within%20Teams

Log on to SAC from within Teams

 

 

Depending on the design and model of your selected story or application, the process after log on may differ.

  • If your story contains live data connections, you will be asked to authenticate against your source system via a MS Teams prompt. Type in your credentials for your source system and submit. After submitting your correct credentials, the corresponding data will be loaded and the story or application will be populated as designed.

Authentication%20window%20for%20live%20data%20connections

Authentication window for live data connections

  • If your story is only consiting of aquired data models, you will not need to authenticate again. Instead the dashboard will directly be shown with the stored data.

 

Congratulations, you just integrated your story into a MS Teams channel with the story being fully dynamical and flexible to user interaction!

Populated%20story%20within%20MS%20Teams

Populated story within MS Teams

Every user with access to the team and the tab can now access the story undergoing individual SAC (and source system) authentication. This means, your data is safe against unwanted access, as no user cedentials are shared.

 

I hope, that straight forward way of providing an integrated view on your SAC stories an application from within MS Teams can be useful for you. In case of questions or feedback, please comment on that blog post. I will be happy to get in touch with you.

5 Comments
You must be Logged on to comment or reply to a post.
    • Hi Ashish,

      regarding functionalities of the SAC, I could not find a limitation so far. I was able to use the view and the design mode just as in Chrome. This is also true for aquired models (import connection) as well as live models (direct connection). For SSO, in my setup the user is still asked for the source system credentials, but this may be due to my current IdP settings, which I could not yet check in detail.

       

      Kind regards

      Eric

  • Hi Eric,

     

    We have SSO in place for SAC with live BW models and it does not ask for Credentials. The link in MS Teams seems to be working well but it shows error “Cannot Connect to the system view”. Is this is a bug? Also i am assuming this feature only works on Report by report basis. Meaning i cannot jumpt to other report,right?

     

    King Regards

    • Hi Romain,

      thank you for testing it with your SSO configuration, glad it works with a proper IdP setup!

      I also experienced the error message in further testing, but I could not notice a negative side effect, since the connection to the data source is still established and can be used. So this seems to be a bug, that may be caused by some connectivity hiccups. Mabe SAP could do something here in the future, if they had a closer look that integration scenario.

      For Live Data connections it indeed seems to be the case, that currently the feature works on a report by report basis. That would result in a best practice advise to link a URL tab in your Teams to a specific reports or dashboards and use it to integrate those with one URL tab each. Switching between Reports should then be done in Teams by selecting a different URL tab, rather than navigating in SAC though the folder structure. Integrating the base URL of your SAC tenant to the URL tab would not be advised way at the moment.

      This of course only holds true for live data connections. In my test I could switch between import model based stories from withing the same URL tab without any issues.

       

      Kind regards

      Eric

       

  • Hi Eric

    Just tried out the above, sadly it’s not working for us when using BW live connection having SSO.

    Getting SAC to start is ok, but there is a small SSO popup in regards to the BW live connection in the story which doesn’t stay inside MS Teams, but goes to the browser and thereby the story fails the connection.

    Wondering if there is a setting in MS teams to allow for popups and stay in MS teams…

    Br

    Bjørn