Skip to Content

SAP Financial Consolidation 10.0 Support Package 15 (SP15) is available since October 15, 2014 and delivers major new features, in particular faster data transfer to target applications such as SAP Business Warehouse (BW) through SAP Financial Information Management. SAP Financial Information Management is our web-based solution that allowing business end-users to maintain mappings between source and target applications, launch and monitor data loading processes and trace data in order to determine its origin. SAP Financial Information Management offers SAP Financial Consolidation connectivity to both SAP and non-SAP applications, moving data from a source to a target system. Before SP15, extracting data from SAP Financial Consolidation and loading it to target systems such as SAP Business Warehouse was slow. To speed up the transfer process, both SAP Financial Information Management 10.0 SP11 and SAP Financial Consolidation 10.0 SP15 have been optimized. This improvement was notably requested by our customers using SAP Financial Consolidation in combination with SAP Business Warehouse but also applies for non-SAP target applications.

 

 

Typical extraction process

The diagram below depicts the typical extract-transform-load process from SAP Financial Consolidation to a target application through SAP Financial Information Management. The optimization performed in SP15 focuses on the extraction process highlighted in red.

FC10SP15_FIM_v1.png

Illustration: extraction process from SAP Financial Consolidation to a target application with SAP Financial Information Management

 

 

 

Before SP15

Four components are working when extracting data from Financial Consolidation: the Data Services job server, the SAP Financial Consolidation web service, the CtServer and finally SAP Financial Information Management database server. The architecture diagram below describes how the extraction process works prior to SAP Financial Consolidation 10.0 SP15 and SAP Financial Consolidation 10.0 SP11. In total 6 steps are needed and the most consuming one, from a performance perspective, is to parse data (step #5, highlighted in red).

FC10SP15_FIM2_v2.png

Illustration: extraction process before SAP Financial Consolidation 10.0 SP15 and SAP Financial Information Management 10.0 SP11

 

 

With SP15

Today with SAP Financial Consolidation 10.0 SP15 and SAP Financial Consolidation 10.0 SP11 the process is dramatically simplified:

  • No more iterations between components
  • 4 steps instead of 6
  • Direct and straightforward line to SAP Financial Information Management
  • Less stressed jobs
  • Leaner and faster process

FC10SP15_FIM3_v1.pngIllustration: extraction process with SAP Financial Consolidation 10.0 SP15 and SAP Financial Information Management 10.0 SP11

 

 

SAP Labs benchmarks on data extraction process speed*

Testing results from benchmarks performed at SAP Labs show significant performance gains. Tests were performed on medium size (~100,000 rows) and large size (~650,000 rows) extraction scenarios. Both overall and export times have been measured and compared before SP15 and withSP15. For a medium job, the overall time is 3x faster with SP15 (2 min. 29 sec.) with SP15 compared to 6 min. 45 sec. before) and the export is 10x faster (28 sec. compared to 4 min. 45 sec.). As per the large job, the overall time with SP15 is 12x faster (15 min. 03 sec. compared to 3 h. 01 min. 38 sec.) and the export is 57x faster (2 min. 57 sec. vs. 2 h. 48 min. 57 sec.). Please note that actual performance results may vary depending on system configurations, servers, architectures, networks and storage used.

FC10SP15_FIM4_v2.png

Illustration: SAP Labs benchmarks on data extraction processing speed

 

 

 

More information

     SAP Financial Consolidation 10.0

     SAP Financial Information Management 10.0

 

 

Contacts

 

 

————————————————-

*Please note that actual performance results may vary depending on system configurations, servers, architectures, networks and storage used. The performance survey result provided in this email is for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Trevor Harvey

    Hi, useful article, thanks.

    This references FIM, can you expand on this and its applicability to Cube Deployer and SAP BW. We are working now with these technologies and finding performance a problem.

    Patching has a big price tag, but if the prize is a 10 fold improvement in performance then I can make a case.

    Thanks

    (0) 

Leave a Reply