Update SAP S/4HANA for Group Reporting


Update SAP S/4HANA for Group Reporting

SAP S/4HANA for Group Reporting  – latest update offers major improvements.

What is SAP S/4HANA for Group Reporting?

Last summer, we already wrote an article about Group Reporting: Group Reporting is SAP’s newest consolidation solution, running on the S/4HANA platform and is available as cloud and ‘on-premise (running on your local server)’ version. Group Reporting is directly working on the financial data in the S/4HANA Finance system and enables live consolidation and reporting, without the need to load the data to another system.

Now, it is time for an update on the developments in the last six months. In this article we discuss the most recent and interesting changes in the last (on-premise) version: 1909.

Release 1909?

For Group Reporting, SAP releases yearly major updates for the on-premise version of the software. Last September, the 1909 version was released, containing major improvements. In the table below, an overview is shown of the improvements of both the 1909 and the preceding 1809 version. It is clearly visible that the developments are significant. In the coming paragraphs, we will discuss some of the most interesting changes:

Advanced IC matching and reconciliation

The intercompany matching and reconciliation has always been, and still is, a time-consuming phase in financial reporting cycles. In Group Reportings 1909 release, considerable improvements have been made in the efficiency for these activities. In the new apps, the following functionality can be found:

  • Real-time matching and reconciliation
  • Automated (IC-) processes
  • Insight in reconciliation using built-in overviews
  • Drill-through up to transaction-level documents
  • Follow-up using automated posting- and matching of documents

Data mapping

In the cloud version of Group Reporting (and later on also the on-premise version), data mappings are available. Using these mappings, non-SAP sources can be mapped to the S/4 Finance tables and data be loaded. Both the data as well as the mapping itself can be loaded into the system, allowing local entities to take responsibility for mapping their local chart-of-accounts (CoA) to the group chart-of-accounts:

  • The source file to be loaded must be a CSV file. The format is industry-standard and is easy to generate for many source-systems.
  • The mapping of the local chart-of-accounts (CoA) to the group chart-of-accounts can be maintained in Excel and loaded into the system.

The import of data from external sources and mapping of dimensions has been standard functionality for many years in most consolidation systems. In Group Reporting, due to the internal S/4 Finance focus, the mapping was still missing. Since version 1909, this functionality-gap was closed by adding the mapping option. This greatly increases the possibilities of using the system for many organizations that have entities on non-SAP source systems.

Matrix consolidation

Traditionally, most organizations consolidate their financial data using a (statutory) group-structure of entities. This consolidation functionality is part of many consolidation-systems. By performing this consolidation, they comply to the statutory reporting requirements. However, more and more organizations would also like to consolidate the same data using additional dimensions, like cost-centres. This requires a matrix consolidation, which is more complex and often not supported by many software solutions. In the latest version, Group Reporting can now perform such a consolidation.


SAP Group Reporting (SAP S/4HANA for Group Reporting) has made a big step in its development. This increases the potential of the tool for many organizations. The data mapping makes it much easier to map financial data from source-systems to a group chart-of-accounts for many organizations.  As always, we will be following all developments and keep you up-to-date. For more information about SAP Group Reporting or other CPM/EPM software solutions: feel free to contact us. We are happy to help.



OneStream XF 5.2 – Analyze without compromise

Analyze without compromise

Today, companies need the finance organization to be more than just the recordkeeping accounting function. They rely more heavily upon the CFO and finance organization as a strategic partner to the business, by providing business insight and predictions to support decision-making and impact the strategic direction. Finance leaders deal with these challenges by becoming more forward-looking and moving more and more towards the adoption of (predictive) analytics, data science and other innovative technologies. These technologies allow them to create meaningful forward-looking insights, combining both operational and financial information to support more informed decision-making.

OneStream’s BI/Analytics Strategy fits this need perfectly, by enabling finance and business users to quickly integrate, analyze, visualize, and draw insights across all aspects of their business within a single, unified platform. Their strategy is to provide easy access to all the data these users need for analysis, directly within OneStream so they can “analyze without compromise.”

