2018.

What's new in Analysis Office 2.6 SP1

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.

 

Read More 0 Comments

SAP BW Decode String during Import

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.

Read More 0 Comments

Analysis Office 2.6 SP1 is available

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.

Read More 0 Comments

SAP BW Create own reversal entry

Lately, all my posts started with "In my current project", so now something else, even if it was developed in the current project. The problem we are facing with is that we get a data extraction which deliver us only the new data records, not the reverse data record.

Read More 0 Comments