cancel
Showing results for 
Search instead for 
Did you mean: 

Change datasource in existing report

Former Member
0 Kudos

Hi,

I have created a WebI report (SAP Business Objects BI Platform 4.0 Client Tools (version 14.0.2.364)), on top of a BEx query. The report has one crosstab table with additional variables created. I now want to change the original BEx query to a new BEx query. Is it possible to make that change without changing the entire report? Is it possible to change just the underlying query? Please help! Thanks!

-Janice

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Right click on the items you want to keep that hold your data and select clear contents. Your report will remain formatted and when the new data source has been selected, edit formula to each field add the new data source fields. This allows you to keep the text fields and report format.

Angela

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

the workflow you need to follow is:

Data -> Data Provider -> Tools -> Change Source -> Query -> Specify new source -> Select data Source -> BEx etc..

This will bring up a wizard where it will make assumptions about object mappings. you need to confirm or modif these.

Providing that the master and meta data isn't too radically different in the new target BEx, you're report may survive

Regards,

H

Former Member
0 Kudos

Is it possible to change the connection.

You can change the underlying query in the connection.

This will not affect the query but yes the query should have same objects available in this new query along with newly added object/condition.