SAP Intelligent RPA 2.0 – Download excel file from SAP Analytics Cloud to desktop
In this blog post I would like to showcase a scenario that uses iRPA to automate the process of downloading an excel from an SAP Analytics Cloud story to the user’s desktop. The screenshots and recording are all my own. I am using Cloud SAP trial account for the purposes of this exercise.
I have divided this scenario into two automations –
Part 1: Login to SAP Analytics Cloud application
Part 2: Download a file which is stored at the location “My files / Public / IRPA Test / Test IRPA file” in the SAP Analytics Cloud application
Here are the pre-requisites –
- An SAC story already is available in your SAC tenant.
- SAP IRPA installation and set up of the Desktop Agent should be completed.
Part 1: Login to SAP Analytics Cloud
Create an application within iRPA.
Create automation for Login
Part 2: – Download a file which is stored at the location “My files / Public / IRPA Test / Test IRPA file”
Capture the page and declare the element “Public Folder”
Capture the application and declare the element “Test_RPA”
Since the next pages are different views of the same page, we will capture multiple screen under one application and declare the required elements
Capture 1 – The application is created to click on the unique element in the page so that the 3 dots appear, this will be declared as an element in capture 2
Capture 2 – define the three dots as an element “More”
Capture 3 – Declare element as “export”
Capture 4 – Declare the element “ok” to download the file
Part 2.2 Create automation
For the SAP Analytics Cloud login, refer to the automation defined in Part 1
Demo : to download the file from SAP Analytics Cloud to the desktop
For More Information: