Skip to Content
Author's profile photo abdellah khebbari

Does your CFO need a real time geolocation report?

/wp-content/uploads/2016/03/globe_911327.pngIn a constantly evolving world, CEOs and CFOs must adapt continuously to their new market dimension. Having access to real time reporting gives a serious advantage on its competitors. Thus, CFOs can obtain the necessary information to have a real-time picture of their finance.
Real time reconciliation introduced by SAP Simple Finance solution increases the confidence index of financial reporting. In a more and more competitive world, CFOs can detect earlier business lines profitability decrease and take appropriate decision.
In addition, connectivity and mobility solutions as HCP, HANA Live, Fiori, Lumira etc.. Enable you to reach your reports at any location/device.

This have been said, let’s see how SAP HANA tools are integrated. Here is a simple case of turnover geolocation.
1- Pre-requisite :
In order to show finance posting analysis, we need.

  • SAP Simple Finance system fully configured
  • SAP HANA LIVE Studio with the standard package imported
  • SAP Lumira connected to SAP HANA
  • SAP Lumira map extension activated
  • Esri GEOMAP account
  • Your financial posting

For instance, the following finance posting has been done in the SFIN System.
Company 1 with 14 888 550 euro of turnover
Company 2 with 17 780 000  euro of turnoverecc1.PNG

2- HANA LIVE Data model creation:
Create or extend a standard calculation view (based on ACDOCA table) in order to extract turnover data.
Datamodel1.pngA relevant data selection can be performed.

3- SAP Lumira analytics :

Add a new dataset getting the financial report based on the calculation view below.
/wp-content/uploads/2016/03/dataset_911341.pngYour report is ready, you can display it and breakdown data as needed.
The first screen is a global turnover view “by country”.


Then you can breakdown it to display turnover by country and G/L account.SAP_Lumira_analytics.pngIn conclusion, thanks to those new features, CFOs can benefit from turnover geolocation presentation on any device which is very important in the big data era.
In MRP logistics processes, for example, stock can be displayed by store or by region which can help for appropriate replenishment.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Iver van de Zand
      Iver van de Zand

      Very nice, the workflow is simple and understandable and CFO's will like that

      Author's profile photo Israel Pinto
      Israel Pinto
      Hi Abdellah

      Thanks for share this!