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