Skip to Content
Technical Articles
Author's profile photo Carlos Zavala

SAC: Consuming data easily from SAP BOE Universes

Introduction:

SAP Analytics Cloud allows live and import data connections to practically whatever source data(Cloud and on-premise systems, SQL DBMSs, hyperscalers, BOE report and universes, DWH systems, files, etc) however data ever needs to be at least business “semantized” in order to create your models or datasets inside SAP Analytics Cloud, that means that there is not possible to use SAP Analytics Cloud as a Data Warehouse system (ETL processes, multi-dimensional data modeling, analytic data engineering, etc)

On the other hand, is really useful to take advantage of consuming analytic data from the most classic SAP BI system known as SAP Business Objects Platform since it contains already business “semantized” data inside their data universes.

However, to do it under best practices you may need to use some additional technology infrastructure like licenses and  third software components(SAP BOE Live Connector, SAC Agent, JVM Runtime, SSL security, CORS setup, Apache Tomcat, enabling of SAP Open Connectors, SAP Business Technology Platform, SAP Integration Suite, network setups, authentication tunning, servers, OSs, etc)

Next, we are going to explore an easy workaround  to set up all in just 20 minutes to consume data from an SAP Business Objects universe, in summary, the steps list will be:

A- Create a Webi report from a universe containing all the relevant dimensions and measures
B- Set up an instance over the previous Webi report and save data to a free shared cloud location.
C- Connect SAP Analytics Cloud to the same cloud location to use this data in your Model and Datasets

Prerequisites:

  1. SAP Analytics Cloud Tenant
  2. Either Dropbox, MS Onedrive, Google Drive, or an SFTP Service setted locally in your BOE Server
  3. Universes in SAP BOE Platform.
  4. Basic knowledge about SAP BOE and SAP Analytics Cloud administration.
  5. Enough permissions for 1,2 and 3.

Create a Webi report from a universe containing dimensions and measures:

1- In BI LaunchPad create a webi report and select your universe as a data source.

xxx

Universe selection

2- Drag and drop each parent folder into Query Panel to include all dimensions and measures belonging to your universe, if necessary add filters.

3- click on” Apply Changes and Close” to go to your report design:

xxx

Query Panel

4-Hide Header and Footer elements and remove the title box.

5- Rename your report and align the table with data to the left side as much as possible(useful for excel export).

6- Repeat steps  2,3,4 and 5 for all the universes you want to include, please consider a page per universe in the same report.

7- save your report.

xxx

Web Intelligence

Set up an instance and save data to a shared cloud location:

 

8- login to SAP BOE CMC

9- In the folder section find your report and create a schedule for it.

10- Go to Formats sections and check “Coma Separated Values (CVS) – Data”, you can use “Microsoft Excel” but it may not work in case your BOE System runs over Linux/Unix environments.

11- Check “Generate Separate CVS per Data Provider” it will allow you to export data for multiple universes in the same process.

12- In the Destination section select “File System” and uncheck “Use Default Settings” (check KBA 1985084 if you prefer the “Use Default Settings” option)

13- Nex use a proper user and password, it should be an OS user and in “Directory” define a path to some folder inside your Dropbox, MS Onedrive, or Google Drive folders.

14- Check “Use Specific Name” and use a meaningful name for your file’s data.

15- Define a recurrency for your schedule and save it, in order to guarantee data refreshment to your SAP Analytics Cloud model.

16- Go to the Instance Manager in CMC and test(run) your schedule.

17- After some minutes check the CVS files created in your folder belonging to your cloud storage service.

xxx

Report Schedule

Connect SAP Analytics Cloud to the same cloud location:

18- Login to your SAP Analytics Cloud tenant, go to the “Connections” section, click on “Add Connection”, select your cloud storage provider(Dropbox, MS Onedrive, Google Drive, or SFTP Service), and put in your user and password.

xxx

Connections

19- Go to the Modeler and select “From Data Source”, choose your previous connection and select the corresponding file

xxx

Selecting files

20- Next check “Use first row as column headers” and click “Next”

21- Confirm your file from Draft Data and that’s it, everything is ready to define your model and create a Story or an Application as normally.

xxx

Modeler

22- Finally, to enable data refreshment, open your Data Source and define a recurrent schedule under Job Import and save it, consider the schedule created in CMC to define your schedule here.

 

check KBA 2569847 for questions and help

Thank you for reading

 

 

 

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.