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