on 12-18-2012 5:48 PM
Hi,
Can anyone suggest me how to find the source connection name of the webi query which is created by using BICS connection (as we have configured two BICS connections).
I am not getting anythig using formula: =Connection(DataProvider([Obj]))
Thanks in advance,
Reddy
Hi,
I think this may work
Go to CMC >> Navigate to the Webi Document>>Right Click>> Default Settings>> Report Universe...Under Universe Name you can find the BICS connection Name...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reddy,
If you just want to know the connection name try checking in report properties.
If you want to display the connection name in your report then go for Connection() function.
But this can be used only when you have authorization to edit the connection.
Hope it helps.
Regards,
Shilpa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You will get the connection name in your report using connection function if your source is Universe, but my source is Bex query using BICS connection. (There is NO universe).
We have configured two BICS connections in our QA environment for two different BW source systems. We have webi report which is built on BEx query(xx). This BEx quer(xx) is available in two BW source systems. So I need to know, webi report/xx is pointing to which source connection (BICS).
Hope you understand the issue.
Thanks,
As an alternative you could also run a query like the following in Query
Builder, you would get the ID of the BICS connection used in the webi report:
SELECT SI_NAME, SI_DOC_COMMON_CONNECTION FROM CI_INFOOBJECTS WHERE SI_NAME='reportName'
Hi,
You can find the Dataprovider name by clicking on "Data " tab in WEbI
or try this formula
Dataprovider(<Dimensionname>)
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jothi,
Thank you for your reply. As I mentioned in my post, I am looking for the connection(BICS) name of the webi report (which we created on BEx query using BICS connection).
The formulae Dataprovider(<Obj>) will display source query(Bex) of the report. But the formula which i mentioned in my post will display connection name if source is universe. But in my scenario nothing is displaying.
Any other suggestion please? how we can find the connection(BICS) name of the webi report (on Bex query).
Thanks,
Check http://www.forumtopics.com/busobj/viewtopic.php?t=77249 forunm link.
This might help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.