SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 3)
Hi All,
S/4HANA is steadily gaining shape in the market and so is the S/4HANA Embedded Analytics.
Part1 of the Blog can be found here –>
Part2 of the Blog can be found here –>
Part4 of the Blog can be found here –>
SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 4)
Part5 of the Blog can be found here –> SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 5)
Part6 of the Blog can be found here –> https://blogs.sap.com/2017/06/30/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-6/
Part7 of the Blog can be found here –> https://blogs.sap.com/2017/11/23/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-7/
Introduction:
What is S/4HANA Embedded Analytics?
It is a set of Analytical Features integrated in SAP S/4HANA, that enables users to perform real time analytics on the live transactional data. It comes with a set of inbuild representations of operational data, called VDM (Virtual Data Models) which will allow users to arrive at better decisions from the available data.
SAP Best Practices for Analytics with S/4HANA: (RDS now be renamed as Best Practices) (Available in SMP since March 7th 2016– http://service.sap.com/analyticswiths4h) (V1.0)
SAP Best Practices for analytics with SAP S/4HANA provides a comprehensive portfolio of analytical content based on SAP S/4HANA. It provides guidance on how to get started with SAP S/4HANA embedded analytics and how to integrate with best in class analytical platform and solutions from SAP for ex: SAP BI platform, SAP BW etc.
3 Options/Scopes:
1) Embedded Analytics with SAP S/4HANA (Mandatory)
2) Integration between SAP S/4HANA and SAP BO (Optional)
3) Integration between SAP S/4HANA and SAP BW (Optional)
My Personal opinion here is with SAP S/4HANA Embedded Analytics, SAP BW (Embedded BW) has got a lot of significance.
Now we will go through the various S/4HANA Embedded Analytics options:
5) Analysis Edition For Excel:
Open an analysis for Microsoft excel:
Access the Analysis Tab and click on the Select Data source option within “Insert Datasources”.
Skip the next screen:
Select the S/4HANA System:
Enter the system credentials:
Select Search for the required Object(Transient Query View)
{
Hope you remember that we had defined the SQL View name of the CDS with the annotation@Analytics.query: true is CFIDAYSSLSOUTSTG. (in Part 1 of this Blog Series)
The Transient Provider naming convention is 2C*.
So Prefix 2C with the SQL view and search with that in Bex Query designer:
(2CCFIDAYSSLSOUTSTG)
}
Select Search for the required Object(Transient Provider View)
{
Hope you remember that we had defined the SQL View name of the CDS with the annotation@Analytics.datacategory : CUBE is IFIDAYSSLSOUTSTG. (in Part 1 of this Blog Series)
The Transient Provider naming convention is 2C*.
So Prefix 2C with the SQL view and search with that in Bex Query designer:
(2CIFIDAYSSLSOUTSTG)
}
This indicates that tools like Analysis Excel is capable enough to understand the CDS generated backend Transient Provider as well as Transient Query.
The system will prompt for the Variables Screen which we have added in the CDS definition using Parameters:
Create the Final report according to your requirement.
A sample report is shown in the below Screenshot.
The above scenario is just an overview of how to bring in the CDS View in Analysis of Excel. Hence the later steps of how to showcase more flavours to the final report is not been explained in this blog.
6) SAP DESIGN STUDIO:
Open Design Studio
The Design studio application will open.
Create anew Analysis application
Provide a Application name and select a layout.
Add a Datasource
Select the S/4HANA System.
Provide the credentials:
Select Search for the required Object(Transient Query View)
{
Hope you remember that we had defined the SQL View name of the CDS with the annotation@Analytics.query: true is CFIDAYSSLSOUTSTG. (in Part 1 of this Blog Series)
The Transient Provider naming convention is 2C*.
So Prefix 2C with the SQL view and search with that in Bex Query designer:
(2CCFIDAYSSLSOUTSTG)
}
Select Search for the required Object(Transient Provider View)
{
Hope you remember that we had defined the SQL View name of the CDS with the annotation@Analytics.datacategory : CUBE is IFIDAYSSLSOUTSTG. (in Part 1 of this Blog Series)
The Transient Provider naming convention is 2C*.
So Prefix 2C with the SQL view and search with that in Bex Query designer:
(2CIFIDAYSSLSOUTSTG)
}
This indicates that tools like Design Studio is capable only to understand the CDS generated backend Transient Query and doesn’t understand Transient Provider.
Check the details:
Drag the data source from Left to the Right Pane and proceed with your requirement.
PS: My Skill in this tool is very bad. Hence don’t want to take a risk here, by designing a complex report.
Once you have completed your requirement, there is an option to “Execute Manually”.
The created application/report will look something like below:
7) Cloud for Analytics(C4A)/ New Name Business Objects Cloud(BOC):
The integration between S/4HANA Cloud and BOC can be done through the following option. Again the approach of 2C* convention remains the same.
Thanks for going through the Document. Do let me know your Reviews and Suggestions.
BR,
Prabhith
Very informative document.
Thanks for documenting.
Regards,
KP..
Hi Prabhith,
A very informative blog. As a suggestion for further blogs in this series, I'd be particularly interested in more details about Design Studio scenarios specifically covering the following cases:
1) How to integrate a Design Studio app deployed on the BusinessObjects BI Platform as a tile on the S/4 HANA Fiori Launchpad;
2) Details about creating and deploying Design Studio apps with the S/4 HANA Embedded BW option.
Thanks,
Mustafa.
Very Informative
Hi Prabhith,
Thanks for a very informative blog. Is there a list of the pre-delivered Webi content for S4/HANA that you can share?
Thanks
Hello @C C,
I have still not got a chance to see that content.
Will update here if I get into the details.
BR
Prabhith
Hello Prabhith, Mustafa,C C,
You can find relevant information in SAP Best Practices for analytics with SAP S/4HANA here: http://service.sap.com/analyticswiths4h--> Download Package.
In the Integration between SAP S/4HANA and SAP BI, a relevant guide has been provided which describes the how to integrate BI platform content in a Fiori Launchpad.
If you click on Download technical content you can get pre-built Design Studio apps, Webi and Crystal report content.
Hope this helps.
Thanks,
Somesh
Thanks very much, Somesh.
Thanks Somesh. That's great information.
Hi Somesh,
To import the LCMBIAR file to a BI Platform (4.2.3), are there any prerequiste steps to complete?
All the objects in Promotion Management fail upon BIAR import.
I see there is also two folders (OVP_SAMPLE, export_kpi_metadata) in the download bundle with the BIAR file. Do these need to be placed somewhere in the filestore of BI Platform first?
Thanks,
Stephen
Hi Stephen,
The OVP_SAMPLE and export_kpi_metadata are not for BIP . They are created for HANA Cloud Platform.
For the Import the LCMBIAR into BI Platform, to ensure all the reports imported, please make sure the software prerequisites installed, like Design Studio BIP Add-on and Lumira BIP add-on.
Hope it answers your question.
regards
Ned
Hi Ned,
Thanks for clarifying - I have everything installed, LS4BIP 1.31.1, DS 1.6.3, BIP 4.2.3 - I've tested other promotion jobs (BIAR-Live, Live-BIAR) and these jobs are all sucessfull. The failures seem to be related to the sample LCMBIAR file.
The errors are stating "failed to decrypt object". The only objects that promote are the Folders.
Thanks,

