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
- 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.
I am Tobias, I write this blog since 2014, you can find me on Twitter, LinkedIn, Facebook and YouTube. I work as a Senior Business Warehouse Consultant. In 2016, I wrote the first edition of Analysis Office - The Comprehensive Guide. If you want, you can leave me a PayPal coffee donation. You can also contact me directly if you want.
- 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
You want to know SAP Analysis for Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis for Office?
You want to know how functions in SAP Analysis for Office works?
Then you have to take a look into Analysis for Office - The Comprehensive Guide. Either as a video course or as an e-book.