Skip to Content
Author's profile photo prabhith prabhakaran

SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 1)

Hi All,

 

S/4HANA is steadily gaining shape in the market and so is the S/4HANA Embedded Analytics.

 

Part2 of the Blog can be found here –>

http://scn.sap.com/community/s4hana/blog/2016/03/11/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-2

 

Part3 of the Blog can be found here –>

http://scn.sap.com/community/s4hana/blog/2016/03/20/sap-s4hana-embedded-analytics-a-detailed-walkthrough-part-3

 

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.

 

It doesn’t require a separate installation or implementation or any other licenses. It is a part of the S/4HANA Software and is generally available with the new S/4HANA releases.Customers can extend the existing CDS Views VDM’s and build new ones.

 

Please be informed that SAP S/4HANA Embedded Analytics will not replace any existing SAP Solutions and S/4 HANA has an Embedded Analytical engine, but certain steps/activation needs to be done for making this engine to work.

 

Most of the operational reporting can be done with S/4HANA Embedded Analytics.BW would be required for EDW, which will help to analyze the historical data, data consolidation from multiple sources.

 

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)

–> Set up of SAP S/4HANA Embedded Analytics with CDS views and various analytical apps based on CDS views.

 

2) Integration between SAP S/4HANA and SAP BO (Optional)

Enhance analytical use cases by integrating between SAP S/4HANA and SAP BI platform. Pre-built reports and content built in SAP BI client tools ex: Design Studio 1.5 (Ex: –> Core Finance, P2P, O2C), Webi (Ex: Sales revenue, Sales Analysis), Crystal Reports can be leveraged and extended based on business use cases. (Based on BI 4.2 Version, works on 4.1 aswell).

Procurement of a separate License for BO platform would be required, the Best Practices would have only the configuration content.

 

3) Integration between SAP S/4HANA and SAP BW (Optional)

Consolidate data from SAP S/4HANA in SAP BW and build analytical use cases based on enriched data environment from other data sources in SAP BW.(using SDA Concept)

 

 

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:

 

1)  QUERY BROWSER

Launch into a Fiori Launchpad of a S/4 System.

 

/wp-content/uploads/2016/03/3_901237.png

 

You will have a tile called Query Browser, which basically displays the available CDS Views. The CDS view output can be accessed through “Open in Design Studio”.

 

/wp-content/uploads/2016/03/4_901238.png

/wp-content/uploads/2016/03/5_901239.png

 

/wp-content/uploads/2016/03/6_901240.png

In some Cases, you might face some issues while trying to open the Design Studio Flavor of the CDS.,

You will have to activate an object in the Embedded BW System to make this work.

Please follow the below document for the same

–>  Solution for 0ANALYSIS Issue while trying to access ‘Open in Design Studio’ option of S/4HANA CDS Views

/wp-content/uploads/2016/03/7_901241.png

Once your Analytics is completed, you have the flexibility of saving the same as a Tile as well.

 

If you want to explore the CDS code behind, Double click on the View name, to see more details.

/wp-content/uploads/2016/03/8_901242.png

 

Go to the Annotation tab

/wp-content/uploads/2016/03/9_901243.png

 

Take the SQL View name from the Annotations tab.

Go the Backend system in the SAP Logon PAD.

Take SE11 –> Provide the SQL View name in the Views part and click display.

/wp-content/uploads/2016/03/10_901245.png

/wp-content/uploads/2016/03/11_901244.png

 

Double click the Package name to Open the Package Hierarchy

/wp-content/uploads/2016/03/12_904229.png

 

Remember this name and open the Backend System in HANA Studio ABAP Perspective.

/wp-content/uploads/2016/03/13_901247.png

 

Right Click on the system and click “Add a Package”.

/wp-content/uploads/2016/03/14_901248.png

Select the package name that we took earlier and click OK.

We can now find the CDS View definition within the Data Definitions  Folder

/wp-content/uploads/2016/03/15_901249.png

Alternately, You can use the Following Button in ABAP Perspective to directly navigate to the CDS View.

Untitled1.png

 

Untitled2.png

Double Click on the same and the CDS View definition is displayed.

Here you can note that the CDS view C_DAYSSALESOUTSTANDING is a consumption VDM CDS View and it contains a annotation @Analytics.query: true.

Also, this CDS view is built on top of another CDS named as I_DAYSSALESOUTSTANDING

CDS COnsumption.png

If we open the CDS View I_DAYSSALESOUTSTANDING, we can see that its a COMPOSITE VDM CDS view and it contains a annotation @Analytics.datacategory : CUBE.

CDS_Composite.png

Also, please note that an CDS View with Annotation @Analytics.datacategory : CUBE, will create a Transient Provider with the naming convention 2C<SqlViewName>

 

Also, note that an CDS view with Annotation @Analytics.query: true, will create a Transient Query with the naming convention 2C<SqlViewName>

 

The query name you can use everywhere where a query name is required, e.g Transaction RSRT.

 

In case if you want to preview the data, please do the same by right clicking(Context Menu) on the CDS View.

There are many other options in the context menu, which is out of scope of this blog.

/wp-content/uploads/2016/03/preview_1000421.png

 

