biExport for SAP Analytics Cloud Blog

Scheduling exports with SAP Analytics Cloud

created: 05.02.2021

SAP Analytics Cloud (SAC) provides a central scheduling and broadcasting function via the toolbar:

/mimes/SAC_Screenshots/biExport_Scheduling_01.PNG

Here you can configure the automatic sending of PDF documents to e-mail recipients at given points in time. Also, you can preset variables and set different variables for individual recipients:

/mimes/SAC_Screenshots/biExport_Scheduling_02.PNG

So far so good...

But what if you want to:

  • Share the report as a high quality (PDF) document, presentation or spreadsheet
  • Schedule the generation based on an (external) event, e.g. new data having been loaded
  • Store the generated files on a sharepoint, web service etc. instead of mailing them
  • Configure the layout of the document individually
  • Configure the scheduling parameters to the very detail

This is when biExport comes into the game.

Scheduling with biExport

biExport provides a separate WebUI to schedule, monitor and trouble shoot SAC document generations:

/mimes/LumiraDesignerScheduler/scheduler.PNG

The biExport SAC Scheduler can be opened directly via the following URL:

https://designstudio-export.com/export_resources/sacscheduler.html .

Note: If you are using your own on-premise installation, replace “designstudio-export.com” with your own installation URI.

Here, you can see an overview list of all your schedules, including runtime and status of each run of a schedule. You can also download the detailed logs, edit or delete a schedule.

In the maintenance view you can:

  1. Switch between calendar-based and event-based schedules
  2. Select the export format, export template etc. (see Export Templates for your Corporate Design)
  3. Select the output channel: mail, fileserver, sharepoint, web service or custom endpoint (see How a biExport for SAC document can be returned or stored)
  4. Name one or multiple Application and/or Story ID as a source for the export
  5. Add parameters to query one or multiple specific views for the export (see Easily generate Briefing Books from SAC in PowerPoint, Word, PDF and Excel formats)
  6. Add a list of recipients if you want to use the Information Bursting feature

/mimes/LumiraDesignerScheduler/formats.PNG

/mimes/LumiraDesignerScheduler/output.PNG

You can also use the download and upload feature to conveniently edit the schedules offline in Microsoft Excel!

Obligatory configuration steps

Because biExpot is an external service to SAC, you have to configure the login method for biExport Scheduler. You can choose between:

  • oAuth
  • SSO

To configure oAuth, please follow the steps described in How to integrate apps to SAC via oAuth – set up Background Execution for biExport. Afterwards, a scheduling users has to use the "Authorize SAC user" feature once, before a schedule can be successfully executed.

/mimes/SAC_Screenshots/biExport_Scheduling_03.PNG

In the schedule details, the scheduling user must be named in the "user" field to authenticate correctly.

SSO can currently only be used with an on-premise installation of biExport. Make sure the biExport service is started by a user that is configured for SSO. The service will then always authenticate with the service user, as long as you leave the field "user" in the schedule blank.

Our Customers

Our SAP Export solutions are alredy used by a number of global companies!

Logo Repsol
Logo Glatfelter Claas
Logo TÜV Süd
Logo JYSK
Logo Airbus
Logo Yamaha
Logo BKW
Logo Geberit
Logo Rockwell Collins

„With the export functionality we can bring fantastic solutions to our Design Studio users. Great tool, fantastic performance and powerful design options.“

Mario Rüger, Senior Architect Business Intelligence, TÜV Süd