Skip to Content
Author's profile photo Erich Schneider

SAP HANA Live & S/4HANA Embedded Analytics

What is the difference between SAP HANA Live and S/4HANA Embedded Analytics?

Both are standard SAP delivered content for real-time operational Reporting, but use different technology. While SAP HANA Live uses native SAP HANA SQL views, SAP HANA S/4HANA Embedded Analytics is based on ABAP®-managed core data services (CDS) of the ABAP layer of SAP. S/4HANA. CDS views can be maintained in ABAP for Eclipse, while native HANA SQL views are maintained in HANA Studio.

Both, SAP HANA Live and SAP S/4HANA Embeded Analytics can be utilized for the Fiori UX.

In General one could say that SAP HANA Live is content for the SAP Business Suite on HANA, while S/4HANA Embedded Analytics is content for the new simplified data models in S/4HANA. Please see this YouTube Video for background information on the simplified data model.

First content of S/4HANA Embedded Analytics has been shipped with S/4HANA 1511 in the areas of FI, SD, Inventory Management PP and Procurement.

Getting Started with S/4 HANA Embedded Analytics

Journey of Data:From Tables to Tiles – A sneak peek into the S/4 HANA Embedded Analytics Architecture


From the FAQ:

SAP HANA Live offerings will continue to be supported as an important native capability of the SAP HANA platform. New data models of SAP HANA Live for SAP Business Suite were released in April 2015, and the next release is planned for Q1/2016. For the latest SAP HANA Live release notes, please see the SAP Help Portal SAP HANA Live – SAP Help Portal Page Please note that the link in the FAQ document is invalid.

Existing content in SAP HANA Live will remain valid with no changes required – until a customer decides to move to SAP S/4HANA. At that time, it is possible to either modify existing SAP HANA Live models to the new data structures of SAP S/4HANA or migrate to the new technology using CDS.

The SAP Business Warehouse (SAP BW) application powered by SAP HANA is our strategic solution for enterprise data warehousing. There is significant ongoing investment in and development for SAP BW and SAP BW powered by SAP HANA, and new features are introduced with each new release. Check out the latest road map and release information at http://service.sap.com /roadmap .

S4HANA-Analytics.gif

Source: SAPInsider: A Deeper Look into SAP S/4HANA Embedded Analytics

SAP Best Practices for Analytics with SAP S/4HANA on SAP Service Market Place allows download of configuration guides


Technical Setup for S/4 HANA Embedded Analytics

Analytical Report for S/4 HANA: Other Report Types (BGF) pre-configured reports

Analysis Report for S/4 HANA: Core Finance (BHB)

Analysis Report for S/4 HANA: Procure-to-Pay (BHG)

Analysis Report for S/4 HANA: Order-to-Cash (BHJ)

Integration Between BI Platform and Fiori Launchpad (BHC)

Integration Scenarios Between SAP S/4HANA and SAP BW


and technical content

What is SAP HANA Live?

Real-Time operational reporting directly on your Suite on HANA and S/4HANA system without any redundancy or latency. Alternatively, SAP HANA Live can be used in a sidecar scenario next to your existing SAP Business Suite deployment on AnyDB.

SAP HANA Live provides SAP-delivered content (similar in concept like SAP BW content), in form of SAP HANA calculation views for real-time operational reporting. The content is represented as a VDM – virtual data model, which is based on the transactional and master data tables of the SAP Business Suite. The SAP HANA Studio is the SAP HANA application where the calculation views for these VDM are developed and maintained.

SAPInsider presentation:

http://scn.sap.com/community/embedded-analytics/blog/2013/09/02/hana-live-webcast-summary

slides:  http://wcc.on24.com/event/67/02/32/rt/1/documents/slidepdf/sap_hana_live_insider_20130828_final2.pdf

How can SAP HANA Live be used together with SAP NetWeaver BW?

SAP HANA Live is complementary to the SAP Enterprise Data Warehouse application SAP NetWeaver BW, and can be co-deployed with BW and combined in mixed scenarios:Mixed scenarios: BW on HANA and HANA datamart

Go Hybrid – SAP HANA Live & SAP BW Data Integration!

SAP HANA Live – and BW integration

With sFin the embedded BW has gained new importance, Thorsten Franz‘s blog Embedded BW is the new reality explains new and old features.



Release Notes:

SAP HANA Live for SAP Business Suite 1.0 – SAP Help Portal Page

Which tables and fields are used in the SAP HANA Live delivered views?

In the help documentation below details like table names and  filtes used arelisted, for example

SD Delivery

(tried to paste the direct link in here, but either SCN technology or policies do not allow for that, sorry for that will try later again)


Documentation for

Does SAP provide RDS material for SAP HANA Live?

Yes, please see the links to SCN community the RDS http://service.sap.com/rds-shl (RDS-Analytics-HANA Live) and this SAP note , which also includes a SAP HANA Live QuickGuide

SHL RDS.JPG

Two deployment scenarios are possible:

  • SAP HANA Live as a SAP HANA side car to SAP Business Suite applications on traditional RDBMS (Pre-requisite is SAP LT Replication Server), for example together with a SAP NetWeaver BW on HANA system
  • SAP HANA Live on the same system as SAP Business Suite powered by SAP HANA, means the
    • SAP ERP HANA Live views on SAP ERP on powered by SAP HANA,
    • SAP CRM HANA Live views on SAP CRM powered by SAP HANA
    • SAP SCM HANA Live views on SAP SCM powered by SAP HANA

