Webinar: Adding SAP Analytics Cloud to On-Premise- When does it make sense and how to maximize its value

Webinar: Adding SAP Analytics Cloud to On-Premise- When does it make sense and how to maximize its value

Tuesday, May 21, 2019
10:00 am PDT/1:00 pm EDT


Join TruQua’s Director of Software Development, JS Irick, for an up-close look at the latest benefits and capabilities of SAP Analytics Cloud for extending on-premise planning, reporting, and analysis processes to the cloud.

During this 60-minute webinar attendees will:

  • Understand the 6 scenarios in which extending your current planning process with SAP Analytics Cloud might be right for you
  • Get actionable advice on how to leverage SAP Analytics Cloud to maximize planning improvements and value to the business (and how to measure its impact!)
  • Walk through a real-world example showing how to avoid common challenges when onboarding a new Business Unit via SAP Analytics Cloud
  • Learn how to boost your predictive capabilities and accuracy through the power of SAP Analytics Cloud’s driver-based planning and what-if analysis


Register Here: https://info.sapdigital.com/2019-05-21-add-sac-on-premise.html

New Perspectives Blog Series: Maximizing Enterprise Collaboration with SAP

Welcome to TruQua’s New Perspectives blog series.  This blog series provides a platform for our consultants to share their perspectives, insights, and experiences on emerging technologies such as SAP HANA and SAP Analytics Cloud (SAC). This week we are going to be speaking with Andrew Xue.  Andrew is a Consultant at TruQua, specializing in cutting-edge cloud analytic and planning technologies.  Today Andrew and I are going to discuss some of the key trends we are seeing at customers as it relates to Collaborative Enterprise Planning and the latest capabilities in SAP Analytics Cloud.

Perspective 1 – Creating organizational alignment with Collaborative Enterprise Planning

JS Irick:  I find Collaborative Enterprise Planning to be a really effective concept since customers intuitively understand what it means and are excited by the possibilities. In addition to SAP’s talk tracks of organizational alignment and breaking down silos, SAP Analytics Cloud allows stronger collaboration within teams, thanks to technologies like shared Private Versions and in-app chat.  Andrew, can you talk a little bit about the collaboration you are seeing on implementations both from a macro (organizational) and micro (team) perspective?

Andrew Xue: The two you mentioned, Private Versions and in-app chat, are just scratching the surface of how collaborative SAP has made SAP Analytics Cloud. With Private Versions, users can not only draft what changes they want to see without impacting real data but also utilize Private Versions to create instantaneous backups of real data as an unofficial checkpoint. With a Private Version, users may share them with other users or teams so that multiple people can collaborate on that information. Definitely beats sending out ten Excel spreadsheets at once!

Picture: An instance of sharing a private Budget version with Read and Write access to other users or teams

I also find in-app chat to be one of the most interesting features of the tool because it is the backbone of connecting users to each other, and then to their data. First, are stories: at a client, we created many stories that were designed as templates, such that users could not change those stories, but could save a copy as a starting point, or use it as inspiration. Once users were more familiar with story-building (graphs, buttons, tables, more), they could create as many as they wanted in their own Private Folders, such as one-off reports for checking on some data, drafting new reports, or testing a feature for potential new value. This is where it gets interesting because users could then share their private stories with their own reports built out to their superiors or teammates. With everyone the story is shared with, read-only or edit permissions can be set as well! Instead of endless back-and-forth emails, people can simply change a chart, and make a note of it in the team group chat! So far, customers have used this tool to both ask me how a certain feature works (and how it helps them), and then proceed to ask me when I would like to grab lunch.

Picture: From the chat menu, sharing is as easy as linking the story for anyone in the conversation to access

JS Irick: You’ve touched on a really interesting point when you mentioned both Private Versions and Private Folders. Let’s be real – Finance organizations are stocked with really smart people; if someone doesn’t have the tools needed to do their jobs, they’ll build it themselves. For a long time, organizations have tried to prevent “Shadow IT” by locking down the ability to save different versions or create untracked reports. Now SAP Analytics Cloud actually encourages good behavior by providing these capabilities in a centralized, organized fashion. It’s a great sign for the future that new features are designed for how customers use the tool.

 Andrew Xue: Of course, the people I have worked with are all extremely smart and very qualified, holding CPAs, MBAs, and more. Once taught how to use SAP Analytics Cloud, they’ve built tools beyond my imagination. Avoiding a “Shadow IT” or simply not having to go through IT for very small changes that don’t impact real data leads to eliminating so many inefficiencies and frees up so much valuable time for people to do more meaningful activities. But this isn’t a tool that gives free rein to all that use it, because SAC also gives IT the ability to enact specific governance via SAC Security in roles & teams, data locking, and more.