OneStream’s latest platform release, OneStream XF 5.2, enables organizations to integrate a broad range of data types, from summarized financial data to detailed operational data in a single platform. New BI Dashboards and Pivot Grids enable self-service data visualization to highlight and analyze key business trends.

In short, the following features were added to OneStream’s Fall release:

  • BI Blend
  • Self-Service Dashboards
  • Pivot Grids
  • Performance on Large data Volumes

BI Blend

With the BI Blend feature, OneStream enables the blending detailed operational data with cube dimensions. It transforms and aggregates all data into a unified reporting format by using the metadata and hierarchies from the cube. The data is stored in separate tables, from which it can be reported using cube views, dashboards and Pivot Grids (discussed later in this blog). The blended data is read-only, meaning that no calculations or business rules can be utilized. However, it is possible to translate the data into a single target currency.

The BI Blend feature applies an in-memory process to collect, transform and aggregate the information. Once that process is finalized, the data is stored in relational column-store tables. During this process, also the parent records are stored in the table, allowing for greater performance.

The BI Blend feature is especially useful when you want to aggregate and report operational information based on hierarchies in OneStream, but do not want to put all that information into your financial model supporting the concept of “leave the data where it belongs”. BI Blend enables a governed process, while keeping your planning models agile.

Self-Service Dashboards

Within this new release, it becomes much easier to create highly visual dashboards. In prior releases, creating a dashboard required setting up many elements and linking them together. In version XF 5.2, the BI Viewer component is introduced allowing you to easily create a dashboard by dragging and dropping different items to view your data. In addition to the basic chart types, you can also use gauges, range filters, grids, maps and many more.

All elements are interactive and by means of drilling down into a certain item, all other items on your dashboard are adjusted as well. By means of using the color schemes in a smart way, you can also view a certain department, product or entity in the same color across all visualizations.

OneStream XF 5.2 enables users to quickly configure interactive dashboards that grant users real-time access to trusted data in OneStream, and other data sources. With this enhanced dashboard building component, OneStream allows customers to reduce the need to export data out to third party BI tools such as Power BI and Tableau to leverage advanced visualizations.

Pivot Grids

Besides the new BI Viewer component, another dashboard component has been released, called the Pivot Grid Dashboard Component. This offers fast ad hoc data exploration of large volumes of data, by creating a pivot table. Data from any source can be used to perform multi-dimensional analysis. Conditional formatting can be used to quickly identify and highlight important information, just by a click of the mouse. Additional key features include the ability to add calculated fields, like text and measures, sort, filters, automatic totals and many more.

Performance on Large Data Volumes

OneStream XF 5.2 includes some enhancements to improve performance in reporting and analysis on larger data sets, such as paging and sparse data suppression. In 2020 and 2021 OneStream will deliver additional capabilities as part of the X-Scale initiative, including scheduled and autonomous scaling of MS Azure cloud resources.

How can your organization benefit?

With the XF 5.2 release, the OneStream platform is extended with self-service dashboards and built-in governed analytics. Instead of moving your data to a BI platform, OneStream has brought the BI capabilities into OneStream. You can bring in all information you need into OneStream and analyze it within a single platform. This way, you retain all the financial intelligence, governance, workflow and the single version of the truth for financial and operational data that you need for reporting, analysis and decision-making.

With these new features, you can:

  • Simplify IT landscape – utilize one platform for CPM, BI, Analytics and Visualization across all parts of the organization. This allows you to eliminate fragmented tools and reduce the total cost of ownership.
  • Integrate financial and operational data – rapid collecting, mapping and loading of large data volumes from external sources.
  • Eliminate latency and replication – no need for moving data into separate BI tools, causing latency and loss of control.
  • Increase speed of value – self-service dashboards allow finance and business users to analyze financial results or operational data super-fast. All can be done using familiar workflows, controls and analysis tools.
  • Complete transparency – the OneStream platform provides complete transparency and audit trails for all data within the platform; financial, planning or operational data.