What are the leading practices for SAP HANA implementations?

SAP HANA Studio offers currently three types of views: attribute views, analytical views and calculation views, with calculation views available in two flavors: graphical  models and  or script-based models.

The SAP HANA graphical calculation views are recommended as the preferred SAP HANA Live view type. In case there are some required features are not yet available in graphical calculation views, then script-based calculation views may be used instead.

In General, SAP HANA  attribute and analytical views are not the preferred SAP HANA views for SAP HANA Live implementations.

Can we extend the delivered SAP HANA Live content?

Yes, SAP HANA Live can be adjusted to any Industry, can easily be enriched with non-SAP data and can include customizations.

Of course the Standard SAP best practices for customizations also apply to SAP HANA Live, in order to avoid overwrite during upgrades and patches. During Ramp-up extensions are only possible with support of SAP. Furthermore limitations are described in SAP Notes 1778607 and 1800631.  SAP will deliver extensions to the initial data models from different transactional areas as well as industry applications.

Please see the link for the How-to-Paper, which you an also find attached to this link below:

How to Realize Cross System Reporting Using SAP HANA Live Content

Demo How-To-Extend HANA Live Query Views:

http://www.saphana.com/community/blogs/blog/2013/08/29/create-your-own-query-views-based-on-hana-live

Can we modify the delivered SAP HANA Live data models?

Yes, SAP HANA Live can be adjusted to any Industry, can easily be enriched with non-SAP data and can include customizations.

Of course the Standard SAP best practices for customizations also apply to SAP HANA Live, in order to avoid overwrite during upgrades and patches. During Ramp-up extensions are only possible with support of SAP. Furthermore limitations are described in SAP Notes 1778607 and 1800631.  SAP will deliver extensions to the initial data models from different transactional areas as well as industry applications.

Please see the link for the How-to-Paper, which you an also find attached to this link below:

How to Enhance SAP HANA Live | SCN

Demo How-To-Extend HANA Live Query Views:

http://www.saphana.com/community/blogs/blog/2013/08/29/create-your-own-query-views-based-on-hana-live

views.JPG

  • Query views are designed for direct consumption by an analytical application (for example based on HTML5) or a generic analytical tool (for example SAP BusinessObjects tools). They are always the top view in a hierarchy of views and are not designed for reuse in other views. However, the virtual data model also includes query views in order to support (showcase) applications based on the virtual data model. The name of a query view ends with ‘Query’ and provides output fields in a format consumable by UIs.
  • Value Help views provide value lists for specific business entities that are used by query views. They are used by frontend tools in order to enable a value help for respective input fields for variables or parameters assigned to these business entities.
  • Reuse views are the heart of the virtual data model. They expose the business data in a well-structured, consistent, comprehensible way covering all relevant business data in SAP Business Suite systems. They are designed for reuse by other views and must not be consumed directly by analytic tools.
  • Private views encapsulate certain SQL transformations on one or several database tables or even other views. They are not classified as reuse views as they might not carry clear business semantics but are rather intended to be reused in other views of the virtual data model. They are comparable to subroutines or (private) methods in programming languages. A private view may be based on database tables, other private views or on reuse views.

Can we copy the delivered SAP HANA Live data models?

Can we use SAP HANA Live Content for Cross System Reporting?

Yes, please see for more details:

How to Realize Cross System Reporting Using SAP HANA Live Content

What is the security/authorization model for SAP HANA Live?

Please see this link for an overview on the authorization and security aspects: https://scn.sap.com/docs/DOC-59929

What is the minimum ERP release to utilize SAP HANA Live?

SAP recommends ECC 6.0 EHP7 to use the full content. The current minimum release is ECC 6.0 EHP4. for details please see the release notes in http://help.sap.com/hba

SAP HANA Live is also the foundation for SAP HANA Smart Business Cockpits:

https://scn.sap.com/docs/DOC-59898

How can I see the tables used for SAP HANA Live calculation views?

Please see this YouTube video for an example of a SAP HANA XS demo application which is utilized to get the list physical tables of views.

http://www.youtube.com/watch?v=ah2p5Hdh_kY

SAP HANA Live has a browser to view the models:

How-to-Document: Utilize the View Browser Application Which Accompanies SAP HANA Live:

https://scn.sap.com/docs/DOC-40300

How does SAP HANA Live differentiates from SAP Embedded Reports and Operational Data Providers?

SAP Embedded reports became available with SAP ECC 6.0 and EHP 5 and Operational Data Providers with EHP 6. SAP HANA Live became available with SAP Business Suite powered by SAP HANA and is based on SAP HANA calculation views.

Which User Interface UI / front-end is required for the SAP HANA Live for Reporting?

SAP HANA Live reports can be accessed by HTML 5, native Excel or SAP BusinessObjects Business Analytics applications.

http://help.sap.com/saphelp_hba/helpdata/en/df/65d36d2bec49e189f5452da92669ea/frameset.htm

Which user interface is used to access the back-end modeling?

The application back-end can be accessed using the standard SAP HANA Studio functionality. In order to access the structures and elements of the virtual data model inside SAP HANA Live without installing SAP HANA Studio, the html-based SAP HANA Live View Browser can be used (also for documentation).

Which SAP BusinessObjects analytical solutions are available for SAP HANA Live?

Recommended (but not limited to) for the first version of SAP HANA Live are:

SAP Crystals Reports for Enterprise 4.0.4

