february 2018.

Analysis Office 2.6 SP1 is available since last week. When you look at the What's new guide from SAP, you see nothing spectacular new. You have now a new file system setting called AlwaysDoApplicationSteps. You can use this setting to write entries into the table RSDDSTAT_OLAP afer each action without the need to close Analysis Office.

In my current project I have a file to import, which only delivers me a string with a length of 1000. I also get a description what is in this file. Like the following points:

• Customer from 1 to 10
• City from 11 to 50

The file looks like: 0000123456London............................ So I have a file and a description how to decode this file. Now I need to find a way to separate this information into InfoObjects. I build a Z-Table which contains the decode information.

Since today Analysis Office 2.6 SP1 is available. You need as always a S-User to download the latest version. Here is a short overview what it might fix.

• AO 2.6 Table design rule: Error with Formula VLOOKUP to external excel (s-note 2590137)
• AO: Exceptions occur when loading AO after opening an AO workbook (s-note 2595959)
• Analyis Office: Text and Key are concatenated in new line attributre cells (s-note 2586756)
• Analysis Office: Saving a workbook destroys the layout of the workbook (s-note 2594627)
• Prompts dialog: Hierarchy variable shows wrong value (s-note 2587530)
• Scheduling A.O. Workbook Generates Corrupted Workbooks (s-note 2589444)
• Sheets option are lost when Excel document is opened from server repos (s-note 2593473)
• Table Design formats are not applied (s-note 2594716)

 A overview what's new will be available next week. If you find something interesting, please feel free to post a comment.