OneStream Splash Madrid | 17-19 September

OneStream Splash Madrid

As of May 2019, CPMview is a recognized partner of OneStream and we were happy to join the EMEA Splash in Madrid. Many customers, prospects and partners attended the three-day event and it reflected the increasing presence of OneStream in the EMEA market. During the inspiring keynote, Tom Shea (CEO) previewed some of the upcoming enhancements and functionalities, such as Artifical Intelligence, Machine Learning and advanced Business Intelligence, which will help finance professionals to optimize their financial processes and become more efficient. We would like to share those latest developments with you in this blog.

Advanced Business Intelligence

In the upcoming release of OneStream XF 5.2, advanced BI functionalities will become available. During the keynote, Tom Shea showed how easy and intuitive it will be for users to create their own dashboards which are fully interactive. It allows finance professionals to combine tables, charts, graphs and other visualizations and drill down the data, all the way to transactional data if needed, to better understand the business trends.

Machine Learning and Predictive Analytics

OneStream’s strategy is to integrate machine learning in two elements of their platform. Firstly, they want to use it for autonomously scaling the platform by means of the X-scale architecture. In the upcoming release this architecture enables smart load balancing and enhancing the performance of the platform based on all server information that is collected and reviewed. Subsequent releases will allow for automatically scaling server resources up and down, depending upon the needs of the business. For example, during the period end close or during budget season, you can automatically benefit from the full potential of the cloud and scale back resources when you do not need them. This will optimze the performance and the costs.

Secondly, OneStream wants to integrate advanced analytics into key business processes. Their vision is that predictive analytics and/or machine learning can help to create a non-biased scenario in planning, budgeting and forecasting. Currently, a solution is available in the Marketplace XF which facilitates predictive forecasting, but a more complete Machine Learning platform and enhanced solution will become available later this year.

OneStream’s Unified SmartCPM platform

Besides presentations about the latest product innovations, also many clients presented their success stories. From their presentations, it became clear that a great added value comes from the XF Marketplace. Most companies start using OneStream for consolidation and budgeting and forecasting. Once these processes are fully implemented, they start extending the value of the platform by adding additional solutions like account reconciliation, cash planning and people planning. Some of the advantages of the Marketplace that the customers mentioned are:

  • New solutions can be implemented relatively fast and easy;
  • The XF Marketplace keeps evolving and new solutions are added regularly;
  • No need to set-up integrations, since all solutions use the same platform;
  • Only limited training is required, since users are already familiar with the platform;
  • Less costly than purchasing separate CPM solutions.

OneStream commits to delivering 100% customer success. During the Splash event we experienced that first hand, with the inspiring keynote, many product innovations, customer success stories and hands-on workshops. OneStream, thank you for having us and we will see you next year.


Breakfast event OneStream 29 October Utrecht, Restaurant Zuiver 08:00-10:00

The modern, complete and unified platform for Corporate Performance Management

We would like to invite you to our OneStream breakfast event. During a delicious breakfast you will be informed in a short time about the possibilities and advantages of OneStream by means of a live demonstration.  In addition, there is the opportunity to share knowledge and experiences with peers and OneStream specialists.

Breakfast session OneStream

Date: 29 of October, 2019
Time: from 8 am- 10 am
Location: Restaurant Zuiver, Krommewetering 51, 3543 AM Utrecht


Event content

The market for Corporate Performance Management solutions is accelerating its shift from mature on-premise offerings to cloud solutions. Innovative SaaS solutions are becoming more and more the standard and are replacing the established CPM 1.0 offerings. OneStream offers a modern solution for Financial Consolidation, Reporting, Planning, Analytics and Data Quality in a unified platform. OneStream aims to become the CPM market leader for the Office of Finance.

Who should attend?

Curious about the possibilities of OneStream for your organization? Are you responsible for Finance, IT or the administration of your current CPM solution? Sign up, enjoy a delicious breakfast and get to know OneStream’s solutions live.

