SAC: Consuming data easily from SAP BOE Universes
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 the 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 to SAP Analytics Cloud, 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 the data to a free shared cloud location.
C- Connect SAP Analytics Cloud to the same location and use this data to construct your Models and Datasets.
- SAP Analytics Cloud Tenant
- Either Dropbox, MS Onedrive, Google Drive, or an SFTP Service setted locally in your BOE Server
- Universes in SAP BOE Platform.
- Basic knowledge about SAP BOE and SAP Analytics Cloud administration.
- 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 some universe as a data source.
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:
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.
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 following the next steps.
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.
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.
20- Next check “Use first row as column headers” and click “Next”
21- Finally confirm your file from Draft Data and that’s it, everything is ready to define your model and eventually create a Story or Analytics Application in SAP Analytics Cloud.
22- You can enable data refreshment easily by opening your Data Source previously created and defining a recurrent schedule under Job Import and saving it, keep in mind the schedule created in BO CMC to define your schedule here.
check KBA 2569847 for questions and help
Thank you for reading