The Analysis Office Workbook saves a lot of information in it. The Microsoft Excel format xlsx is a container which can save a lot of other information besides the normal data. When you rename a xlsx file to a zip file you can extract it with for example 7-Zip. Now you see the following folder structure.
When you open the folder xl, you see the custom property. Normally there are several customProperty.bin files listed.
In my case it is customProperty3.bin (just search for the custom property with the highest size). When you open it for example with notepad++ and select the language setting xml it should look like this.
You see information like system ID, server, data source and all information which you can set in the component tab in Analysis Office. And you also see a compressed and encoded area which we will now analyze.
In this encoded area SAP stores a lot of information which you cannot see at the first sight. I developed a little tool in Visual Studio to decrypt this area to a readable text.
Now you see what SAP encoded in this <BICS_VIEW_HEADER> area.
Here we go, we see which dimensions are in this workbook, how sorting for each dimension is adjusted or which valus are stored in the prompt. So we can analyze in detail how the workbook behaves and maybe discover difference between a development and production system.
Is this something anyone needs? Then I would upload the program to github. Here is the link to github.com
These posts might also be interesting:
I am Tobias, I write this blog since 2014, you can find me on twitter, 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 ebook Analysis Office - The Comprehensive Guide for free
You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office?
You want to know how functions in SAP Analysis Office works?
Then you have to take a look into Analysis Office - The Comprehensive Guide. Either as a video course or as a ebook.