SAP Analytics Cloud & Live Connections | Taking the First Step

By: Josh Jiang – TruQua Intern; Min Su Kim – TruQua Intern; JS Irick, Principal Consultant

In our previous article, Extending the Digital Core with SAP Analytics Cloud | HANA in the Cloud, we demonstrated how customers’ existing investments in SAP HANA can power the latest visualizations and analytics available in SAP Analytics Cloud.

This hybrid planning methodology between SAP HANA and SAP Analytics Cloud answers two of the most common questions TruQua receives regarding the next generation of SAP Planning, which include:

  1. How do we get started with SAP Analytics Cloud?
  2. How do we align with SAP’s strategic roadmap for Planning if we are not yet ready to fully migrate to the Cloud?

The answer to both questions is leveraging Live Data Connections. As illustrated below, when a user is viewing data in SAP Analytics Cloud, through a live data connection, there are two connections at play. A connection to SAP Analytics Cloud, which supplies the Stories, Models and Visualizations, and a connection to the on-premise SAP HANA database, which supplies the data.

sap analytics cloud live connections

Live Data Connections in SAP Analytics Cloud – © TruQua Enterprises

In our previous article, we introduced a HANA native planning model for the manufacturing of a car engine. Here, we have taken that model and created a live data connection to SAP Analytics Cloud which illustrates the total costs and labor hours by Manufacturing Plant:

Total Costs & Labor Hours in SAP Analytics Cloud

Total Costs & Labor Hours in SAP Analytics Cloud – © TruQua Enterprises

As the Live Data Connection write-back capability is still on the SAP Analytics Cloud roadmap, for the purpose of this example, we have leveraged the HANA XS engine to communicate between our Users and SAP HANA. SAP Analytics Cloud allows for the embedding of SAP HANA XS applications, which lets us add rich functionality such as Bill of Materials visualizations and Demand Planning layouts to our forecasts.

Bill of Materials Visualization in SAP Analytics Cloud

Bill of Materials Visualization in SAP Analytics Cloud – © TruQua Enterprises

TruEngine Sales Volume Control - © TruQua Enterprises

TruEngine Sales Volume Control – © TruQua Enterprises

This seamless integration between SAP HANA and SAP Analytics Cloud provides a wealth of new insights into the planning process, such as the ability to immediately view capacity issues associated with a forecast:

SAP Analytics Cloud Production Labor Hours Data - © TruQua Enterprises

SAP Analytics Cloud Production Labor Hours Data – © TruQua Enterprises

We also have access to the complete suite of collaboration tools through SAP Analytics Cloud, which provide users the ability to have a discussion, post comments and assign tasks, all within the user interface.

Ability to Have Discussions, Post Comments & Assign Tasks in User Interface

Ability to Have Discussions, Post Comments & Assign Tasks in User Interface – © TruQua Enterprises

Live Data Connections provides the ability to use the majority of Analytics and Visualization tools without the need for any replication of data:

Live Data Connections with Analytics and Visualization Tools

Live Data Connections with Analytics and Visualization Tools – © TruQua Enterprises

With its powerful array of connectivity features, SAP Analytics Cloud has eliminated the traditional barriers to entry for new planning software. Customers can achieve enormous value without the need to disrupt their current processes, or perform large data migration processes. Now is the perfect time to start your company’s journey to SAP Analytics Cloud.

TruQua provides workshops, pilots, training and delivery to move SAP Analytics Cloud from your roadmap to reality.  Fill out our form below or contact info@truqua.com for more information.


Extending the Digital Core with SAP Analytics Cloud | HANA in the Cloud

Extending the Digital Core with SAP Analytics Cloud | HANA in the Cloud

sap analytics cloud digital core
By: Josh Jiang – TruQua Intern; Min Su Kim – TruQua Intern; JS Irick, Principal Consultant

From the perspective of Financial Planning and Analysis, SAP HANA has led three major revolutions. First was the Sidecar era, where customers realized performance gains on their existing systems via HANA’s in-memory capabilities. We then experienced the Platform era, where business logic was pushed down into the database. This push down provided an explosive increase in functionality, and decoupled business processes from their existing applications, leading to increased reporting and analytics capabilities. Now, we are firmly in the Digital Core era, where traditional data silos are being obliterated and true Enterprise analytics are possible.

By combining the Digital Core era with SAP Analytics Cloud (SAC), we now have an unprecedented opportunity to provide context and visibility into our customers’ most challenging business problems. The power of HANA can be combined with the robust visual language of SAP Analytics Cloud to provide a unique avenue for Planning.

SAP HANA planning

In this blog post, we will look at how True Engines (TruQua’s Demo Company for Manufacturing) has improved their planning process to better anticipate the impact that demand changes have on Plant Utilization.  At the beginning of each planning cycle, the Operations team defines a maximum capacity for each plant.  When the Demand Planning Team modifies their forecasts for Finished Goods (Engines) and Semi-Finished Goods (Replacement Parts), they are able to see the amount of Labor Hours required by Plant, thanks to their native SAP HANA calculations.

demand planning process

Currently, both the demand planning process and Labor Hours reporting takes place entirely in Excel. The True Engines SAP team wants to move this process to SAP Analytics Cloud to provide better visibility, and an improved user experience.

labor hours data

The HANA Data you see in this demo is queried using a Live Data Connection to SAP Analytics Cloud. Per the SAP Documentation, this means:

Live Data Connections…

  1. Are available for cloud and on premise data sources
  2. Do not replicate your data in SAP Analytics Cloud
  3. Use existing data models for analysis
  4. Update your data visualizations and stories with new data in real-time

The means that the True Engines team is getting SAP’s latest Analytics Cloud functionality, without putting their data in the cloud.

Once the HANA view for Labor Hours by Plant is configured in SAP Analytics Cloud, the True Engines team can leverage the intuitive SAC Story creation tools in order to create robust visualizations showing the Plant Utilization. Now not only can capacity overages be instantly identified, but underutilized Plants can also be quickly identified, and operational interventions can be performed.

sap analytics cloud heat map
By creating unified reporting scenarios with SAP HANA and SAP Analytics Cloud, the True Engines team has advanced their planning from both a bottom-up (real time calculation of true Labor Utilization) and top-down (powerful visualizations, improved dashboarding, management reporting), all without needing to replicate their sensitive business data.

excel to sap analytics cloud
SAP Analytics Cloud offers a wide range of tools to create data visualizations in ways that traditional software, like Excel, cannot. These set of tools allow for new methods to analyze data that can both improve planning capabilities and reporting efficiency, providing solutions to challenging problems. Furthermore, cloud functionality allows users to access data without the need for on-premise data sources, increasing accessibility of data and reporting.


In our next SAP Analytics Cloud blog post, we will complete the True Engines scenario by writing back to the SAP HANA models from Analytics Cloud. This will allow adjustments to be made from the SAC stories, moving from Analytics to Planning.

This scenario is an example of how organizations can begin to leverage SAP Analytics Cloud without disrupting their existing processes, and without the need for loading data to additional systems.

For more information on how you can begin using SAP Analytics Cloud in your own organization, contact us today at info@truqua.com.