HI Steve, Thanks for pointing to this page - we are using this way of embedding for part of our needs but for the other part we do need to use the SOAP API's. Thanks Yossi

This is a really important idea!. We would appreciate this option as well. Today we have a massive use of scheduling OBI reports via GoURL. We would like to have this export option available also by code - like GoURL for example. This is for embedding the export option into our portal. Thanks

HI We would like to Identify Via API - DV Canvases (under DV Projects) - currently we can identify only DV project without any information about related Canvases In our portal we integrate OAS objects into our home page. In order to do that , we use ORACLE SOAP API’s - http://:9502/analytics-ws/saw.dll/wsdl/V12 . We would…

As you could see below the first source "D15 Item Loan" will always be false, and the second "D15 Item Loan_Vertica" should always be true but still the source is pointing to the first not to the second database:

Thanks Robert, I tried this also as you suggested: first source: "Alma Funds Expenditure"."D15 Item Loan"."Source" <>'1651' and 1=2 Second source: "Alma Funds Expenditure"."D15 Item Loan"."Source" ='1651' or 1=1 Still it went to the first one.. I think I'll open an SR as you suggested. Thanks a lot Yossi

Thanks Christian , I tried this also, regarding the data types - unfortunately, didn't work..

HI Christian, We would like to switch according to an initialization block parameter. Thanks Yossi

HI Robert Thanks a lot. I would really appreciate seeing your way how this worked. Please see screenshots below with our try. The problem is that no matter what order of the sources was - the OBI always used the first source... Thanks Yossi

Thanks for the Fragmentation explanation - The funny thing is that when switching between two tables in the same source - it works fine, but among two data sources - it always uses the first one and ignores the second... (maybe a bug - not sure) Thanks Yossi

I know there could be differences between the two in terms of "pre-configured parameters" Assuming the two databases will use the same general parameters then if we would be able to do this switch between them - will be great. Thanks

HI Any other help in a any way to solve this issue will be more than appreciated Thanks Yossi

Thanks for your answer and comment. 1. Regarding "fragmentation" - we thought that it might help for using it to defer sources as well.. - unfortunately it didn't.. 2. The two different sources are being used in order to test - for few months - a big data database and compare it to the existing db (by changing a parameter)…

OK.. I thought you where referring at first to the OBI11 now I understand you spoke about the 12. Thanks again, Yossi

I get it..unfortunately. thanks a lot for your help. So, I will have to wait for our upgrade to the OBI12.. Thanks Yossi

My version is 11.1.1.9.160119. Thanks Yossi

Thanks a lot Gianni. I will try that. Yossi

Thanks, Christian. But I tried this - doesn't work. Yossi

HI Gianni Thanks for your answer! I have the privilege to do that - I do it manually also - But when I do it, I do not see any change in the URL line which I could copy from.. also the "create prompted link" doesn't help here. So I don't know what are the parameters expected here.. Thanks Yossi

HI Thomas, I understand, thanks a lot for your answer !. Yossi