november 2017.

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)

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

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.