Skip to Content
Oct 13, 2016 at 05:47 PM

Convert Bex workbook to analysis for office workbook


I am working on converting our existing BEx 3.5 workbooks to Analysis Office workbooks and then save to BIP platform. My issue is after I change the BW connection to BO OLAP SSO connection and refresh the workbook, the workbook resets to the default view of the query and all cusotmizations are lost.

Our platform

Bex 3.5 workbooks

BI 4.2 SP2

BIP Addon 4.2 SP2

AO for Excel 2.2

As per the ideaplace ( this has been delivered from AO 1.4 SP13 so the Bex workbook filters and format are preserved but I tried several ways and cannot achieve this. I might be missing something obvious and cannot figure it out. I searched all discussions on SCN and tried "replace system" feature. Nothing seem to work.

The discussion ( is exactly what I am facing. But I am using AO 2.2 and it's not working for me.

Please help!