Create Your Own SAP Analytics Cloud Story for Marketing Analytics

Learn how easy it is to create Analytics Story for SAP Hybris Marketing Cloud:

Supposed you want to use a Standard CDS Consumption View or you have created your own Custom Consumption View according to Blog

And you have already set up Analytics Cloud for Hybris Marketing Cloud according to Blog

Follow then these steps to create your own BusinessObjects Cloud Story

You might need your own model, if you cannot use one of the delivered standard models provided by SAP:

In order to do so, you need to choose the proper Live Data Connection:

• Open the BusinessObject Cloud and go the perspective “Create Model” own model
• Choose “Use a Data Source” and on the right panel the option “Live Data Connection”

Secondly you have to find the desired data source as follows

• In the opened Pop Up choose the system “SAPMKTNW”
• Search for data sources, for example leading “2CCMKT”, if you want to use standard CDS consumption views
• Choose the desired data source, for example “Campaign Success for Messages, Last Quarter”
• Enter a name and description for the data source
• Save the model

You can then to create your story very easily as follows:

• Switch to the perspective “Create Story”
• Then click on “Add a Canvas Page”
• Click on “Chart” and select as data source the prepared model for your story (If you search with “SAP__CEC_MKT” you will find all marketing models following the naming convention in 1702)
• Specify the desired name and description for the story
• Afterwards an empty story page is opened which contains a first canvas element
• Select the desired measures and dimensions in the designer
• Specify the chart type and filters
• Make the rate labels for the chart and the story page
• Design your story visually by means of the desired fonts and styling

Repeat the last four steps with additional charts for different drill downs by adding other Canvas element if desired

As result you will have a story for “Campaign Success of Messages, Last Quarter” which could look like the Standard Story

Note, if you want to build your story based on a custom analytical query, you need to know the name relating to this custom query.

You can figure out the name (being entered in the second step) as data source as follows.

• Go to View Browser App in Hybris Marketing Cloud and display the details of your custom query.

• In the “Annotation” Section the SQL Viewname is displayed
• The data source name is composed of the prefix “2C” followed by the SQL Viewname,

Example “2C” + “CMKTAGGRSUCCEMLQ” leads to a  Data Source Name: 2CCMKTAGGRSUCCEMLQ