Costs: There are no costs for participating in this session.


Registration Breakfast session OneStream


Breakfast event SAP Group Reporting 31 October Utrecht, Restaurant Zuiver 08:00-10:00

What is SAP S/4HANA for Group Reporting?

SAP Group Reporting for S/4HANA is a strategic SAP solution for consolidating data directly on the S/4HANA system. The objective of SAP is to combine the best parts of the different consolidation solutions offered by SAP in one consolidation solution integrated in the S/4HANA ERP system.

The principle of “continuous accounting” is applied here in combination with real-time access to financial information. This is achievable because SAP S/4HANA Group Reporting works on the same data as the accounting process, so that no data replication is required. This makes SAP S/4HANA Group Reporting the solution for real-time consolidation.

SAP Group Reporting seamlessly integrates with SAP Analytics Cloud to consolidate and analyse budgets & forecasts.

Breakfast Event Group Reporting

We would like to keep you informed of the most recent developments in the field of Group Reporting. That is why we have planned a session in which, during a delicious breakfast, we will update you on the latest developments.

Event info

Date: October 31, 2019
Time: 8-10 am
Location: Restaurant Zuiver, Krommewetering 51, 3543 AM, Utrecht



Registration breakfast event Group Reporting


Key features & benefits of SAP S/4HANA for Group Reporting

Key features & benefits of SAP S/4HANA for Group Reporting

SAP S/4 HANA for Group Reporting is SAP’s next generation consolidation and group reporting solution. It is available for all deployment scenarios (on-premise, single and multi-tenant) and is designed to incorporate the best features of prior SAP consolidation solutions. For example, SAP BPC (Business Planning & Consolidation), SAP FC (Financial Consolidation), SAP SEM-BCS (Business Consolidation System). Based on latest product releases*, a short summary is given of key features of this new consolidation and group reporting solution.

Key feature 1 – Simple data modelling

Data modelling related to SAP S/4 HANA for Group Reporting is as any other consolidation solution, based on required fields, f.e. dimensions (DIM), consolidation unit (CU) , chart of accounts (CoA) etc. The addition of additional dimensions or reporting items within this new solution is as easy as indicated in the picture to the right (no extra modelling or mapping to add additional dimensions required).

You just mark a check box and additional reporting requirements are added to your data model and become master data. This is all done real-time and without any data replication. So from a master data management perspective a major advantage compared to other CPM vendors. But then again, keep in mind that this major advantage is only available for those companies that have implemented a SAP S/4 HANA for all finance related transactions (ERP).

Key feature 2 – Live data collection

Data collection can be done by selecting the desired upload method; in this case reading from the Universal document.
The Universal document integration allows for local currency of consolidation unit to be populated from any currency field in Universal Journal (i.e. Functional Currency).

Key feature 3 –  Live, Extensible master data

SAP S/4 HANA core accounting master data is real-time available (can be shared (without replication)) and can be extended with master data that is only relevant for consolidation. In other words, consolidation master data can be easily combined with accounting master data. See screenshot below.

Key feature 4 – Easy set-up of validations

When setting-up the validation rules (in the general information tab) you have one, clear view  (see screenshot below) for all necessary parameters. For each validation rule an id is created, a name for the validation rule can be given, a tolerance can be precisely set and a control level (e.g. error, warning or information) can be set. You can also enforce a textual comment for each validation rule and it is also possible to visualize the formula that a validation rule uses for the left and right side.


Key feature 5 – Consolidated reporting

Analysis for Office (AFO) is the reporting solution for the creation of consolidated reports like balance sheets, P&L or Cash Flow Statement. It will be the main facilitator for reporting packs at local and consolidated level.

SAP Analytics Cloud is the reporting solution for visualization of any consolidated or non-consolidated financial information. The use of a live data connection ensures that analysis and process steps can be facilitated by looking at real time data.
When the Digital Boardroom is also used, than management can have interactive discussions using commenting and presentation decks looking at live data at any level and granularity.


Key benefits

