november 2017.

Analysis Office 2.5 SP2

In the last month I was very busy with my thesis and my project at work, so I had no time to write a lot of blog posts. So here is a short overview what Analysis Office 2.5 SP2 fix. But keep in mind, Analysis Office 2.6 is up coming.

  •  An execption is thrown when grouping crosstabs (s-note 2530837)
  • Formula SAPGetVariable does not return value for BASEINFOOBJT if variables are merged (s-note 2529886)
  • Group Crosstabs / Compact Display does not work properly (s-note 2527113)
  • Native date, date time and time span rendering (s-note 2482546)
  • Not able to change presentation of attribute (s-note 2525435)
  • Refresh in Open dialog does not work (s-note 2536320)
  • Launching a second workbook starts an empty Excel (s-note 2551513)
Read More 0 Comments

What's new in Analysis Office 2.6

Today Alexander Peter showed in the ASUG Webcast Analysis Office 2.6. The expected GA is in three weeks. New in Analysis Office 2.6 are the following things:

  • Table Design Improvements (auto complete enhancements)
  • Improved handling of new lines in planning applications (SAP BW 7.5 SP11)
  • Open Analysis Office workooks using variables (BI Platform 4.2 SP5)
  • Editing schedule jobs (BI Platform 4.2 SP5)
  • Scheduling based on events (BI Platform 4.2 SP5)
  • Publications (BI Platform 4.2 SP5)
  • More features with SAP Analytics Cloud such as exception aggregation
  • Access repository of all (native) cloud models
  • Exception aggregation on the fly
  • Use Dynamic Calculations Rank and Rank Olympic (planned for SP1)
  • Launch Workbooks directly from the BI Platform with variables (BI Platform 4.2 SP5)
  • Rescheduling Jobs on the BI Platform 4.2 SP5
  • Scheduling workbooks with events (e.g. successful/failed data load to BW)
  • Use VLOOKUP with Table Design
  • Filter by Range is now possible
  • New Parameter such as EnableNativeFormatting or UseNewLinesLegacyMode
Read More 0 Comments

SAP BW Use Pattern in Variable with Customer Exit

In my current project I created with a collegue a really cool function to analyze a string with 1333 characters. We are using a BW 7.4 SP 17 on HANA. First we have to build an Advanced DataStoreObject with a Field which has a length of 1333. For further understanding, we call the field Field_1333. As data type I used SSTRING.

Read More 0 Comments