october 2020.

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)

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

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.