Sometimes, you might get the below error.

Untitled2.png

The above issue is seen mostly on the older versions of HANA Studio. Upgrade the studio to solve this issue.

 

Since we have defined the view with Parameters, the CDS view will prompt for the  parameters(as shown in the below picture). Provide the necessary values and proceed further.

Untitled3.png

 

The Following screenshot shows the Data preview of a CDS View.

Untitled4.png

 

 

2)  MULTI DIMENSIONAL REPORTS

Multidimensional reports are based on Webdynpro grid application that we have as a template. It renders all sorts of analytical CDS queries. All queries can be rendered in the same way. Functionality is the same for Analytical reports.

 

Example: Incoming Sales Orders

 

/wp-content/uploads/2016/03/17_901252.png

 

/wp-content/uploads/2016/03/18_901256.png

 

/wp-content/uploads/2016/03/19_901257.png

 

 

/wp-content/uploads/2016/03/20_901258.png

 

 

 

Thanks for going through the Document. Do let me know your Reviews and Suggestions.

 

 

BR

Prabhith

Assigned Tags

      41 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Donnie Burhan
      Donnie Burhan

      Hi Prabith,

      I'm waiting for the continuation of this blog.

      Also, could you give the prerequisites (components to install, role & authorizations) to make the embedded analytics work?

      Thank you.

      Best Regards,

      Donnie

      Author's profile photo Dmitry Kuznetsov
      Dmitry Kuznetsov

      Donnie, if you download the BestPractices, you'll get a few guides with component, software prerequisites, roles and even test-scripts to check if things work well. Folow the link http://service.sap.com/analyticswiths4h

      Dmitry

      www.bi-consulting.eu

      Author's profile photo Former Member
      Former Member

       

      Dmitry,

       

      I went to the following link and don't find anything to download. In fact this BestPractice link just gives me some high level description of the content available but nothing else. Am I using it right?

       

      https://rapid.sap.com/bp/#/browse/categories/sap_s%4hana/areas/on-premise/packageversions/BP_S4H_ANA/S4HANA/1611/XX/5/EN/scopeitems/BGH

       

      Thanks,

       

      Akhtar

      Author's profile photo Charles King
      Charles King

      Hi Prabith,


      Thanks for your insights.


      Looking forward for continuation of your blog and also steps to use embedded analytics in S/4 HANA.


      Regards,

      Charles

      Author's profile photo Former Member
      Former Member

      Hi Prabith,

                Could you please confirm if availability of Query Browser would require HANA 1511 or it will also work on HANA 1503 version ?

      Author's profile photo Former Member
      Former Member

      Thanks for this helpful content!

      We are running 1511 and I am looking for any package to implement the Query Browser App. I also expected that this would be included already but this isnt the case. Further, I checked the documentation for RDS S4HANA Embedded analytics and the name of this app wasnt even covered.

      Any Idea or OSS note?

      Author's profile photo Former Member
      Former Member

      Found it!

      Group SAP_CA_BCG_VDM

      catalog SAP_CA_BC_VDM

      Author's profile photo Vishnu Pankajakshan
      Vishnu Pankajakshan

      activate the ui5 app  VIEWBROWSERS1


      add the service VDM_CDSVIEW_BROWSER


      assign user to Role SAP_BR_EMPLOYEE


      Every thing will now work perfectly .. 😛


      Regards,

      Vishnu

      Author's profile photo Ankur Gokhale
      Ankur Gokhale

      Hi Vishnu,

      When I try to add a role SAP_BR_EMPLOYEE from SU01, it says Role SAP_BR_EMPLOYEE does not exists.

      Author's profile photo Vishnu Pankajakshan Panicker
      Vishnu Pankajakshan Panicker

      whats your product version???

      Author's profile photo Ceyhun Alp
      Ceyhun Alp

      Hi Vishnu,

      Yes as Ankur says, BR_EMPLOYEE does not exist.

      Product version is SAP S/4HANA 1610.

      Author's profile photo Ceyhun Alp
      Ceyhun Alp

      Hi again,

      I checked again and it's because of absence of the UIS4HOP1 component. The fiori apps are included in that component. You can ask you basis team to install it.

      Author's profile photo Artem Petrov
      Artem Petrov

      Thanks Vishnu, it works!

      Author's profile photo Arvind Pereira
      Arvind Pereira

      When i manage to find sometime, i should try all these features.

      Looks nice.

      thx

      Arvind Leo Pereira

      Author's profile photo Former Member
      Former Member

      Good One, Prabhith.

      This will be a good starter to S/4HANA Embedded Analytics.

      Thanks..

      Author's profile photo Former Member
      Former Member

      Nice one.

      Thanks for Sharing..

      Author's profile photo Joerg Hendricks
      Joerg Hendricks

      Thanks Prabhith, very useful.

      I will definitely use this to have a closer look at this.

      Author's profile photo Former Member
      Former Member

      These guides take a lot of work. Thanks for producing the illustrated content. Very helpful.

      Author's profile photo Former Member
      Former Member

      Well presented as always. Good document.

      Regards,

      Archana

      Author's profile photo Former Member
      Former Member

      very helpful. Huge thanks~

      Author's profile photo Abani Pattanayak
      Abani Pattanayak

      Good Job Prabhith.

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran
      Blog Post Author

      Abani Pattanayak

      Thanks a lot.

      Currently in the process of preparing the last part of this series --> Smart Business tiles using CDS and APF using CDS...

      Author's profile photo Ted Kwon
      Ted Kwon

      Great thanks for detailed steps !

      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      Muti Dimensinal reports/OAnalysis uses the BICS ( Business Intelligence Consumer Services) connection i.e. internally web service call. I think complete reporting Grid it is build by using UI 5 and XS engine and it is not by web-dynpro please correct me if I'm wrong.

      Thanks,

      Kishore

      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      Could you please tell me... how to activate and connect the embeded bw in Ecc.

      Thanks,
      Nag

      Author's profile photo Former Member
      Former Member

      yes i m glad to see that we can save the tile directly from query browser but my Question is where i can find that tile in Launchpad Designer or how to ?
      In which catalog it'll be added and in which group because i cant found anywhere in launchpad designer.

      Please help..!!!

      Author's profile photo Former Member
      Former Member

      How can CDS view take the SAP Enhancement Framework into consideration?  I’ve always used BAPI so I can include SAP enhancements in my reports or updates to SAP at least at the business object level.  Will there be a way to include checking for SAP enhancements in CDS views implementing CRUD in future?  Not only for the enhancements for report purposes, we were told that we can’t update SAP tables directly due to possibly hundreds of tables update.  Is CDS views only for custom developments for custom tables?

      Author's profile photo Ahmad Tarmizee Kamarul Zaman
      Ahmad Tarmizee Kamarul Zaman

      Hi  Prabhith,

      Does Embedded Analytic features support multiple client scenario ?

       

      Thanks and Best Regards

      Author's profile photo Ceyhun Alp
      Ceyhun Alp

      Hi,

      If you use @ClientDependent: false annotation, yes it does.

      Regards

      Author's profile photo rajanikanth reddy madadi
      rajanikanth reddy madadi

      Good Document , Thanks

      Author's profile photo Pradeep Gupta
      Pradeep Gupta

      SAP S/4HANA Embedded Analytics – A detailed Walkthrough (Part 1)
      https://www.linkedin.com/pulse/sap-s4hana-embedded-analytics-detailed-walkthrough-1

       

      Looks like your post has been copied...

      Author's profile photo Smriti Gupta
      Smriti Gupta

      Hello Prabhith,

       

      Many thanks for this excellent blog.

      Could you pls tell me that in case of s4Hana1610, when we create our own KPI and then configure drill down, do we need the service ca_kpi/drilldown ? It’s missing in sicf, is it not required in s4Hana 1610? Can u pls confirm

       

      Thanks

      Smriti

       

       

      Author's profile photo Smriti Gupta
      Smriti Gupta

      Hello Prabhith,

       

      Thankyou so much for writing this series. It's turning out to be very helpful for me. Can you pls tell if the link Open Design Studio is inactive(not clickable) how should I troubleshoot.

       

      Thanksa lot once again

      Smriti

      Author's profile photo Former Member
      Former Member

      any updates smriti ? i face same problem want to activate design studio on fiori

      Author's profile photo Smriti Gupta
      Smriti Gupta

       

      Hello Said,

       

      yes it works now, the role of the catalog was not assigned to my user. After role assignment it works,.

      Let me know if it still doesn’t works

       

      Regds

      Smriti

      Author's profile photo Smriti Gupta
      Smriti Gupta

      Hello Said,

       

      yes it works now, the role of the catalog was not assigned to my user. After role assignment it works,.

      Let me know if it still doesn't works

       

      Regds

      Smriti

       

      Author's profile photo Consultant Elia Delaware
      Consultant Elia Delaware

      Hi,

       

      Could you tell me how to have the option to "jump to"  another application from a multi dimensional report?

       

      Thanks!

      Author's profile photo Amol Samte
      Amol Samte

      Its very nice blog...

      personally i want to practice all above stuff... Where can i practice?

      Regards,

      Amol

      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      Excellent blog!  I have few queries here. We are using S/4 HANA 1610 FPS 02 and we are planning to use standard analytical applications on Fiori. We do not have any BW/BI system. The queries are as follows.

      1. Is the activation of embedded analytics is mandatory for all the analytical applications? or its required to run few types of analytical applications.
      2. Any HANADB authorization required to activate this?
      3. Does it required user setup in HANADB for end-user to access the analytical apps?

      Best Regards,

      Ram

       

       

       

      Author's profile photo Former Member
      Former Member

      Hi,

      I am trying to create tile in KPI modeller .I have activated the evaluation but still getting the below error

      “ANNOTATION MODEL MISSING FOR EVALUATION.ACTIVATE THE EVALUATION BEFORE CREATION.”

       

      Author's profile photo Former Member
      Former Member

      Hey prabhith, thank you for this amazing blog, I have a question, when I try to do "save as tile" to the analytics that I've created, and go open the tile, it doesn't show me the dashboard I created, like it wasn't saved, is there something that I'm missing!?