Finally we can summarize the following benefits for SAP S/4 HANA for Group Reporting:

  • Fully aligned with SAP S/4HANA key concepts of real time data access and minimizing data replication ( transactional and master data).
  • Eliminates need for periodic extraction and replication of data into traditional stand-alone solutions.
  • Leverages “single source of truth” being the Universal Journal.
  • Fully integrated component of SAP S/4HANA (common user experience, authorizations, reporting tools, shared master data (where applicable) and full transactional data access).
  • Potential to significantly reduce time to close, facilitate continuous accounting and enhance both auditability and reliance on reported results.
  • New innovative capabilities and concepts leveraging the power of in-memory computing.

* Latest product releases: SAP S/4HANA for Group Reporting Release 1809 (on-premise and single tenant); and SAP S/4HANA Cloud for Group Reporting Release 1905 (multi-tenant)


CPMview, DataMotive and Ufinity organized an insightful breakfast session on financial planning with SAP Analytics Cloud

CPMview, DataMotive and Ufinity organized an insightful breakfast session on financial planning with SAP Analytics Cloud.

Tuesday August 6, 2019, Antwerp, Van der Valk hotel.

It was a great success with a very nice breakfast.

Did you miss this breakfast session? There will be a second chance on the 27th of august.

Details will follow!


SAP S/4HANA for Group Reporting

What is SAP S/4HANA for Group Reporting?

SAP Group Reporting is the new consolidation solution for SAP on the S/4HANA platform and is available as a cloud and in ‘on-premise (on own server)’ version. SAP Group Reporting runs directly on the financial data in the S/4HANA Finance system and enables direct consolidation without having to transfer the data. This makes a posting in your administration directly visible in the consolidated figures. If part of your organization is not working in the S4/HANA Finance system, the data can be loaded via the SAP Group Reporting Data Collection module. If you want to visualize and present the figures, or add advanced planning & forecasting, the system connects directly to the SAP Analytics Cloud. SAP positions Group Reporting as their new, strategic solution for all customers who want a future-oriented, complete solution. Much is invested in giving this new solution all the functionality, power and experience of all other SAP consolidation solutions. The goal is to provide your organization with the most powerful solution on the S/4HANA Finance platform.

How does SAP Group Reporting work?

SAP Group Reporting retrieves its data directly from your S/4HANA system, possibly supplemented with external data and manual specifications. After this, the data are validated in accordance with your own requirements. Followed by a currency conversion, possibly manual journals and of course a consolidation to your group structure (or different structures). This consolidation can take place as a matrix, for example by entity, but can also consolidate cost centres over the same data. Of course, this also includes intercompany and equity eliminations.

After that, you report using Embedded Analytics, Analysis for Office, SAP Analytics Cloud, or Disclosure Management. A reporting solution is available for every purpose.


What are the benefits of SAP Group Reporting?

In SAP Group Reporting, SAP has combined much important, useful functionality from their current and previous consolidation solutions. The best features of SAP BPC, BCS, RTC and BPC Optimized are combined on a powerful platform with direct access to the financial and non-financial underlying figures. SAP Group Reporting offers the following advantages:

  • The broad, best-practice functionality provides a process-driven, proven approach;
  • Direct access to the accounting system enables faster closing with direct insight from single posting to consolidated figures;
  • Full integration of operational, local data up to consolidated group data, including drill-down;
  • Very strong integration with a wide range of SAP reporting solutions;
  • Developed as a cloud solution, but can also be installed locally;

How does SAP Group Reporting relate to SAP BPC?

Not so long ago, we presented you with the latest version of SAP BPC: SAP BPC 11 for BW4/HANA. With SAP Group Reporting another new SAP solution for consolidation is available. Which solution would be best suited for your organisation? Although the answer is not always black and white, the following advice can be followed for most organisations:

  • If your organization has a S4/HANA Finance environment, and this is also the most important source for your financial data in that case, SAP Group Reporting, often combined with SAP Analytics Cloud, is a good choice;
  • If you are looking for a local/on-premise solution for consolidation (and/or planning/budgeting) and you have a large number of source systems, SAP BPC 11 is a good choice.

