{"id":3106,"date":"2016-10-08T09:19:03","date_gmt":"2016-10-08T08:19:03","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=3106"},"modified":"2016-10-08T09:25:21","modified_gmt":"2016-10-08T08:25:21","slug":"migrating-analysis-for-office-workbooks-from-bw-to-bi-platform","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/migrating-analysis-for-office-workbooks-from-bw-to-bi-platform","title":{"rendered":"Migrating Analysis for Office workbooks from BW to BI Platform"},"content":{"rendered":"

We are in process of moving a lot of Analysis for Office (AfO) workbooks from a SAP BW environment to the\u00a0SAP BusinessObjects BI Platform. Besides storing the workbooks on BI Platform, we of course want to use the OLAP connection on the BI Platform to connect to BW, instead of using the direct – locally defined – connection from AfO to BW.<\/p>\n

AfO has a nice feature to quickly swap source systems, but it is a bit hidden. We are using Analysis for Office 2.3 by the way.<\/p>\n

1. Open the workbook you want to migrate. Make sure your workbook is not connected to the BW system. Display the Design Panel<\/strong>, go to the Components<\/strong> tab and select your workbook. Right-click to Log Off<\/strong>.\"afo_switch_1\"<\/a><\/p>\n

2. If you click on a data source you can see the System Alias<\/strong>.\"afo_switch_2\"<\/a><\/p>\n

3. Now right-click\u00a0the workbook again. Select Replace System<\/strong>.\"afo_switch_3\"<\/p>\n

4. By the way, you can also find this option in the AfO Settings<\/strong>, via File | Analysis | Settings | Platform | Replace System.\"afo_switch_4\"<\/a><\/p>\n

5. You now see the Replace System<\/strong> menu, where you can select a new system.\"afo_switch_5\"<\/p>\n

6. Initially this only shows the SAP systems that are defined in your SAP Logon. Click the button in the left bottom corner to login to the BI Platform.
\n\"afo_switch_6\"<\/p>\n

7. Now the OLAP connections from the BI Platform are also selectable. Choose the connection you want to use.\"afo_switch_7\"<\/p>\n

8. A message is given about workbooks that contain planning functions.\"afo_switch_8\"<\/p>\n

9. If you now select the data source again in the\u00a0Components<\/strong> tab you’ll see the new System Alias<\/strong>.\"afo_switch_9\"<\/a><\/p>\n

10. Now you can Refresh<\/strong> the workbook and\/or Save<\/strong> it to the BI Platform.<\/p>\n","protected":false},"excerpt":{"rendered":"

We are in process of moving a lot of Analysis for Office (AfO) workbooks from a SAP BW environment to the\u00a0SAP BusinessObjects BI Platform. Besides storing the workbooks on BI Platform, we of course want to use the OLAP connection on the BI Platform to connect to BW, instead of using the direct – locally […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[304,44],"tags":[306,305,307,132],"class_list":["post-3106","post","type-post","status-publish","format-standard","hentry","category-analysis-for-office","category-knowledge-sharing","tag-afo","tag-analysis-for-office","tag-bi-platform","tag-sap-bw"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-O6","jetpack-related-posts":[{"id":3521,"url":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-2019-roundup-the-good-the-bad-and-the-ugly","url_meta":{"origin":3106,"position":0},"title":"SAP Analytics Cloud 2019 Roundup: the good, the bad and the ugly","author":"Xavier Hacking","date":"December 29, 2019","format":false,"excerpt":"2019 is almost over, so just like last year\u00a0this is a good moment to look back at what happened in the SAP Analytics Cloud universe over the past 12 months. This year we got an astonishing 24 wave releases for the SAC tenants that are on the fast track schedule,\u2026","rel":"","context":"In "SAP Analytics Cloud"","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2144,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-mastering-sap-businessobjects-analysis-edition-for-olap-with-sap-netweaver-bw","url_meta":{"origin":3106,"position":1},"title":"Book review: Mastering SAP BusinessObjects Analysis, edition for OLAP with SAP NetWeaver BW","author":"Xavier Hacking","date":"March 29, 2013","format":false,"excerpt":"SAP BusinessObjects Analysis, edition for OLAP is probably the BI4 tool I have spent the least time in yet. It can be seen as the successor to the BEx Web Analyzer and it is the web counterpart of SAP BusinessObjects Analysis, edition for Office. For my projects this might be\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"hilgefortanalysisolap1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/hilgefortanalysisolap1-300x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3397,"url":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-anno-2018-the-good-the-bad-the-ugly","url_meta":{"origin":3106,"position":2},"title":"SAP Analytics Cloud anno 2018: the good, the bad & the ugly","author":"Xavier Hacking","date":"December 28, 2018","format":false,"excerpt":"Just a few more days and the year is almost over again, which makes this a perfect time to have a look at what happened in the past 12 months in the world of SAP Analytics Cloud. With all the updates the tool got in 2018 (22 waves!), you\u2019d almost\u2026","rel":"","context":"In "SAP Analytics Cloud"","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1851,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-netweaver-bw-and-sap-businessobjects-the-comprehensive-guide","url_meta":{"origin":3106,"position":3},"title":"Book review: SAP NetWeaver BW and SAP BusinessObjects – The Comprehensive Guide","author":"Xavier Hacking","date":"September 15, 2012","format":false,"excerpt":"Let's have a look at another SAP BI book that SAP Press released this year. They are on a great streak and later this year we can expect even more releases from them on HANA, Web Intelligence, ABAP for BW, SAP BusinessObjects Administration and Security. But, let's go back to\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapbwbocomprehensiveguide.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1594,"url":"https:\/\/www.hackingsap.com\/blog\/new-book-integrating-sap-businessobjects-bi-platform-4-x-with-sap-netweaver-ingo-hilgefort","url_meta":{"origin":3106,"position":4},"title":"New Book: Integrating SAP BusinessObjects BI Platform 4.x with SAP NetWeaver","author":"Xavier Hacking","date":"January 1, 2012","format":false,"excerpt":"SAP Press recently released Integrating SAP BusinessObjects BI Platform 4.x with SAP NetWeaver by Ingo Hilgefort. This book is the successor to the 2009 Integrating SAP Business Objects XI 3.1 BI Tools with SAP NetWeaver and is now updated with the latest SAP BusinessObjects 4 (BI4) release. In this book\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Book_integrating_SAP_BI4-225x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2662,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bi4-override-olap-connections-in-promotion-management","url_meta":{"origin":3106,"position":5},"title":"SAP BI4: Override OLAP Connections in Promotion Management","author":"Xavier Hacking","date":"November 13, 2014","format":false,"excerpt":"The Promotion\u00a0Management corner in the\u00a0SAP BusinessObjects BI Platform CMC is still a bit of a strange place for us coming from the SAP BW world. I really like the fact that you\u00a0can use a single promotion job to promote a report again and again after each change. In SAP BW\u2026","rel":"","context":"In "Knowledge sharing"","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"override1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/override1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/override1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/override1.png?resize=525%2C300 1.5x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/comments?post=3106"}],"version-history":[{"count":9,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3106\/revisions"}],"predecessor-version":[{"id":3125,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3106\/revisions\/3125"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=3106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=3106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=3106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}