It is quite a while since I published my last post. A lot happened since then. Analysis for Office 2.8 SP10 is now available, the summer and the vacation  are over. But in the meantime I developed some new ABAP tools, had quite some interesting exchange and took the SQL Script course by Jörg Brandeis. But in this blog post I want to share with you the latest tool I developed which compare transformations in SAP Business Warehouse systems through the landscape.

Here is a short overview:

The tool allows you to compare and check the following information:

• Global Transformation Information
• Global Routine
• Field, Start, End and Expert routine
• Mapping
• Constants
• Data Transfer Process Information
• Data Transfer Process Filter (Fields and Coding)
• Data Transfer Process Semantic Groups

So you see on the first sight if something is different between your SAP landscape. You can also see on which transports are your transformation was and how the import status is.

This tool allows you to reduce the maintenance in your SAP landscape and display directly the differences. You can either start with a specific transformation or with a source or target, which means the complete data flow will be analyzed. If you have any ideas to extend this program, please let me know.

• In my newsletter, you get informed about new topics
• You learn how to use Analysis Office
• You get tips and tricks about SAP BI topics
• You get the first 3 chapters of my e-book Analysis Office - The Comprehensive Guide for free