SAP BPC 11.1 for BW4/HANA 2.0 – more power under the hood

More Power under the hood

SAP BPC 11.1 for BW4/HANA 2.0 was recently released. If we look at the SAP BPC frontend, from a purely functional point of view, this new (sub) version of SAP BPC does not offer any major improvements compared to SAP BPC 11.0.  So why is there a new version, if there are no functional changes?  The answer to this question can be found under the hood: BPC 11.1 runs on BW4/HANA 2.0. This platform offers considerable advantages and is even more powerful than its predecessor. In this blog we will discuss some of these improvements.

Before we go into the details, we will provide you a little bit of background information. SAP BPC 11.1 for BW4/HANA 2.0′, what a special product name, what are we talking about?  SAP BPC, stands for Business Planning and Consolidation: this is SAP’s current solution for customers who want to implement both planning and consolidation in their organization with the software on their own server (on-premise). This server can be located either locally or in a (private) cloud, such as Azure or Amazon. The addition ‘for BW4/HANA 2.0’ tells us that this software runs in the SAP BW, Business Warehouse package, with HANA 2.0 indicating that BW runs on SAP’s latest HANA application and database platform.

The latest version of SAP BPC therefore runs on a hyper-modern platform, ready for the future. Many new developments in the coming years will all take place on this new platform, which makes it an essential  prerequisite to be ready for future updates and developments.

SAP itself presents the innovations in the new BW as follows. In the images below we explain a number of innovations:

Web cockpit

The new web cockpit is based on SAP Fiori (the well-known tiles) and gives access to a large number of management tasks. With a powerful search function, the BW objects can be searched and opened. Master data can also be edited via the web cockpit. In addition to master data, HANA views can also be opened.

BW/4HANA Modeling Tools in Eclipse

In addition to the web cockpit, a large part of the development work takes place in the Eclipse modeling tools (HANA Studio). In the previous version, the possibilities were still a bit limited. This has now been repaired. Process Chains and Currency Translation Types, for example, can now also be created and edited here. Another powerful option is the Remodeling option, with which objects in a DSO can be automatically replaced by other objects.

Data Integration

An interesting addition, in terms of data integration and development, is the possibility to write data directly to standard DSO’s (datastore objects).  For example, there are more possibilities to write back data to BW from SAP Analytics Cloud.

Analytic Engine

Since the first version of BW4/HANA, SAP has been moving more and more calculations to the HANA in-memory engine. In this way, more and more parts of BW are becoming faster and faster. In BW4/HANA 2.0 even more calculations are transferred to the HANA database, so that various reporting functions can take place much faster. This applies to the TopN, BottomN, LessThan, GreaterThan, NotBetween functions in a report.

Also, much more chart types can be used in SAP Analytics Cloud with live connections to the BW system, such as the Waterfall Chart, Geospatial, Time Series, Variance Chart, Linked Analysis with more than one dimension, Conditions and the Tuple Filter.


The new version of SAP BPC 11 has no direct functional benefits at this time. However, the underlying platform is fully up to date again and therefore offers sufficient possibilities for new developments. Especially for organizations that use a wider landscape of SAP products and/or also use BW directly. In addition, SAP offers support on BPC 11.1 until 2024, while the 11.0 is only supported until 2021. The transition to 11.1 and the new BW4/HANA is therefore not entirely optional, but an important condition for maintaining SAP support in the long term.


Budgeting & forecasting with SAP Analytics Cloud

Fast decision-making is a major challenge in a time when the amount of information available is constantly on the rise. CPMview implements SAP Analytics Cloud to combine planning, predictive analytics & business intelligence in one cloud solution. Complicated questions can be answered in a few steps. You can combine and visualise data from different sources, create ad-hoc reports and create attractive dashboards.

With the best practices of CPMview you can combine data from different departments and layers within your organisation in clear analyses and indispensable forecasts.