october 2020.

Analysis Office 2.8 SP5 is available

Since a couple of days the latest version of Analysis for Office 2.8 is available. Michael was a little faster and notice it on Twitter before me. So let's look into it. SAP fixes a bunch of bugs with this service pack. Here is an overview:


  • AO 4 SAC: \"Group Members\" functionality not available when using BW Live Data Connections (s-note 2962476)
  • AO: BEx Workbook Conversion - An exception occurs when trying to save a converted BEx workbook which contains formulas (s-note 2965890)
  • Action has been cancelled due to invalid input values (s-note 2958731)
  • Analysis for office responds slow in AO 2.8 (s-note 2966651)
  • BIP Logon Issues (s-note 2976169)
  • BIP OLAP Connection targeting another system (s-note 2972912)
  • BIP Workbook fails to save back to the platform (s-note 2963966)
  • Error [3291-74de-1b] when using Excel with Traditional Chinese or ClientLanguage is set to \"ZF\" (s-note 2967800)
  • Exception when the Number of NewLines is set to 0 (s-note 2961082)
  • Exception when using an embedded sheet in Word (s-note 2966861)
  • Filter Dialog - Change state of Tree Node if its text was clicked (s-note 2938903)
  • Input has invalid format error when using exponential / scientific notation in new lines (s-note 2971200)
  • Insecure Connection Message with BIP OLAP (s-note 2967910)
  • New Lines - F4 help does not display member of respective cell (s-note 2963872)
  • Refresh All button is disabled for AO workbook (s-note 2969805)
  • Refresh Workbook with BIP OLAP SSO Connection Fails in Analysis Office (s-note 2957833)
  • SAC Logon Error in Analysis Office - No connection to system INA_SAC (s-note 2964461)
  • SAP Formulas in Scheduled Workbooks are Displayed as #NAME? in Excel (s-note 2765716)
  • Saving a workbook results in a nested exception [e525-fb53-d4] (s-note 2966368)
Read More 0 Comments

BW/4HANA 2.0 Agile Open ODS View Modeling

Open ODS are a long time available in SAP NetWeaver BW. You can access directly database tables, database views or BW/4HANA DataSources (for direct access). In this blog post I want to look into the fast and agile modeling with Open ODS Views. So we start with a flat file we for example received from our customer to build a new data flow for reporting. The file has the following structure:

  • Country
  • Product
  • Business Category
  • Controlling Area
  • Profit Center
  • Month
  • Year
  • Amount
Read More 0 Comments

BW/4HANA 2.0 Composite Provider Modelling

I lately looked deeper into the modeling of Composite Provider in BW/4HANA 2.0 and found some difference between a BW/4HANA 1.0, BWonHANA 7.50 and the latest version BW/4HANA 2.0. So let's compare them and see what's new, and we can go deeper in further posts. We start with the context menu of the scenario for the provider.

Read More 0 Comments