Skip to Content
Technical Articles
Author's profile photo Pratiksha Agarwal

SAP Intelligent RPA 2.0 – Download excel file from SAP Analytics Cloud to desktop

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 –

  1. An SAC story already is available in your SAC tenant.
  2. 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%20the%20login%20page%20as%20an%20application%20and%20declare%20elements%20%28username%2C%20password%20and%20login%29

Capture the login page as an application and declare elements (username, password and login)

 

Create automation for Login

Start%20ScreenSet%20element%20username%2C%20password%20and%20click%20on%20Login

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%20SAC%20page%20and%20declare%20elements%20Public%20Folder

Capture the  page and declare the element “IRPATest”

 

Capture the application and declare the element “Test_RPA”

Capture%20the%20application%20and%20declare%20the%20element

 

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%20multiple%20screen%20in%20one%20application

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%202%3A%20define%20the%20three%20dots%20as%20an%20element%20More

 

Capture 3 – Declare element as “export”

Capture%203%20Declare%20element%20as%20export

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:

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Peter Baumann
      Peter Baumann

      Hi Pratiksha Agarwal!

      Thank you for this example. The video doesn't work for me. Could you please check again.

       

      Author's profile photo Pratiksha Agarwal
      Pratiksha Agarwal
      Blog Post Author

      Please check, the link is updated and you would be able to view the video

      Author's profile photo Pratiksha Agarwal
      Pratiksha Agarwal
      Blog Post Author

      Please check, the video link is updated.

      Author's profile photo Peter Baumann
      Peter Baumann

      Worked for me. Thank you!

      Author's profile photo Former Member
      Former Member

      Thanks for this scenario, I am able to see the video as well.

      Author's profile photo Jedd Go
      Jedd Go

      Hi Pratishka

       

      Thanks for the blog. Is this automation possible on the reverse side? Meaning uploading of xls to SAC?

       

      Thanks

      Author's profile photo Pratiksha Agarwal
      Pratiksha Agarwal
      Blog Post Author

      Hi Jedd,

      Yes you can create an RPA automation to upload an excel to SAC.

      Regards,

      Pratiksha