Skip to Content
Author's profile photo Prabhith Prabhakaran

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 –>

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

 

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

 

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”.

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

 

Skip the next screen:

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

Select the S/4HANA System:

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

Enter the system credentials:

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

Select Search for the required Object(Transient Query View)

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

{

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)

Analysis Excel.png

{

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:

 

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

Create the Final report according to your requirement.

A sample report is shown in the below Screenshot.

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

 

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

/wp-content/uploads/2016/03/1_912149.png

The Design studio application will open.

/wp-content/uploads/2016/03/2_912150.png

Create anew Analysis application

3.PNG

Provide a Application name and select a layout.

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

Add a Datasource

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

 

Select the S/4HANA System.

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

Provide the credentials:

7.PNG

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)

}

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

 

 

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)

}

 

Design Stuido.png

 

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:

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

Drag the data source from Left to the Right Pane and proceed with your requirement.

10.PNG

 

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”.

11.PNG

The created application/report will look something like below:

12.PNG

 

 

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

 

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very informative document.

      Thanks for documenting.

      Regards,

      KP..

      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      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.

      Author's profile photo Shubham Srivastava
      Shubham Srivastava

      Very Informative

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Prabhith Prabhakaran
      Prabhith Prabhakaran
      Blog Post Author

      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

      Author's profile photo Somesh Dwivedi
      Somesh Dwivedi

      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

      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Thanks very much, Somesh.

      Author's profile photo Former Member
      Former Member

      Thanks Somesh. That's great information.

      Author's profile photo Stephen Folan
      Stephen Folan

       

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Stephen Folan
      Stephen Folan

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Joerg Hendricks
      Joerg Hendricks

      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,

      Author's profile photo Prabhith Prabhakaran
      Prabhith Prabhakaran
      Blog Post Author

      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

      Author's profile photo Joerg Hendricks
      Joerg Hendricks

      Thanks!

      Author's profile photo Former Member
      Former Member

      Nice one, Prabhith..

      Well Presented..

      Author's profile photo Juergen Butsmann
      Juergen Butsmann

      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