SAP BusinessObjects Analysis (Edition for Microsoft Office) 1.0.3

SAP BusinessObjects Explorer

SAP BusinessObjects Dashboards 4.0.4

SAP Lumira – Lumira documents for HANA Live | SCN

Assigned Tags

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

      This is a great document. Thanks!!

       

      Just one question: is there any way to find out more information on the setup of the virtual data views without having access to SAP HANA?  Just to evaluate what those views could do for the business?  Is there any way to run them direct in SAP ECC (via queries)?  Or can they for example be consulted if we get access to the SAP HANA developer cloud system for testing?  Would it be possible to upload the views in the test system?

       

      Dieter

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Thank you for your interest Dieter.

       

      W regards to more information, HANA Live is still in ramp-Up, and the only detailed information currently available is in the SAP help, e.g.: in the link below, and I would expect the SAP Help will be updated with more details once the product is in GA . http://help.sap.com/saphelp_hba/helpdata/en/95/be43656ca943949e5a35c998887d92/frameset.htm
      SAP HANA Live are pre-build HANA Calaculation views, kind of like the BW Business Content concept, and are accessible in the HANA Studio. The reports can be executed directly in ERP or CRM on HANA, or in a side car scenario. The side car scenario can be hosted by a HANA datamart, and also by a BW on HANA system.

      With regards to the SAP HANA cloud developer system, there are considerations under way, but no final decisions yet. One of the ideas is, that the partner and the developer eco-system can build for example custom analytical apps on top of SAP HANA Live views.

      Any announcements will be made on SAPHANA.com.

       

      Thank you

      erich

      Author's profile photo Justin Molenaur
      Justin Molenaur

      Hi Erich, very good information here. From what I can understand, HANA Live is a set of prebuilt content that is installed on HANA whether it is a native application installation (Suite on HANA, CRM on HANA, etc) or a standalone scenario. My question is specific to the standalone/sidecar scenario.

      How does the actual content get distributed into the system, for example in a standalone installation? As in BW content, we actually perform the installation of the content that is delivered (version 'D') with the BW content packages, is there a similar process for HANA Live models or is there another method to physically import the models from SAP?

      Once the HANA Live models are present, I take it that some analysis has to be done to ensure that all the underlying tables required are imported and provisioned from ECC via SLT, is that correct?

      In the above, I can read two points that seem to adress this, but don't directly answer my question. I am only looking at the standalone/sidecar scenario.

      Two deployment scenarios are possible
      •SAP HANA Live as a SAP HANA side car to SAP Business Suite applications on traditional RDBMS (Pre-requisite is SLT SAP System Landscape Replication)

      How can I license SAP HANA Live?
      SAP HANA Live is included in most of the  SAP HANA licenses.  The following versions of HANA include SAP HANA Live
        •      Full use licenses (SAP HANA, Platform edition, Enterprise edition and above)

      Thanks,
      Justin

       

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Justin, thank you for the opportunity to clarify:

       

      The scenario you are referring to is the sidecar scenario, as the presence of a Suite systems (ERP, CRM...) is required. In a standalone scenario you could use HANA without a SAP Business Suite system as a source, for example as a data mart, for SAP HANA applications or for custom HANA application programing. SAP HANA Live would probably not really make sense in these examples.

       

      You can run SAP HANA Live directly on the Suite on HANA system, or in a HANA sidecar environment, and the SAP Business Suite applications on traditional RDBMS. The second scenario requires at a minimum SLT to replicate the meta data (tables) and data (master data, and transaction data). The HANA sidecar can run only SAP HANA Live, or in addition also the SAP HANA data mart scenarios, SAP BW on HANA and SAP HANA accelerators.

       

      Once the original SAP meta data are replicated to the SAP HANA sidecar, the original SAP source tables are represented in columnar format (as they would be in a Suite on HANA system) without the need for additional replication. Means the Suite source tables are stored only once in HANA, in columnar tables.

       

      The SLT system will “know” based on the SAP HANA Live implementation which tables to replicate for the SAP delivered models. If you extend the models, of course you would need to “inform” SLT about additional tables.

       

      The SAP HANA Live content includes queries and  HANA calculation views, which are imported/installed on the HANA system in the SAP HANA Studio/Modeler. Individual users can view the models via the HTML based SAP HANA Live View browser.

       

      With regards to Licensing, sorry , you will need to talk to your SAP Account Executive to get a specific answer to your specific deployment scenario.

       

      Thank you

      erich

       

      Author's profile photo Justin Molenaur
      Justin Molenaur

      Thank you for the very fast reply Erich, appreciate it.

       

      I am indeed referring to the sidecar (to ERP) scenario, which I also see sometimes referred to as standalone. So indeed you answered my question, reiterating some points below to confirm.

       

      - Replicate metadata and import table structures once.

      - SLT has some intelligence to recognize which tables to replicate, is this based on the 'installed' HANA Live scenarios? For example, can a customer only install the Financials content and not install ALL content, therefore SLT only replicated applicable data?

      - The content is in the form of caculation views (re-use views which are then used by queryviews).

       

      So back to my original question - I am looking at the HANA studio now, how would I (once HANA Live is in GA), physically import/install the HANA Live content? Will it be via import XML content function and the models are provided by SAP or will the inherently be present in the installation and somehow just need to be activated?

       

      "The SAP HANA Live content includes queries and  HANA calculation views, which are imported/installed on the HANA system in the SAP HANA Studio/Modeler. "

       

      Thanks!

      Justin

       

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Justin,

       

      you can install (and load) only the content you require.

       

      SAP HANA Live can be downloaded via SAP SolutionManager. Via the help link in the document above (http://help.sap.com/hba) you can access the SAP Service Market Place. In the section Master, Installation, Security, Configuration, and Operations Information you will find the SAP HANA Live Administrator's Guide, with all the details you need to know how to install.

       

      thank you

      erich

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      just fyi, there is now a Suite on HANA sizing script, which also allows the sizing for a selection of individual tables for example, for SHL SAP HANA Live in a sidecar scenario

      http://www.saphana.com/docs/DOC-2933

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hello Erich,

      It was very helpfull for building a solution....Very nicely written article. It has been summarized very nicely.

       

      Thank you

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Do not miss the SAP HANA Live 3-day free trial at 0 cost:

      Please click here to access the free trial on SAP HEC HANA Enterprise Cloud

       

      Enjoy!

      erich

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Update on the link for the free trial:

      The link broke during the migration of the SAPHANA.com platform, and is supposed to be up and running again end of week 12/14.

      http://marketplace.saphana.com/Solution-Domain/SAP-HANA-Live/p/4200

       

      Sorry for the inconvenience.

      erich

      Author's profile photo Chandrashekhar Mahajan
      Chandrashekhar Mahajan

      Hello Erich,

       

      do we still have SAP HANA Live free trial available? above mentioned link is not working.

       

      Regards,

      Chandra

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Chandrashekhar,

       

      the comment is from 2013, and the HANA Live trial has expired since then.

       

      SAP offers the S/4HANA trial, and we will provide an update which scenarios of S/4HANA Embedded Analytics are available as part of that trial.

       

      thank you

      erich

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Hi Erich,

      I read the document and I have a very basic question. How do HANA Live and SAP RDS differ? My understanding is that HANA Live is the content and SAP RDS is the implementation method to install and run the content. Please correct me/help me understand better.

       

      Thanks,

      Benedict

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Benedict,

       

      HANA Live is a solution developed in HANA Studio, SAP provides content in form of pre-built HANA views.

      RDS is a service which is available for additional solutions as well. Some HANA Live rapid deployment services can contain activation of selective HANA Live content.

       

      Please let me know if this helps clarifying the offerings.

       

      Thank you

      Erich

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Perfectly clarifies Erich. Thank you.

      Author's profile photo Manna Das
      Manna Das

      I have tried this Erich. Thanks for sharing.

       

      KR,

      Manna

      Author's profile photo Former Member
      Former Member

      Hi Eric,

       

      Please could you clear my doubts as to what's the difference between: SAP HANA Live, SAP RDS Operational Reporting and Open HANA ?

       

      Thanks Much,

      Abhishek

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

        Abhishek,

       

      The SAP RDS Operational Reporting has been launched in 2011,  SAP HANA Live is general available
      since 2013 with the launch of SAP Business Suite on HANA.

       

      Both solutions provide operational reporting Business content (pre-built SAP HANA data models and SAP BusinessObjects BI solutions) for the SAP Business Suite application ERP.

       

      SAP Services offers also a RDS Rapid Deployment Solutions for SAP HANA Live. 

       

      Whereas the SAP RDS Operational Reporting can only be run in a sidecar scenario, means in a SAP HANA system next to a SAP Business Suite system on traditional RDBMS, SAP HANA Live can run either together with the SAP Business Suite on HANA sharing the same SAP HANA system or in a side car scenario.

      If you run SAP Business Suite on HANA, the side car scenario is in General not applicable.

          

      SAP HANA Live can also be used

       

      With regards to open HANA, I am not familiar with the term. My guess would be you mean SAP HANA without delivered Business content. In this case you would have to build everything from scratch:

      The SAP HANA data models and the BI solutions, reports, dashbords etc..

       

      Thank you

        erich

       

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Hi Erich,

      I find that all the views that are delivered as part of HANA Live are calculation views. Is there any justificatoins for this. I thought using Attr views and Analytic views where needed would be a more efficient than doing all models as calculation views.

      Thanks,

      Benedict

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Benedict,

       

      I have not seen official word yet, IMHO potentially seems there will be simplification/standardization on calc views going forward.

      thanks

      erich

      Author's profile photo Former Member
      Former Member

      Dear Erich,

       

      If I use HANA as a side-by-side or as ERP on HANA scenario and I intend to use the new reporting possibilities then I should use SAP HANA live, so far so good.

      However, SAP HANA live delivers "only" the views I can work with, right? To do any reporting or analytics, I need a frontend or a tool, which can work with those view data, isn't?

      Frontends/tools I could use could be SAP Business Objects BI suite, Crystal reports, Analysis office or the BEx Explorer. Are there any other new frontends or tools to do some reporting which are delivered by HANA live or do I have to use those I mentioned above?

       

      Sincerely Yours

      Zapp

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Zapp,

       

      HANA Live is foremost content for Suite reporting, almost like BW content , which also can be extended.  HANA Lives comes with the MS Excel frontend, connects to all SAP BI Suite applications, and has open interfaces, and serves also as a foundation for some Fiori applications and Getting Senior Executives Involved in Business Process Management

      Thanks

      erich

      Author's profile photo Former Member
      Former Member

      Erich,

      Many thanks.

       

       

      Sincerely Yours

      Zapp

      Author's profile photo Former Member
      Former Member

      Hi Eric,

       

      I am implementing HANA Live and BOBJ for a customer and they have two controlling areas in Business suite on HANA  The rule is that only one controlling area can be exposed in the reports and the other controlling area cannot show up in any views. When looking at the 250+ views for reporting, only a few have controlling area as an available field.

       

      Do we have to add controlling area to all (most of) the views manually and pass a hardcoded filter on each, or do you have a better idea?

       

      Dr. Berg

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Bjarne,

       

      can you please provide some examples? The CO queries we checked had all the Controlling Area included.

       

      thank you

      erich

      Author's profile photo Vamsi Krishna
      Vamsi Krishna

      Berg,

       

      My proposal would be to add an analytic privilege to filter required controlling area in generic role like MODELING or some end user targeted role rather than filtering every view even though filed is available in all views, that way we are allowing everybody to see only required data..!  If there is any other alternative approach you came up with please share.

       

      Vamsi

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Added link to Lumira examples for HANA Live calculation views

      Author's profile photo AJAY SHIRKE
      AJAY SHIRKE

      Hi Erich

       

      I need to report on fields that are not available in a query view, but only a private view. Can I convert the private view to a query view, or is there another way I can bring in more fields into the query view from the base tables?

       

       

      thanks

       

      Aj

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Ajay,

       

      that question is answered in the FAQ above.

       

      Under the question Can we extend the delivered SAP HANA Live content?, there is a link How to Enhance SAP HANA Live | SCN to a how-to-paper which answer's the question how to enhance the SAP HANA Live content delivered by SAP with "Private Views" which are the base views that directly use the SAP source tables.

       

      thank you

      erich

      Author's profile photo Former Member
      Former Member

      Hi Eric,

       

      I have very fundamental question on HANA LIVE, in architecture we see an area for Physical Tables, what there are for?

       

      will you explain, what's the role of these Physical Tables, in use case for HANA LIVE, SLT & ECC sceanrio?

       

      Regards

      Sekhar

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Chandra,

       

      not sure I can follow you.

       

      Please have a look into SAP help for HANA Live in the text above, the Admin Guide might help you to get started.

       

      thank you

      erich

      Author's profile photo Shantanu Sharma
      Shantanu Sharma

      Chandra

       

      The physical tables are, as the name suggests, physical tables that are used to store the data that is then queried via the HANA Live views. The manner in which these tables are populated depends upon the HANA Live deployment architecture. If the Business Suite application (ERP, CRM, etc.) is already on HANA, then these tables are the same tables that are used by the Business Suite application. If the Business Suite application is still on a traditional database, and HANA has been deployed as a secondary database (or sidecar), then the physical tables in HANA, that are part of HANA Live, are populated via real time replication from corresponding tables in the Business Suite application using SLT. For example, suppose a HANA Live view uses the sales order header (VBAK) and sales order line item (VBAP) tables. Then in the sidecar scenario, the physical table layer will contain 2 tables called VBAK and VBAP with the same definition as the corresponding tables in SAP ERP and SLT will be used to populate in real time VBAP and VBAK in HANA Live from VBAK and VBAP in SAP ERP. On the other hand, if SAP ERP itself uses HANA as its primary database, then HANA Live will use VBAK and VBAP from the ERP table scheme in HANA and no replication is necessary.

       

      Hope this helps. Please check the online help for HANA Live for more details.

       

      Shantanu.

      Author's profile photo Former Member
      Former Member

      Hi Shantanu,

       

      Thanks for the clarification, this help me to understand that, if you are not running Business suite on HANA database, you will tend to have duplicate (redundant) table structures on both BuzSuite product as well on HANA db.

       

      Regards
      Sekhar

      Author's profile photo Anup Singh
      Anup Singh

      Hi ,

       

      Can we install delivery unit "HCO_HBA_CRM" in " Starter edition of SAP HANA Cloud platform" ?

       

      Delivery unit is for virtual data models for “SAP HANA Live for SAP CRM”

       

      Is there any additional cost apart from Starter HANA edition monthly cost ?

       

      Thanks & Regards,

      Anup Singh

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Anup,

       

      the official answer is: "Please talk to your SAP Account executive".

       

      My personal understanding is, that if you own a HANA license like S/4HANA, BWoH etc., you can run HANA Live. And you can run HANA Live in HCP.

       

      thank you

      erich

      Author's profile photo Ignacio Lopez
      Ignacio Lopez

      Hi Erich,

      I've not been able to find a reference on how the HANA Live Views are deployed into a QA and PROD environments, it sounds that you will have to import the SAP delivered DU in QA and subsequent environments, have you done that? What about the schema and tables needed for the HANA Live Views, would you have to manually create those following the 'SAP HANA Live for SAP Administrator's Guide' in QA and PROD? Any comment on the topic above will be greatly useful and appreciated.

       

      Thanks

      Ignacio L

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Ingnacio,

       

      originally it was an export/import for HANA models, and now SAP is offering transport support for HANA.

       

      Following the BW logic (and general SAP logic), you would perform a meta data replication from the source system first, otherwise you could get inconsistencies.

      In this case using SAP LT to replicate the tables from the source to target per instance.

       

      thanks

      erich

      Author's profile photo Mohamed Judi
      Mohamed Judi

      Hi Ignacio,

       

      HANA Live content is not different from any other content you would develop in HANA. The same options to promote developed objects are also available to HANA Live objects. Please refer to the following SAP Help Portal page for more information: Transport Scenarios for SAP HANA Content - Software Logistics - SAP Library

      Best regards,

      MJ

      Author's profile photo Former Member
      Former Member

      Excellent source for HANA Live material.

       

      The url for Demo How-To-Extend HANA Live Query Views appears to have changed. Below is the working url

       

      https://blogs.saphana.com/2013/08/29/create-your-own-query-views-based-on-hana-live/

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Thank you Rehan,

       

      yes, unfortunately we still have some issues with re-directing the links to new websites.

       

      thanks for your help!

      erich

      Author's profile photo Vivek Singh
      Vivek Singh

      Wow, one of the best blog with updated and neatly complied information.

      Author's profile photo Sudha Rao
      Sudha Rao

      Hi Erich,

       

      Is SAP planning to come up with new HANA Live views for the integrated system for S4HANA considering co-deployment of the applications is the key?

      Answer to this would be very helpful. Thanks !

       

      Regards,

      Sudha

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Sudha,

       

      HANA Live does run in S/4HANA, is that your question?

       

      thanks

      erich

      Author's profile photo Sudha Rao
      Sudha Rao

      Hi Erich,

       

      Thanks for the quick response.

      I am pretty sure HANA Live and existing benefits will still continue to run as earlier or even better in S4HANA.

      Considering ERP, CRM, SCM and other suite applications are going to co-exist in the same database ( which is the biggest key of s4hana) i wanted to understand, whether SAP is coming up with new HANA Live queries which integrates the tables from different modules ( say ERP and CRM integration)

      Hope this is clear.

       

      Thanks,

      Sudha

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Sudha,

       

      for specific future solutions I have to refer to the official roadmap information, link is in here: Business Suite and S/4HANA Roadmap and Release Information

       

      In General yes, and especially this is the idea of the smart business cockpit solutions.

       

      Sorry, but I can not provide any material guidance outside the official links.

      erich

      Author's profile photo Former Member
      Former Member

      Hi Experts,

       

      I'm looking for Hana live fo S4Hana, could you please tel me where download it?

       

      Thanks.

       

      Regards.

      Author's profile photo Mohamed Judi
      Mohamed Judi

      Hi Shahab,

       

      Have a look at the SAP Best Practices for Analytics with S/4HANA (http://service.sap.com/analyticswiths4h)

       

      Also, you can download the packages under SAP Best Practices section of Downloads in the Service Marketplace: https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=N&FUNCTIONBAR=Y&EVENT=TREE&TMPL=INTRO_SWDC_IU_BP&V=INST&REFERER=CATALOG-INSTALLATIONS&ROUTENAME=products/By%20Category%20-%20SAP%20Best%20Practices

       

      Thanks,

      MJ

      Author's profile photo Vivek Singh
      Vivek Singh

      Hey Shahab,

       

      I am not 100percent sure, but if you need hana live on S4hana, you need to have Enterprise license also, as HANA live is not part of S4hana.

      Author's profile photo Ajina Thomas
      Ajina Thomas

      Hi Erich,

       

      With S/4 on HANA as a new product where in the key is to co-deploy applications like ERP, CRM, SCM , could you please explain how BW fits into the picture?

      It has been suggested that S/4 HANA would support operational reporting, so how would this be done - probably through HANA Live (Hana Studio)? Will a customer with ERP and BW on traditional RDMS looking forward to an upgrade need to have a S/4 on HANA as well as BW on HANA(BwoH) with BwoH exisiting as a separate application on a different HANA database?

       

      Thanks,

      Ajina

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Ajina,

       

      in general I personally believe that there will still be a need for Data Warehouse capabilities

      in an Enterprise Architecture and more information is in this link:

      Enterprise Architecture and HANA

       

      With regards to the the role of BW in the context of S/4HANA please see the information in this link:EDW

       

      With regards to co-deployment scenarios please review this material: S/4HANA On Premise System Architecture options

       

      Consideration w regards to standalone BW versus co-deployment using database containers, my recommendation would be to look at size and SLA's. For example if you run a BW with 100TB and a S/4HANA with 2 TB, and yur BW SLA is 92% and your S/4HANA SLA is 99.9%, what is your Business/IT justification to run both applications on a single SAP HANA DB?

       

      thank you

      erich

      Author's profile photo Former Member
      Former Member

      Hi Enrich,

       

      The content you provided was too good and very useful. Thanks for your great contribution.

       

      Regards

      Subbaraju

      Author's profile photo Former Member
      Former Member

      Hi Enrich!!

      Excelent document.

      Thanks for posting it!!!

      Regards,

      Author's profile photo GERARD BINGCO
      GERARD BINGCO

      Nice!

      Author's profile photo Former Member
      Former Member

      Excelent document but where can I find more about the link to GRC reporting and dashboarding?

       

      regards,

      pedro

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Thanks Pedro,

       

      in addition to the SAP marketing websites yo will find information on SCN::

       

      GRC: Governance, Risk and Compliance (SAP GRC)

       

      Dashboarding: Business Intelligence

       

      thank you

      erich

      Author's profile photo Former Member
      Former Member

      Hi Erich,

       

      thanks for the reply.

      I am looking for the SAP HANA integration with SAP AC...

       

      regards,

      pedro

      Author's profile photo Former Member
      Former Member

      Hi Erich,

       

      Many thanks for you Information about this Topic. We start now with our project implementation of SAP S/4HANA, on premise edition 1511 in our Landscape. I think it is the best if we start with the solution " S/4HANA Embedded Analytics" and not "SAP HANA Live". My impression is that this will be the best solution / technology for us instead of "SAP HANA Live" if we use S/4HANA, on premise edition 1511.

       

      Is that right?

       

      Many thanks and best regards

       

      Marcus

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Marcus,

       

      there are 2 different aspects:

      1. Technology

      2. Standard delivered content

       

      1. Technology

      • HANA Live is built on native HANA SQL views
      • S/4HANA Embedded Analytics is built on ABAP CDS views.

      Both are valid technologies with their unique advantages and will be supported going forward. One of the main differences is that CDS views can use existing Suite authorizations, while the native HANA views need their own set of profiles.

       

      2. Standard delivered content

      • HANA Live VDM's were originally developed on the Suite on HANA data model, and there are some updates to the S/4HANA data model. Please see the release notes for details.
      • S/4HANA Embedded Analytics is being built on the new S/4HANA data model

       

      To answer your question: "It depends".

      My personal recommendation for anything Finance, where you need detailed security and cost center and profit center hierarchies, use CDS views.

       

      For any agile reporting for example in sales and marketing, where your BI resources have extensive SQL skills and no ABAP background, the native HANA SQL views are a good option. Otherwise you risk that the non-ABAP resources start downloading data from your S/4 system into proliferated data marts where they can use their SQL skills.

       

      My 2 cents

      erich

      Author's profile photo Former Member
      Former Member

      Hi Erich,

       

      Many thansk for your informations.

       

      Best regards

       

      Marcus

      Author's profile photo Former Member
      Former Member

      Hi Erich,

       

      I understand that SAP will be coming up with S/4 HANA Embedded Analytics updates/releases on an quarterly basis. How about HANA Live roadmap ? Do SAP has releases planned for HANA live too or is it going in maintenance mode?

       

      It will be helpful if you can provide link for SAP planned release road map for HANA Live as well as S/4 HANA Embedded Analytics.

       

      Also you have mention that when migrating to S/4 HANA, existing HANA Live models needs to be modified  to the new data structure ? In that case is there a tool that SAP provides for such migration or too much of effort and modification will be required to continue using existing HANA live models?

       

      Regards,

      Jeet.

      Author's profile photo Former Member
      Former Member

      Hi Erich,

       

      Thanks for the valuable information. This is certainly a rapidly evolving set of technologies. Could you provide some direction please...

       

      We are architecting an analytics solution for a client on the latest version of S/4HANA + Ariba + SuccessFactors + SalesForce.

       

      At this point our simple architecture is to bring all data into S/4HANA and conform there. Persist there and store history there for up to 3 years - then Archive using HANA VORA.

       

      Would you say that this solution would work with HANA Live Views on all but S/4HANA data, CDS views for that and the BOBJ Platform running across all (and HANA Vora)?

       

      I can't find any technical reasons that this solution would not work, it just feels over simplified?

       

      Thank you,

      Paul

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Yes, Paul, that is a possibility.

       

      Other options, depending on your current and planned infrastructure (like running Hadoop in the cloud or on premise and your S/4 Governance and its impact on BI self service) are BW on HANA, HANA side car, or agile data mart in HCP HANA Cloud Platform.

       

      HCP is a low Capex high agile solution, where you can persist data from either source or use virtual consumption, depending on latency and data transformation requirements.

      With HCP you could source data from S/4 using CDS views and native HANA views depending on the source, and standardize on HANA native views in HCP for use in BOBJ on premise or BOBJ CE aka C4A cloud for Analytics.

       

      thank you

      erich

      Author's profile photo Former Member
      Former Member

      Thanks Eric!

       

      We are now very much thinking to use BW7.5 on HANA next to our S/4HANA for the following main reasons:

       

      • Data from non-SAP systems harmonized with data from S/4HANA
      • We require data transformation and cleansing to bring data in from non-SAP
      • We work with time dependant master data
      • We require historical snapshotting of data
      • We require analytics that will be on long term trend analysis (over 10 years)
      • We will require multiple & complex hierarchies


      The data in BW will be over 20% of the size of S/4HANA (otherwise we'd have used BW embedded).


      Anyone have additional comments /considerations?


      Thanks!

      Paul

      Author's profile photo Former Member
      Former Member

      HI Erich,

       

      Great document.. Can we have some info on the CRM Partner Channel Management HANA Live Views that are available.. Please let me know your comments

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Sorry Supriyo,

       

      the only official information I am aware off is in the SAP help and release notes.

       

      thank you

      erich

      Author's profile photo Andrea Bosoni
      Andrea Bosoni

      Hi Erich, suppose I have implemented HANA Live on Business Suite on HANA. In case I then move to S/4 HANA Finance or S/4 HANA EM, should I expect an impact on my Hana Live components? I know for S/4 HANA Finance there's an additional package available....but how is my existing Live for Suite on HANA baseline likely to be impacted? I'm considering for now standard HANA Live content. Thanks!

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Andrea,

       

      As soon as the underlying data model changes, either adjustments need to be made or new packages will be provided.


      The default solution for S/4HANA is S/4HANA embedded analytics content based on CDS views, therefore the focus for S/4HANA "BI content" is in the embedded analytics area.


      thank you

      erich

      Author's profile photo Andrea Bosoni
      Andrea Bosoni

      Thank you Erich for your prompt response!

       

      Just two more clarifications.

      1) What about the technical system conversion to S/4 (be it either Finance or EM)? Is the technical procedure, starting from Business Suite on HANA, likely to be impacted/disturbed in any way due to the presence of HANA Live artifacts on the system?

      2) In case we build our virtual data model on the Business Suite on HANA (NW 7.4) leveraging CDS, would this affect the subsequent technical conversion to S/4 besides - in this case also - some adjustments required on the artifacts due to changes in the data model?

       

      Thanks again,

      Andrea

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      In general,

       

      if the the data model changes, then data will be physically deleted and/or moved from a set of old tables to a new table.

      Compatibility views have and will mitigate the issues, but, of course , in order to take full advantage of the simplified data model you might want to make adjustments to your reporting sources either in CDS (S/4 embedded analytics content) or native HANA SQL views (HANA Live content).

       

      Which of course leads potentially to the requirement to combine data originated in the old data model (maybe even 10 years or older)  and in the new data model going forward. In that case you might still want to use BW or any other data warehouse to manage your complete data history.

       

      thank you

      erich

      Author's profile photo Former Member
      Former Member

      Hello Together, What about the roles and authorizations for the S/4HANA Embedded Analytics solution? Which roles can we use in our 1511 System -> Transaktion pfcg? Thanks and best regards

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Marcus,

       

      CDS views allow you to utilize standard SAP ABAP application-based security, which is very sophisticated and enabled database agnostic settings.

       

      Native HANA views require HANA-specific security.

       

      thank you

      erich

      Author's profile photo Isaac Oyinlade
      Isaac Oyinlade

      Hi Erich -

      Good info as always. However, did one of your blogs got discontinued?  S/4HANA Finance aka Simple Finance aka sFIN? Received alert that it is currently unavailable due to SCN content that was not migrated to the new SAP Community experience.

      My main question today are:
      1) For the single source of truth, Universal Journal, only one BI Extractor is needed if BW is still in place. What is the name of the BW Extractor?
      2) What version of BW do you have to be on in order to install this Extractor (i.e the relevant BI Content)?

      I appreciate your response.

      regards,
      Isaac

      Author's profile photo Erich Schneider
      Erich Schneider
      Blog Post Author

      Isaac,

      yes we decided not to migrate the blogs - long story.... going fw please refer to Sven Denneckens blogs.

      An update on BW datasource w regards to sFin is in note 2270133.

      In general all new simplified tables can be sourced via CDS views.

      Thank you
      erich

      Author's profile photo Former Member
      Former Member

      Hi Erich

      This is an excellent document. Is there any place where i can see a list of all HANA live views and the information each view provides. We are using ECC on HANA. I am specifically looking for any Accounts Payable HANA live view. Unfortunately i do not see any HANA live views for AP. Only thing i can see closest is “AccountingDocumentGLView” which unfortunately goes to BKPF, BSEG, FLAGELFLEX etc (and not BISK or BSAK). I am not sure whether it is designed by choice, to keep with the strategy of only using 4 Fin tables in S4HANA , or whether i could not find the right views to create my Accounts Payable reports. Really appreciate if you can point it to the right palce

      Kind Regards

      Sanjit

      Author's profile photo Kris Stono
      Kris Stono

      Hi Sanjit,

       

      You should be able to get all your AP info using the following:

      GL Account Line Item Entry View (GLAccountLineItemEntryViewQuery)
      GL Account Line Item GL View(GLAccountLineItemGLViewQuery)
      Query view of profit center receivable payable(ProfitCenterReceivablePayableQuery)
      Compact Document Journal (AccountingDocumentJournalQuery)
      Profit center master data index (ProfitCenterMasterDataIndexQuery)
      GL account list in chart of accounts (GLAccountListInChartOfAccountsQuery)

      These are straight from the SHAL Documentation. ?

      You do not need BSIK/BSAK as all the relevant data is held in BKPF/BSEG, you just need to apply logic in your selections i.e. set the cleared flag or where flag is empty, account types, posting keys, doc types…it is all there. Going forward, BSIK/BSAK…and others…become compatibility views and no longer store data.

      Also have a look at the GRIR App for HANA live as that also provides very relevant Purchase to Pay information.

      If you want to stay within the SAPGUI environment then try the FBL1H/FBL3H/FBL5H transactions/line item browsers as these should provide you with most of your needs in AP/AR/GL.

      Cheers

      Kris

       

       

      Author's profile photo Isaac Oyinlade
      Isaac Oyinlade

      Hello Erich,

      We just implemented S4 16.05 (SP4), which is still on our Q system for testing before deployment to production in matter of days.

      However, we noticed that some Z-tables, which are heavily in use are not compatible (or visible again) once the installation was done on our Q.

      How do we avoid or say ensure these tables works in production? I was under the impression that existing Z-tables works well with S4? We cannot afford to loose these tables, please what is your advise?

       

      regards,

      Isaac

       

       

      Author's profile photo Khan Aslam
      Khan Aslam

      Hi Erich,

      Thank you very much for such an informative document.

      You mentioned at the time of moving to S/4 HANA “At that time, it is possible to either modify existing SAP HANA Live models to the new data structures of SAP S/4HANA or migrate to the new technology using CDS.”

      My question: Is there a migration tool for HANA Live Views -> CDS Views in place now or coming in future? I will appreciate your response. thanks!

      -Aslam Khan

      Author's profile photo Former Member
      Former Member

      Can anyone advise if Hana Enterprise Cloud comes with Hana Live by default?