Convert Bex workbook to analysis for office workbook

[prapoorna_kolan]

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 (https://ideas.sap.com/D10143) 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 (http://archive.sap.com/discussions/thread/3387566) is exactly what I am facing. But I am using AO 2.2 and it's not working for me.

Please help!

Sincerely,

Prapoorna

[TammyPowlas]

What happens when you try the "replace system" feature? Could you share screen shots of that?

[TammyPowlas]

OK, logoff button is in 2.3 - see below:

Source: SAP

But, in 2.1 I wrote this and you can create your own logoff button: https://blogs.sap.com/2015/07/12/trying-out-the-sap-logoff-api-analysis-office-21/

Could you try that in the steps of Xavier's blog?

[prapoorna_kolan]

Please see the below screen prints. When I click on "replace system" I see the systems on my SAP GUI laundhpad and also the blue highlighted option.

clicking on the Logon icon takes me to below screen. I enter the BO logon credentials.

Then go to workbook, change the Data Source Name to point to Bex query though BICS SSO OLAP connection.

Thanks!

[prapoorna_kolan]

Tammy,

That did the trick! I was able to save it to BI platform and schedule the converted Analysis workbook. I tried this on simple workbook with one sheet. I am going to try a complex Bex workbook next.

Only thing is I need to add Button on each workbook and it's saving as .xlsm. Will AO 2.3 work with BIP Addon 2.2 if I need to upgrade?

Thanks for all your help,

Prapoorna

[TammyPowlas]

You can use 2.3 without the 2.3 add-on installed on the BIP as long as you are not scheduling

[prapoorna_kolan]

Tammy,

I use Analysis Office 2.2 and I don't see the "Log Off"Option.

Here are the complete steps I perform

1. Open Analysis for Excel
2. Go to Convert BEx workbook
3. Connect to BW system and select the workbook for conversion
4. Save the workbook to the local system
5. Exit from Analysis for office
6. Log back into Analysis For Office. Open the saved xlsx document
7. Go to Design Panel -> Components -> Replace system.
8. Replace system to BI system (OLAP connection)
9. The "System Alias" is now showing OLAP connection instead of BW connection
10. Refresh the workbook. At this point, the workbook resets to the default view of the query.

One thing I noticed is the Planning tab is still using BW connection. However, the workbook doesn't have any planning functions.

Thanks for your help!

[TammyPowlas]

Did you try following steps in Xavier's blog? http://www.hackingsap.com/blog/migrating-analysis-for-office-workbooks-from-bw-to-bi-platform - logging out of BW, and then replacing the system?

[TammyPowlas]

Also, have you seen the steps in Xavier Hacking's blog here: http://www.hackingsap.com/blog/migrating-analysis-for-office-workbooks-from-bw-to-bi-platform

[vinodkumar1]

Hi All, Am trying to schedule a report through SAP and am getting the error"Error during scheduling; Workbook does not contain OLAP connections"