Welcome back to the topic of “SAP Retail POS Analysis : SAP Data Warehouse Cloud and SAP Analytics Cloud Content out of the box”. In my last blog post, I explained some features and functions of the SAP Analytics Cloud content and how it is related to the underlying SAP Data Warehouse Cloud content.

In this content, I want to describe how easily it is to deploy the content.

To finally deploy and consume the SAP Analytics Cloud story, we need the following 3 ingredients:

• SAP Data Warehouse Cloud Content
• SAP Analytics Cloud Content
• Sample data for the data model (csv files)

Let’s look at the architecture first:

In this picture, you really see everything you need to know. Since the foundation of this content lies in SAP Data Warehouse Cloud, we first have to deploy this business content.

Go into your data warehouse cloud tenant and navigate to the Content Network:

Click on the tile “Business Content” to find al predefined Business Content published by SAP for different line of  businesses, industries or cross scenarios:

Choose “SAP Retail: POS Analytics” clicking on the text (and NOT flagging the checkbox):

Please read carefully all the information here (Yes, I know exactly how annoying this is, but sometimes reading carefully with the intention to understand saves a lot of time at the end. I had to learn this the hard way, too :))

Nevertheless I will focus on the most important part (see the marked section in the screenshot above): If this is the first content from SAP that will be imported into your system, than you have to create a SPACE with the technical Space ID SAP_CONTENT and the Space Name “SAP & Partner Content” (or use the default in if you wish). If this Space already exists, you should get assigned to it and have all the rights you need to import and deploy content.  Understand, that you need to have the role “DW Administrator”, to be able to import Business Content.

IMPORTANT: It is important to create the SPACE with the exact technical ID as the content is tightly connected to this content and it will fail to import, if it does not exist.

Okay, once you have created the SAP_CONTENT SPACE, go back to this screen (tip: open the Space Management to create the content in a separate tab or window of your browser to not loose the context here). 

If you want to get familiar with the content before importing it, navigate to the tab “Import Options”. (I like to understand what’s happening BEFORE I press some buttons).

Do not change any pre-selection here.

Finally, click on the bottom of the box the “Import” button on the lower right to import the content into your system.

When you have done this, you can check the status of the import in the Notifications here:

As soon as the import has finished you also get a toast:

If you click on “Import Summary” you get a detailed overview of imported items:

Please be aware, that it could be, that you get warnings e.g. in case the content SPACE already exists. In general, the status message is useful to detect a potential root cause, if something went wrong. Hover over the icon, to get more detailed information on a warning or an error. 

Now go to the data builder and choose the Content Space:

Here you will find the imported items:

After the import your items have the status “Not Deployed”. You need to deploy the content to use it and upload data into it. To deploy the content, search for POS Analysis an choose SAP POS Analysis Report:

Click on the text and the view will open. Click on the deploy icon an all dependent objects will be deployed, too.

A short notice will pop up, that the view has been deployed. Then you can check again the status of your content items in the data builder. They should have the status “Deployed”:

Congratulation, you just finished the first step by deploying SAP Data Warehouse Cloud Content “SAP Retail: POS Analysis” .

Next step would be to deploy SAP Analytics Cloud Content:

For this, move to your SAP Analytics Cloud tenant:

Before you import your content, check, if the right connection is already setup. For this go to “Connections” and check if there is already a Live Data connection to the SAP Data Warehouse Cloud tenant. Important: The technical name needs to be SAPDWC! 

If this connection is missing, create it as follows:

And please don’t forget: technical Name SAPDWC is crucial:

To import the content, also in SAP Analytics Cloud navigate to “Content Network”-> Business Content:

Search for POS Analysis for Retail:

And click “Import” to import the content package:

Again, check your import summary. Very often the import summary contains some warnings. Typically this is not an issue and the reason is, that some content was imported already and e.g. the folder structure was already available in your system.

Now check, if your content is available. For this navigate to the following folder and check if the story is available:

Congratulation, you successfully deployed SAP Analytics Cloud Content “Retail: POS Analysis”.

Let’s recap:

We have deployed the content in SAP Data Warehouse Cloud and SAP Analytics Cloud. Now we need to upload some data into the tables of the SAP Data Warehouse Cloud Content – which brings us to the last step: Import sample data.. 

The sample data is available as csv files on our Github:

https://github.com/SAP-samples/data-warehouse-cloud-content/tree/master/SAP_Retail_POS_Analytics

You find all CSV files in the folder “CSV”:

For your convenience, you can download all files at once in a ZIP file (dwc_retail_pos_samples_csv.zip). Follow the link and the instructions in the “Download and Installation” section to download the sample data. 

The csv files have the same name as the  tables in the SAP Data Warehouse Cloud, which makes it easy to import them accordingly. After having successfully downloaded the ZIP, unpack the file:  

Navigate to  the Space SAP_CONTENT in the “Data Builder” in SAP Data Warehouse Cloud. Show tables only and search for “SAP_RT_POS_L“ to show all tables at a glance:

Now open each table and upload the corresponding csv file as follows:

Check “Use first row as column header” and import:

Do this for all tables of the data set.

Once you have uploaded all files, the SAP Analytics Cloud story is ready to be used:

Congratulation, you have successfully finished your deployment. Enjoy!

Regards and stay curious,

Nicole

#build bridges, not silos