Hi All ,
In this article you will know how to change your Bex Query Semantic layer source in your web intelligence report in 5 finger clicks.
One of the greatest features that Business Objects has is to connect you BO server to a different data sources.
Business Scenario: you have 1 Business Objects4 landscape (system) in your organization, and you have 2 BW systems Dev/QA, Prod as sources
You would like to connect your BO server to BW Dev/QA for Testing the Gui/Functionality and Data and then connecting the same web intelligence reports that you have designed ,but this time over your BW production, remember 1 BO server connected to 2 BW systems
Before we begin- key assumption
- You will need to have your BEX Query report available for BO – develop/write your report in BW Development and transport the BW Query to BW QA
- 2.you need to tell your business objects admin to set up booth BW system’s as source in Business Objects – see pic 1 + pic 2
- I assume you already developed your web intelligence report over Bex Query which is on your BW Development or QA systems.
Picture 1 -you choose Bex query as source
Picture 2 – you can see you have your 2 BW system configured – in my case BWD & BWP
After you have chosen one of your web intelligence reports over BWD/BWQ, you have the option to go to the Data tab (if you don’t see the Tab it is because you don’t have permissions)
Then right click over the query –you will have a menu bar- choose change source
After clicking on change source you have the following screen – choose specify a new data source and click on the select a data source
Now it will open your BW system’s as pic 2 shows – you can chose your Bex Query Source in your BW Production system (you first need to transport the same BW Query which is over your BW Dev/QA system to your BW production and that is it) you can choose your BW Bex Query from your BW Production and then the web intelligence report will run over BW Production
Simple as that !!!!
Hope you liked this “How to”