cancel
Showing results for 
Search instead for 
Did you mean: 

connection name for the query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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...

Former Member
0 Kudos

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

Former Member
0 Kudos

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,

Former Member

Hi,

you can get this information from within the CMC:

-Go to Folders

-Navigate to the Webi report

-Right click:

Afterwards you should see there on which BICS connection your webi was built on.

Former Member
0 Kudos

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'

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

You can find the Dataprovider name by clicking on "Data " tab in WEbI

or  try this formula

Dataprovider(<Dimensionname>)

Thanks,

Jothi

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Also Try

Universename(<anyobjectname>)

Thanks,

Jothi

Former Member
0 Kudos

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,

Former Member
0 Kudos

Check http://www.forumtopics.com/busobj/viewtopic.php?t=77249 forunm link.

This might help you.