Stephen
Hi Stephen,
May I ask if you tried with user ' Administrator'? sometime even the the user with administrative role is not enough when importing.
BTW, current delivery was packaging in BIP 4.2 SP2, DS 1.6. SP2 Lumira1.30 .
regards
Ned
Hi Prabhith,
thanks a lot again for this very informative series.
Maybe as a suggestion for further blogs:
- I would not copy as much of the introduction into each part
- A list of topics which you cover in which part would be helpful in the introduction for the first part.
Thanks again,
Hello Joerg Hendricks
Thanks for your suggestion and its indeed a very valid point.
Repeating the same big introduction doesn't really look good.
I have cut short the introduction in Part 2 and 3.
BR
Prabhith
Thanks!
Nice one, Prabhith..
Well Presented..
Hi Prabhith,
thanks a lot for this very helpful blog! I think it broadens the awareness of the solution and helps a lot cleaning up with some misunderstandings around it.
One little comment I have seen in the first of your blogs is that there is a hint about additional licenses for BW on HANA usage which in the vast majority of all situations not applicable for SAP S/4HANA as these installations are licensed using REAB for SAP HANA which includes BW.
I will send you my detailed suggestions and remarks separately.
Thanks a lot again,
best
Juergen
Jürgen Butsmann
Global Business Development SAP S/4HANA
Head Analytical Solutions
Solution Owner