People are accountable for their private folders of what items they create, how they organize it, and who they share their creations too. This way, the public folders are saved for all reports, input templates, and more, instead of several drafts cluttering up.


Perspective 2 – Evolving business processes utilizing Native Analytics within Planning

JS Irick: The development path for SAP Analytics Cloud says a lot about the tool’s strength and SAP’s overall analytics strategy.  SAC started as Cloud for Planning (C4P), but the analytic components were so strong that the product became the go-to analytics tool for SAP as a whole. Planning applications have always had a begrudging tie to Microsoft Excel due to its calculation and display capabilities.  Now we’re planning within an Analytics and Visualization tool, which is a monumental shift. How are you seeing customers take advantage of these powerful capabilities, and how are they evolving business processes?

Andrew Xue: The largest shift as you said here is from Excel to SAC. From what I’ve seen in a certain costing process that my current client conducts, the task used to take 4, 12-hour days of everyone’s work. Now with the centralized collaborative tool in SAC we’ve created, the task takes a mere few hours, leaving so much more time for the users to conduct valuable analysis instead of checking if their formulas in Excel dragged down correctly, something that they simply had almost no time to do previously! Also, what the team finds to be so incredibly useful is how quickly they can run different scenarios and what-ifs, such as, how does changing a certain rate assumption affect total costs for a specific sector? Before while using Excel, if they even had time to, it would take a day or more just to edit multiple spreadsheets, confirm, run, and compare the changes. Now, that scenario can be done in about half an hour. In just one day they could be running tens of scenarios!


Along with that, the client team has access to so much more historical data at the tips of their fingers. They can compare past assumptions, run year-over-year analysis on a whim, and so much more. It previously took around 10 minutes just to get all the necessary Excel files open to building a chart, let alone compiling the data. As the team became more familiar with SAC, they also became more creative, making more than just tables and input templates. I have seen them make waterfalls, dynamic pie charts, and even utilized some of the instantaneous Smart Insights on their data! It has been wonderful seeing them realize how powerful this tool’s capabilities are.

JS Irick: The analysis tools and visualizations you’re creating for your customers are truly impressive. In particular, I loved seeing your profitability reports, that are blending the advanced analytic views, what-if analysis, and drill down to the customer/SKU level details. I’m curious though, how are you helping your customers get a handle on this incredibly versatile tool? Even at the most basic level, we’re going from a spreadsheet (which is easy to understand) to a story, which we could think of as multiple dashboards in the previous generation. So, we need to cover dashboard arrangement/design, dozens of new data visualizations, new data features such as Value Driver Trees and Data Actions. This isn’t just moving someone from PowerPivot to Analysis for Office, this is a monumental shift.  Can you share a bit of your training strategy with our readers?

Andrew Xue: By all means in any implementation and move to a new tool, there is going to be a lot to learn. From what I have seen, the most successful strategy is changing the customer’s high-level process as little as possible; no change is preferred. How we help them pick up this new tool is by reviewing their process first at a high level in the new tool, and then at a more detailed level in segments, starting from where the data is, all the way through creating their first reports.

What we have found especially useful is parallel pathing. Earlier when I mentioned a time reduction from several days to a few hours, this was not negatively impacted parallel pathing. In fact, running a process in conjunction only takes a little 3-minute detour every now and then to show them what their work looks like in the new tool now. Then, once they are fully familiar with their responsibilities in the new tool, we help them run another process, only this time we help them with our hands off.

Keys to a Successful Training Strategy with SAP Analytics Cloud

Perspective 3 – Starting a successful SAP Analytics Cloud implementation

JS Irick: TruQua recently presented at SAPInsider Financials 2019 on leveraging the SAC/BPC hybrid scenario.  One of the key points we focused on was the fact that performing a “Lift and Shift” (technical migration of your planning solution without making any modifications) ignores many of the features that make SAC such a dynamic environment. Since you’ve successfully worked with customers from both a Greenfield (first planning implementation) and Brownfield (improving an existing implementation), I would love to get your perspective on how customers can set themselves up for success in SAP Analytics Cloud.

