november 2018.

In my current project I have to filter data with a lot of logic. So I build some ABAP routines in a DTP filter to receive the necessary data. First you have to open the DataTransferProcess (DTP) in change mode and select the Filter button on the Extraction tab.

I received an email from Jean-Pierre, who tried the new function Data Source for Defining Formulas of Analysis Office 2.7 - but it didn't work as he mentioned in his email. The option Select Data Soure for Defining Formulas was gray out for BEx Queries.  It worked when he insert the Multiprovider or the Composite Provider. So I was very confused and tried to find a solution.

It is a little late for Analysis Office 2.7 SP2 but SAP just delivered Patch 1 so I can write a short note about it. Finaly SAP give you the option to Create a Web Application in Lumira Designer. But if you installed SAP Design Studio an SAP Lumira Designer, it always opens Design Studio. Analysis Office doesn't care if you first install Lumira or Design Studio. Design Studio always wins. At the moment there is no setting like the DefaultBWQueryDesigner for the old BEx Query Designer or the new Eclipse Query Designer.

Patch 1 also fixes some little bugs.

•  Analysis for Office: Instead of the document description the document name is displayed as title in Excel for documents form the BW platform (s-note 2640073)
• Converting BEx workbook with BExGetCellData formulas shows error message (s-note 2709536)
• Search in Filter Dialog takes long for compound dimension (s-note 2695275)
• Selector Search Performance - Limitation of fetched members from backend (s-note 2711919)

I think it is nothing spectacular but it is maintenance.