I hope everyone is doing well, today in this blog i would show you how you can Integrate SAP Concur with SAP Analytics Cloud using Data Acquisition and develop a Analytical Story.
Bestrun is US Based Company who sales bikes so employee always travel for running different campaign, John is a Spend Executive who want to get deep insight into Employee’s Travel and Expense as he feel there is something wrong and Recieves Complain from employees there expense doesnt get approved and posted. Bestrun have concur for employee’s travel and expense and It is also Integrated with SAP S/4HANA for Financial Posting and Re-imbursement. Now the Challenge is John want to see the analytics dashboard where he want to see Approved and Posted Amount and Transactional Amount based on Spend category and Total Approved, Total Claimed Amount based on Quarter for 2018,2019 and 2020.
Let’s get into Action
Well lets first understand and draw a clear picture from above Picture what exactly john is looking for into Technical Terms, So John here is looking for a Analytics Dashboard which reads Data from Concur using Data Acquisition for Displaying into Storyboard. So in this Case first we need to see how we can Integrate Concur with SAP Analytics Cloud, so that we could create data model which we could consume in SAP Analytics Cloud as Analytical Dashboard Story.
From Above Diagram its very clear that in order to Integrate Concur with SAP Analytics Cloud we need to Connect Concur through Data Acquisition, then create a Data Model and Finally Consume it in SAP Analytics Cloud Story. SAP Analytics Cloud Provides Standard Connector to connect almost every SAP line of business cloud solution and Concur is among of those.
Lets break this into step by step
Step 1: Create Connection in SAP Analytics Cloud with SAP Concur
Add New Connection
Now Give the Connection Name and Description, for key and Secret we need to go to Concur tenant we want to connect and register a Partner application with Proper Authorization and get consumer key and secret which is required in order to create Connection.
Login to Concur As a Administrator and Go to Webservices
Click on Register Partner Application
Click on New,
Give Name, Description and Authorization as Below
Copy this Consumer key and Secret Which is required in SAP Analytics Cloud in order to create Connection, Click on ok, you would see this application in the list like below
Now go to SAP Analytics Cloud Connection and Complete the creation of Connection
Click on Create to Create the Connection, it would ask for your consent
Once this Connection would be created, you are good to go with creating Model and Story.
Step 2: Creating Data Model
Go to Create Data Model
Give Query Name and Select Expense Entries Data Source for building the Analytics chart based on Spend Category
Build the Query with Measure and Dimension Fields
Create the Model and Schedule the Job for fetching Live Data Weekely once, By default it would be Unscheduled.
Step 3: Creating Story
Click on Create Story
Choose Access and Explore Data and then Select Existing Data Source
Select the Data Model we created in last step
Select the Chart you want to use
Same way need to create another Data Model for Expense Reports and Add into Story. FInal Dashboard looks like this.
I hope you enjoyed this Blog, If you have any question, please let me know in comment section. Meanwhile enjoy playing with SAP Analytics Cloud, Stay healthy, stay safe.