2018.

SAP Analysis Office Book is available

Since last week the new version of my book SAP Analysis Office - The Comprehensive Guide is now available. You can find it only here in my shop. The book is based on Analysis Office 2.6 and covers now all about:

  • Customizing Analysis Office including file system settings
  • The basic stuff with Analytics Cloud
  • The advanced stuff like Table Design and Group Members
  • The API and formula functions
  • Troubleshooting and so on

The table of content can be found here. If you have any questions feel free to write them into the comments.

 

One question from me:

Is it ok, that there is only Paypal as payment method or do you need more? Just write it in the comments and I will see what I can do.

Read More 0 Comments

What's new in Analysis Office 2.6 SP2

Analysis Office 2.6 SP2 is available since two weeks. There are only some slight changes to Analysis Office 2.6 SP1. You are now able to set the selection type for the formula SAPSetFilterComponent to MEMBERSELECTORBYRANGE. So you can use it to define the filter dialog with range option as standard.

 

Also a new selection type for the VBA API SAPCallMemberSelector is now available. It is called MULTIPLEBYRANGE, which allows you to select a range of members for filtering. So if you found new functions, feel free to write them down in the comments.

Read More 0 Comments

Analysis Office 2.6 SP2 is available

Since two days the new version of Analysis Office 2.6 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.x: Table Design Formulas causes crash on initialze of Design Rules Tab if no applicable Data was found (s-note 2609841)
  • Analysis Office: Existing workbook in favorites folders on BIP will not be overwritten (s-note 2614892)
  • Analysis Office: Grouping crosstabs from different worksheets throws an exception (s-note 2614536)
  • Analysis Office: System alias of a query defined on BIP server is overwritten (s-note 2616663)
  • Filter Component results in error with Manual Calculation Mode (s-note 2605076)
  • Filter on Characteristics used in Restriction is lost after additional characteristic is used (s-note 2614466)
  • No drop down to select the date for between condition (s-note 2615430)
  • Undo operation for restriction fails (s-note 2606838)

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

Analysis Office Restrictions

Here is a short post about something I just found and never used until now. You can create restrictions in Analysis Office by either using the context menu of a measure or via the ribbon menu entry under Calculations >> Add Restrictions. It will display a new dialog where you can define your restrictions.

Read More 0 Comments

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