{"id":2092,"date":"2013-01-28T16:15:10","date_gmt":"2013-01-28T14:15:10","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=2092"},"modified":"2014-12-17T22:17:36","modified_gmt":"2014-12-17T21:17:36","slug":"errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence","title":{"rendered":"Errors after promoting BI4 reports with BEx query data sources"},"content":{"rendered":"

Transporting (or promoting) objects in the\u00a0SAP 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\u00a0doesn\u2019t feel as robust as the Transport Management System in SAP, but in the end it does the same thing of course.<\/p>\n

This week a colleague ran into some errors after promoting his new Web Intelligence<\/strong> and\u00a0Crystal Reports<\/strong>\u00a0from our BI4 development environment to the production environment. His reports were created on SAP BW BEx query<\/strong> data sources.<\/p>\n

Update: We finally figured out how to work with Override Settings for OLAP Connections to solve this issue. Check the blog\u00a0post\u00a0here<\/a>.<\/strong><\/em><\/p>\n

First let’s have a look at the Web Intelligence<\/strong> report. After the promotion he was able to open the Web Intelligence report, but when refreshing the data the following errors appeared:<\/p>\n

\n

Errors when trying to refresh the current report.<\/p>\n

The universe generation using the resource id has failed. (WIS 00000)<\/p>\n<\/blockquote>\n

\"webi_change_datasource_1\"<\/p>\n

\"webi_change_datasource_2\"<\/p>\n

The solution to this issue is quite easy but you just have to know this somehow I guess: You have to manually reconnect each SAP BW BEx query with the Web Intelligence report<\/strong>.<\/p>\n

Yes, this just feels odd. We are used to the Transport Management System to take care of these things. Also I think it’s a bit strange to standard having to edit reports in a production environment, just to make them work. On the other hand, if you only have one BI4 environment on top of multiple SAP BW environments, it might be useful to have the ability to change the data sources of a report to connect to a different system.<\/p>\n

Anyway, to fix this just follow the next easy steps:<\/p>\n

1. Open the report and go to Design mode<\/strong>. Go to the Data Access<\/strong> tab and select the Tools<\/strong> submenu. Here you see the option Change Source<\/strong>. By the way make sure that you are running the Rich Internet Application (JAVA) version since the Web version\u00a0doesn\u2019t show this option! You can check and change this in the BI Launchpad preferences for Web Intelligence menu (top right).<\/p>\n

\"webi_change_datasource_3\"<\/p>\n

2. After selecting your query a wizard will appear in\u00a0which you can specify a new data source.<\/p>\n

\"webi_change_datasource_4\"<\/p>\n

3. Browse to your BEx query.<\/p>\n

\"webi_change_datasource_5\"<\/p>\n

4. The next screen shows a proposed object mapping. This should normally show only green lines because the BEx queries\u00a0should have the same configuration on the several SAP BW environments.<\/p>\n

\"webi_change_datasource_6\"<\/p>\n

5. After clicking Finish<\/strong> the report will refresh. Don’t forget to save the report or you’ll have to do this again the next time you want to run the report!<\/p>\n

\"webi_change_datasource_7\"<\/p>\n

 <\/p>\n

When opening the Crystal Reports<\/strong> report in BI Launchpad after promotion something similar happens:<\/p>\n

\n

The viewer could not process an event. The data source is invalid.<\/p>\n

Invalid CMS Query. Check if the connection exists in the CMS.<\/p>\n<\/blockquote>\n

\"crsytal_reports_data_source_1\"<\/p>\n

The solution here luckily is not as hidden as in the Web Intelligence case.\u00a0Follow the steps below.<\/p>\n

1. Open Crystal Reports for Enterprise<\/strong>, connect to BI4 environment and open the report. On opening a pop-up will be shown telling you that the data source used in this report can no longer be found on the server. Click the link.<\/p>\n

\"crsytal_reports_data_source_2\"<\/p>\n

2. In the wizard screen you’ll see the ‘old’ data source on the left. On the right you have to select a new target data source. First select a connection and browse to your BEx query.<\/p>\n

\"crsytal_reports_data_source_3\"<\/p>\n

3. After selection the wizard will try to map all fields. You can manually map fields with the Map<\/strong> button.<\/p>\n

\"crsytal_reports_data_source_4\"<\/p>\n

4. Again, don’t forget to save your report.<\/p>\n

Thanks,<\/p>\n

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

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 does the same thing.<\/p>\n

This week a colleague ran into some errors after promoting his new Web Intelligence and Crystal Reports from our BI4 development environment to the production environment. His reports were created on a SAP BW BEx query data source.<\/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,1],"tags":[27,205,133,132,204],"class_list":["post-2092","post","type-post","status-publish","format-standard","hentry","category-knowledge-sharing","category-sapbusinessobjects","category-sapbw","tag-crystal-reports","tag-lifecycle-manager","tag-sap-businessobjects","tag-sap-bw","tag-web-intelligence"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-xK","jetpack-related-posts":[{"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":2092,"position":0},"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":2144,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-mastering-sap-businessobjects-analysis-edition-for-olap-with-sap-netweaver-bw","url_meta":{"origin":2092,"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":2662,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bi4-override-olap-connections-in-promotion-management","url_meta":{"origin":2092,"position":2},"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":[]},{"id":1851,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-netweaver-bw-and-sap-businessobjects-the-comprehensive-guide","url_meta":{"origin":2092,"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":430,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsiussap-bw-direct-connection","url_meta":{"origin":2092,"position":4},"title":"Xcelsius\/SAP BW direct connection HTG","author":"Xavier Hacking","date":"February 23, 2010","format":false,"excerpt":"SAP how-to guide on direct connection between Xcelsius and SAP BW now available.","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":1845,"url":"https:\/\/www.hackingsap.com\/blog\/sap-logon-hack-make-logging-on-to-sap-easier-and-faster","url_meta":{"origin":2092,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2092","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=2092"}],"version-history":[{"count":17,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2092\/revisions"}],"predecessor-version":[{"id":2712,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2092\/revisions\/2712"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=2092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=2092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=2092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}