{"id":2662,"date":"2014-11-13T18:18:24","date_gmt":"2014-11-13T17:18:24","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=2662"},"modified":"2014-11-13T15:18:57","modified_gmt":"2014-11-13T14:18:57","slug":"sap-bi4-override-olap-connections-in-promotion-management","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/sap-bi4-override-olap-connections-in-promotion-management","title":{"rendered":"SAP BI4: Override OLAP Connections in Promotion Management"},"content":{"rendered":"

The Promotion\u00a0Management<\/strong> 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 that would require a new transport every time. But, something as the Overrides Settings<\/strong> is still a difficult\u00a0to get through and set up. The official admin guide for the BI4 platform mentions it briefly, but does not explain it good enough.<\/p>\n

Until we had this configured we had to manually reconnect each SAP BW BEx Query in a promoted Webi report. I wrote<\/a> about this annoying situation before.<\/p>\n

With an override setting on an OLAP Connection to a SAP BW system, we can make the connection change (or better: override) its settings\u00a0when promoted, so it connects to the right source system. Say we have two\u00a0SAP BusinessObjects Platforms (BOTest and BOProd) and two SAP BW systems (BWTest and BWProd). We want the OLAP Connection on the BOTest environment to connect with the BWTest system. The connection on the BOProd\u00a0environment should connect to the BWProd system. So if we promote a Webi document that uses this OLAP Connection from BOTest to BOProd, the Webi should load data from BWProd after refreshing it on the BOProd environment.<\/p>\n

Now, how can we set up this override thing?<\/p>\n

1. Log in to the\u00a0CMC of the SAP BusinessObjects BI Platform that acts as the ‘source’ (where you want to promote from).<\/p>\n

2. Make sure you have an OLAP Connection<\/strong> set up on your\u00a0SAP BusinessObjects BI Platform. You can create\u00a0this in\u00a0OLAP Connections<\/strong>.\"override1\"<\/a><\/p>\n

3. Go to Promotion Management<\/strong>.<\/p>\n

4. Go to Settings | Manage Systems<\/strong>. Make sure the right system is tagged as Origin<\/strong>. If not, select the system and click the Origin<\/strong> button to change this. Click Close<\/strong>.<\/p>\n

\"override2\"<\/a><\/p>\n

5. Go to Override Settings<\/strong>. Log off<\/strong> from the current system and login<\/strong> to the Origin system.<\/p>\n

6. Select Scan | Start<\/strong> to scan the system for connection overrides.<\/p>\n

\"override3\"<\/a>
\n7. A list of connections appears. Change the status of the OLAP Connection you want to override into Active<\/strong> and click Save<\/strong>.<\/p>\n

\"override4\"<\/a><\/p>\n

8. Select the connection and click Promote Overrides.<\/strong><\/p>\n

\"override5\"<\/a><\/p>\n

9. Log in to the destination system and click Promote<\/strong>.<\/p>\n

10. Now back in the\u00a0Overrides<\/strong> window\u00a0log off<\/strong> from the origin system and login<\/strong> to the destination system. As you will see the override you just promoted is available here. Make sure\u00a0its status is set to Active<\/strong>.<\/p>\n

\"override6\"<\/a><\/p>\n

11. Select<\/strong> the connection and click the Edit<\/strong> button.<\/p>\n

\"override7\"<\/a><\/p>\n

12. Here you should enter the connection details<\/strong> for the\u00a0production SAP BW system. Click DONE<\/strong> and Save<\/strong> to finish.<\/p>\n

\"override8\"<\/a><\/p>\n

13. Now you can test the setup by creating a promotion job with the OLAP Connection and a Webi report that uses this connection. After promotion the Webi should grab its data from the SAP BW production system.<\/p>\n

By the way after promoting the connection once you don’t have to add it again in other promotion jobs.<\/p>\n

\"override9\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 that would require a new […]<\/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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[44,9],"tags":[],"class_list":["post-2662","post","type-post","status-publish","format-standard","hentry","category-knowledge-sharing","category-sapbusinessobjects"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-GW","jetpack-related-posts":[{"id":2092,"url":"https:\/\/www.hackingsap.com\/blog\/errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence","url_meta":{"origin":2662,"position":0},"title":"Errors after promoting BI4 reports with BEx query data sources","author":"Xavier Hacking","date":"January 28, 2013","format":false,"excerpt":"Transporting (or promoting) objects in the SAP BusinessObjects BI4 environment is still a bit weird for those (like me) originally coming from the SAP BW world. The Lifecycle Manager (LCM) webapp somehow doesn\u2019t feel as robust as the Transport Management System in SAP, but in the end of it course\u2026","rel":"","context":"In "Knowledge sharing"","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"webi_change_datasource_1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/webi_change_datasource_1.jpg?resize=350%2C200","width":350,"height":200},"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":2662,"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":1594,"url":"https:\/\/www.hackingsap.com\/blog\/new-book-integrating-sap-businessobjects-bi-platform-4-x-with-sap-netweaver-ingo-hilgefort","url_meta":{"origin":2662,"position":2},"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":3106,"url":"https:\/\/www.hackingsap.com\/blog\/migrating-analysis-for-office-workbooks-from-bw-to-bi-platform","url_meta":{"origin":2662,"position":3},"title":"Migrating Analysis for Office workbooks from BW to BI Platform","author":"Xavier Hacking","date":"October 8, 2016","format":false,"excerpt":"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\u2026","rel":"","context":"In "Analysis for Office"","block_context":{"text":"Analysis for Office","link":"https:\/\/www.hackingsap.com\/blog\/category\/analysis-for-office"},"img":{"alt_text":"afo_switch_1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/afo_switch_1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1845,"url":"https:\/\/www.hackingsap.com\/blog\/sap-logon-hack-make-logging-on-to-sap-easier-and-faster","url_meta":{"origin":2662,"position":4},"title":"SAP Logon hack: Make logging on to SAP easier and faster","author":"Xavier Hacking","date":"September 8, 2012","format":false,"excerpt":"I have to logon to a lot of SAP systems each day: SAP BW DAP (Development, Accept, Production), SAP ECC DAP, SAP Solution Manager, sometimes SAP PI DAP, SAP BusinessObjects BI4 Launchpad DAP, SAP BusinessObjects BI4 CMC DAP. Pffff. Each system asks for a username and a password that has\u2026","rel":"","context":"In "Knowledge sharing"","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2358,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bi-books-books-books","url_meta":{"origin":2662,"position":5},"title":"SAP BI books, books & books!","author":"Xavier Hacking","date":"November 19, 2013","format":false,"excerpt":"It's a great era for those of us who like to learn about SAP BI topics by themselves, at your own pace and at a moment that is the most suitable. We have the openSAP online courses on HANA and BI4, there is Twitter, the blogs, podcasts and of course\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"3293-ImplementingHANA__47519_std-1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/3293-ImplementingHANA__47519_std-1-86x90.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2662","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=2662"}],"version-history":[{"count":7,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2662\/revisions"}],"predecessor-version":[{"id":2678,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2662\/revisions\/2678"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=2662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=2662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=2662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}