Hello,
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.
Capture the login page as an application and declare elements (username, password and login)
Create automation for Login
Set element username, password and click on Login
Start Screen
Part 2: - Download a file which is stored at the location “My files / Public / IRPA Test / Test IRPA file"
Part 2.1 Create application to capture all the pages and declare the required elements
Capture the page and declare the element "Public Folder"
Capture the page and declare the element "IRPATest"
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 multiple screen in one application
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
https://sapvideoa35699dc5.hana.ondemand.com/?entry_id=1_cqff0oux
For More Information: