I am working on a project to convert our existing BEx workbooks to Analysis Office workbooks. We are planning to save our workbooks on the BOE server. We would like to use a BO OLAP connection instead of a local (SAPLOGON.INI) connection. But we're running into issues, and i just wanted to verify I'm not missing anything.
When we convert the workbook, Analysis Office brings the connection in as a local connection (using the saplogon.ini file connection). I figured out how to change this connection to point to the shared OLAP connection we created. However, when we do this, the workbook resets to the default view of the query. So any customization we did (adding/removing of columns, etc) from the default query view - is completely lost. And that kinda defeats the purpose of doing a workbook migration.
Does anyone know if it's possible to switch to use an OLAP connection after migrating a BEx workbook - without losing the customization done in the workbook?
Thanks in advance!