Andrew Xue: I believe SAP Analytics Cloud is the perfect segment for customers seeking to make a change but aren’t too comfortable with a massive alteration. In many scenarios across every industry now, a significant portion (in some cases, all!) of business processes are on Excel. SAC gives users that platform to transition to while still retaining some Excel familiarity, so we’re not throwing them in the deep end at all. We can’t force customers to drop all they know from an old business process just to use a new tool that people tell them is better. And on top of that, to balance their responsibilities while completing weeks of training, it’s illogical. For customers with existing implementations, SAC is quite a different tool that serves to only improve.

In both the Greenfield and Brownfield scenarios, customers on SAC were able to continue their current business processes, while also picking up new features one at a time by simply being in the SAC. This wonderful tool helps the users themselves figure out what was inefficient about their old methods while also giving them new tools to take everything they already do to the next level. Success for the customer here is being willing to welcome this new tool and understand that the first steps are not big at all. Then, by using this tool more in their day-to-day work, customers develop better and faster approaches for gaining more valuable insight into their processes. With more experience in the tool, finding more features to augment their work, and easily adding valuable insights into their reports, customers are enabled to maximize the SAC’s value. The beauty here with SAC is that people who use the tool are able to transition away from traditional methods at whatever pace they feel comfortable.

JS Irick:  So, having been through multiple successful implementations, what are the areas where you are seeing maximum value?  Have there been any surprise wins that may inform the planning roadmap for organizations looking to improve their processes.

Andrew Xue: What I have been mentioning earlier leads up to this: the highest impact and biggest value-adds are shifts from heavily reliant Excel processes. This can be generalized to processes where the data is not centralized, and where changes are tracked through copies named v2, and so on. I agree with that combining different data streams is a surprise success. As I had mentioned earlier, one difficulty many clients face is comparing past data, as the very act of compiling could take hours. As you said, multi-source reports are a nice corollary of the implementation, which is exactly what we have seen. As the client got comfortable transitioning to the new tool and went live, they realized they could pull data from so many more sources, adding to the vast amount of data they already had at their fingertips. Whether this is combining multiple Excel documents, pulling from HANA or other sources, SAC centralizes it all for you to for undiscovered valuable new opportunities with the tool.

I wanted to add to that by saying, trusting the system to run the calculations for you is another surprise success. Users utilize the features in SAC such as Data Actions, Allocations, and more, running those calculations in the tool allow users to fully utilize the cloud resources and functionality. Using these calculation features are where a large portion of the time-saving comes from letting the system work.

JS Irick: Thanks so much for taking the time to speak with me today Andrew. With such an exciting, rapidly developing tool, I really enjoyed taking a step back and looking at the ways customers are generating real business value in SAC.

About our contributors:

JS Irick

JS Irick

Director of Data Science and Artificial Intelligence

JS Irick has the best job in the world; working with a talented team to solve the toughest business challenges.  JS is an internationally recognized speaker on the topics of Machine Learning, SAP Planning, SAP S/4HANA and Software development. As the Director of Data Science and Artificial Intelligence at TruQua, JS has built best practices for SAP implementations in the areas of SAP HANA, SAP S/4HANA reporting, and SAP S/4HANA customization.

Andrew Xue

Andrew Xue

SAP Consultant and Software Developer

Andrew Xue is an SAP Consultant and Software Developer at TruQua who specializes in cutting-edge cloud analytic and services technologies. Most recently, Andrew has been building and implementing cloud applications for financial planning, global budgeting, and executive reporting. He has expertise in an array of SAP enterprise collaborative planning technologies including SAP Analytics Cloud, SAP Business Planning and Consolidation and the SAP Digital Boardroom.

Thank you for reading this installment in our New Perspectives blog series. Stay tuned for our next post where we will be talking to Daniel Settanni on the role of Strategic AI in Finance.

For more information on TruQua’s services and offerings, visit us online at www.truqua.com. To be notified of future blog posts and be included on our email list, please complete the form below.  



Mapping Planned Data from SAP Analytics Cloud to SAP S/4HANA: A Short Tutorial

