In this blog post, you will learn how to import, work with, and effectively use SAP Analytics Cloud content.
Business Content is a great resource to help kick-start your story-telling journey with SAP Analytics Cloud (SAC). Today, the Content Network in SAC hosts over 70 content packages delivered by SAP (Business Content) and over 60 content packages delivered by our partners (3rd Party Content). With over 35k downloads from the Content Network by over 3k customers, SAC Business Content and 3rd Party Content sure is perceived as a real value-driver for our customers that accelerates their Analytics content creation and consumption workflow and differentiates SAP Analytics from the rest.
While we have seen great interest and traction for SAP Analytics Cloud content, we also receive several queries from customers and partners about how they can work with content packages after importing them from the repository. In this blog, I will try to explain simply how you can work with different content packages after importing them to your systems.
SAP Analytics Cloud content typically comes with 2 connection types: Live and Data Acquisition (Import).
For more details on Live vs Data Acquisition, please refer this blog post.
Irrespective of which connection type a content package is based on, the way you import the content from the Content Network remains the same.
Covered in this Blog Post:
- Importing Analytics Content from the Content Network
- How do you know the data connectivity that a content package is based on?
- Working with Content Packages based on Data Acquisition (Import) connectivity
- Working with Content Packages based on Live Data Connectivity
- How to get support for Business Content?
SAP Analytics Cloud content (Business Content and 3rd Party Content) is available in the Content Network in SAP Analytics Cloud.
- From the main menu, select Browse > Content Network.
- Choose Business Content tile (for SAP-delivered content) or 3rd Party Content tile (for Partner-delivered content)
- Select desired package.
- Review the package overview, description, contents and deployment options.
- Choose “Import”.
You can usually find the data connectivity details on the Overview page of the package that talks about the package description:
Another simple way to identify the datasource details of a package is by referencing the Content Inventory excel. This is a great resource which is embedded within the roll-out slide deck to quickly filter the content packages by data source/connection types.
In the link that hosts the roll-out slide deck, ensure to enable the Sidebar to be able to view the Content Inventory excel attachment.
You can quickly browse the Content Inventory Excel to understand the connection type, backend data source details, among many other details: For example – dependent packages for any given package, if the package uses planning capabilities, smart features, Geo maps or R-visualizations.
The content that comes with Data Acquisition is ready to run with sample data – so you could start browsing stories and digital boardroom content immediately after importing them. The usage of models based on data acquisition facilitates the consumption of the content, because it enables the delivery of sample data. Thus, the content based on these models is ready to run without any additional effort and no additional systems are required yet. However, this is not to be mistaken as a recommendation for productive use: Please analyze if a live connection is available and suitable for your business scenario and use the same instead. You would need to import data from your source systems and make the necessary mappings and data transformations as specified in the documentation, before you can use the content productively.
When you import a package based on data acquisition, you would notice the “Connection” in the list of objects to be imported in the “Import Options” tab when you click on any content package in the repository.
For the purpose of this blog, let me walk you through an example of importing “SAP Human Resources – SuccessFactors” package from the repository.
After you have successfully imported a content package from the Content Network, you would see all the artefacts of the package in corresponding folders in your system.
In case of Business Content,
- All Stories, Digital Boardrooms, can be found in: Files > Public > SAP Content > “Name_of_the_package”
- All Models, can be found in: Files > Public > Models
It is always recommended to copy the files of a content package (Models, Stories, Digital Boardrooms) to a different folder and not continue to work on them in the same folders that they were downloaded into from the Content Network. This is to prevent any accidental loss of modifications/customizations made on the content during a re-import from the Content Network.
After having successfully imported the content, you can now open and view the Digital Boardrooms or stories. This will give you a good overview and a first understanding of what is included in the content.
If you find that SAP Content fits you immediately, you may want to clear the sample master and transactional data and then load your own data afterwards to start using the content productively.
To clear sample data from the model, perform the following:
- Go to Main Menu > Browse > Files > Public > Models
- Select a model in the Modeler list by clicking on it.
- Select Delete Facts icon (the eraser icon) on the toolbar.
- The complete list of dimensions in the model is displayed in a dialog. You can choose to clear data from the entire model or from individual dimension members.
- After making your selection, select OK to continue. This displays a verification prompt that you must confirm to complete the operation.
This would clear all/selected sample data from the models. And you can now proceed with loading your own data to the models.
Once you’ve cleared sample data from the model, you can import your own data into the model. You can import data from File or various other sources. It is recommended that you follow the official documentation and import data from the same sources as mentioned in the documentation, so you would have data mapped correctly to all dimensions/measures in the model.
To import data into existing model, perform the following:
- Go to Main Menu > Browse > Files > Public > Models
- Select the Model and Open it.
- Switch the Data Management Tab.
- Choose “Import Data” under draft sources.
- Choose to import data from a file/datasource, as specified in the documentation and based on your backend.
- Browse to locate your file/connect to appropriate datasource, and choose “Import”.
- After importing, you will see the source listed under draft sources. Open it.
- In the Card view of the “Layout”, carefully verify if the field names in the source are correctly mapped to the dimension/measure members in the model.
If the field names in the source are the same as those in the model, it will be mapped automatically. If not, you may need to link them manually. Sometimes, there may be errors in automatic mapping – in such cases, you need to manually unmap the fields and re-map it to the correct field.
In this example, “FTE” field in source is incorrectly mapped to “User” field in the model. We need to fix it before completing the import.
8.d. If you notice that, any of the fields in the model are missing from your source, you can map it to “#” for Unassigned.
Some points to note:
- Please note that after you’ve made all the changes, if you ever wish to re-import the same content package or a newer version of the same package from the repository, the system provides the option to “Overwrite objects and data”. This option will update existing objects by replacing the object version in your system with the version in the content package. This option is potentially dangerous, because it can result in irretrievable loss of custom enhancements and also customer data. This option has to be handled with care: When selecting the “Overwrite objects and data” option, the system provides the information which objects will be overwritten. Please check the list carefully. Objects may be delivered in several content packages, especially but not only if you choose industry content packages. The package you wish to download can thus have unintended side-effects, accidentally overwriting objects you were not aware of. If in doubt, do not use the “Overwrite objects and data” option.
- We do not guarantee the backward compatibility of updated content. The content available in Analytics Content Network is forward compatible. For example, the Business content updated and exported in version 2020.08 can be downloaded by any SAC version 2020.08 and above
When you import a content package based on live data connectivity, it comes with no sample data, i.e you would need to establish a connection to your backend system in order to view the visualizations in the stories/digital boardroom. You would need to create live data connections to on-premise or cloud systems, based on the details of the package as mentioned in the documentation. Data is “live”, meaning that when you open the story in SAP Analytics Cloud after creating the necessary connection, changes made to the data in the source system are reflected immediately.
When you click on such packages in the Content Network, you would not see any “Connection” listed in the Content list in the “Import Options” tab of the package.
When you first try to import a package based on live connection, you would get several warnings against the models in the package in the Import summary: “The model will not be usable due to a missing live connection “Connection_Name”.
You would first need to establish a connection to your backend with the same name as specified in the warning, also in the documentation.
On the Connection page, you create and maintain datasource system connections. Here, you must create a connection to the backend with the same Connection name as mentioned in the documentation.
Refer these links to understand in detail about the steps and necessary prerequisites to create live connections:
- Live Data Connections to SAP HANA
- Live Data Connections to SAP S/4HANA
- Live Data Connections to SAP BW and SAP BW/4HANA
- Live Data Connections to SAP BPC Embedded
- Live Data Connection to SAP Universes
In order to verify if the all the necessary connections to the backend are rightly created with the correct names, re-import the package from the Content Network.
This time, Import will be successful without any warnings corresponding to the models.
After having successfully imported the content, you can now open the Digital Boardrooms or stories and immediately start visualizing the data from your source systems, and changes to the data in the source system can be visualized in real-time on the stories.
While SAP is not legally obligated to support Business Content, we always try to do our best to support you with any queries you may have regarding Business Content in general or specific issues you may face while importing SAP Analytics Cloud Content.
Please drop an email to firstname.lastname@example.org, and our team will try to help you.