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:

• Open Documents from BI Platform with .Net
• How to build a RFC Server with NCo 3.0 Part 2
• Analysis Office – The Comprehensive Guide
• Analysis Office 2.7 SP8 is available