SAP Analytics Cloud (SAC) combines the flexibility of the cloud with the ability to run new deep-level analytics allowing greater insights into critical business processes. A powerful and agile tool for planning, analytics, and predictive insights, SAP Analytics Cloud enables full-fledged collaboration from anywhere in the world and provides real-time connectivity to on-premise systems such as SAP S/4HANA to removing traditional barriers and accelerating critical business processes.

This blog will walk through a Revenue and Cost Planning example and illustrate how to export and map that planning data from SAC into S/4HANA.


Planning in SAP Analytics Cloud: A Revenue and Cost Planning Example

With the release of SAP Analytics Cloud, enterprise planning has never been easier or more efficient.  With a wide array of planning capabilities and features coupled with the ability to separate hypothetical business scenarios from real data, companies are able to drive better business outcomes with collaborative enterprise planning while also gaining full alignment across all areas of the business.

In this example, you’ll see there are two planning-enabled tables located within a story in SAP Analytics Cloud. The charts on the right focus on gross margin by product and total revenue by product, which will update automatically as entries in the tables are adjusted. These entries can be made at a summarized node level by cost center groups, material hierarchies, or planned at the base level, by SKU or customer.

Source: TruQua Internal Systems


When changing the data, a draft version is created for the end-user to run their what-if planning scenarios on. This means that data changes made by the user will not be implemented until the user confirms and publishes the data. When publishing, users are provided the option to either confirm all their changes made into the model or revert to the original data. SAP Analytics Cloud is also able to highlight any data changes made to keep track of any modifications.


Source: TruQua Internal Systems

Exporting and Mapping Planned Data from SAP Analytics Cloud into SAP S/4HANA

Now that our we’ve run our what-if scenarios and published the data, we want to export that data into SAP S/4HANA. Thanks to the tight integration between SAC and SAP S/4HANA, we can write the new plan data directly to the S/4HANA planning table (ACDOCP).


Source: TruQua Internal Systems


Utilizing the easy-to-use mapping services from the SAP Analytics Cloud model, we can select what fields to map SAP Analytics Cloud dimensions to then assign those dimensions to S/4HANA fields. This is a one-time process to define or update the mappings and can be scheduled per implementation requirements.

Source: TruQua Internal Systems


Another point worth noting, is that within the SAP Analytics Cloud Dimension to S/4HANA field mapping process, users have the ability to create filters on their planned data as well. Meaning they be selective in the data that they upload, such as only uploading a certain period / year, or only a single cost center node. In the Versions and Categories, users may map one Analytics Cloud version to multiple S/4HANA Categories. In this example we see PLN version mapped on SAP Analytics Cloud to PLN, PLN01, and PLN02 in SAP S/4HANA.

Source: TruQua Internal Systems


Once the data has been successfully exported to S/4HANA, a quick ACDOCP query verifies our results.

Source: TruQua Internal Systems


SAP provides a wide variety of out-of-the-box sample content to inspire users on the endless creative possibilities found in SAP Analytics Cloud. With SAC’s connection possibilities (such as S/4HANA, BPC, BW, and more), systems integration previously limited to heavy IT involvement is within reach. For organizations looking to detach from a decentralized planning process, and reach collaborative enterprise planning, SAP Analytics Cloud is a perfect fit.

[This post is based on SAP Analytics Cloud version 2019.5.1 and S/4HANA 1809 SP01.]

Stay tuned for our next blog where we show you how this data can be consumed in Group Reporting and used for consolidation purposes. For more information on SAP Analytics Cloud, S/4HANA, Group Reporting, and how they can take your business intelligence to the next level, please fill out the form below.


SAP Controlling 2018

SAP Controlling 2018

The SAP Controlling 2018 conference is for SAP professionals. Attend detailed sessions on SAP management accounting including the latest functionality such as S/4HANA. Attendees include end-users, managers, Controllers, CFOs and consultants dealing with master data, transactions, configuration and reporting for managers.

Scott Cairncross and David Dixon, Partner Principals and co-founders of TruQua, will present at this year’s SAP Controlling conference in San Diego, CA, happening September 17-20, 2018.

Scott Cairncross will present “Creating a Hybrid Planning Solution with SAP Analytics Cloud and SAP Business Planning and Consolidation 11.0.” Click here to learn more about his speaking session.

David Dixon will present “Tips For More Efficient Planning and Reporting with SAP BPC Optimized for S/4HANA.” Visit this link to learn more about this session.

Learn more about TruQua and the SAP Controlling 2018 conference here.

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.

English EN Português PT Español ES