I need to identify the connection in a deski report but when i select ‘edit data provider’ all i get is the parameter box check attatchment. I need to know the connection so that i can give access to users throught the CMC > connections
ilbo 
(BOB member since 2008-10-09)
You can get it by
= CONNECTION("QUERY NAME") .
haider 
(BOB member since 2005-07-18)
Hi,
The data provider is not based on a universe but based on a stored procedure. I am not sure now if such connections are available in CMC > Connections.
Marek Chladny 
(BOB member since 2003-11-27)
Hi Haider,
I used this Connection function in a Deski report to find the connection that the associated universe is using but unfortunately the function isnt working.
The syntax is as below,
=Connection("Query 1 with GPS Data Warehouse")and the result is
=Connection(“Query 1 with GPS Data Warehouse”)
Thanks…
JohnJustus 
(BOB member since 2007-06-25)
Mine is a silly question. But do you prefix = in your formula?
=Connection(“Query 1 with GPS Data Warehouse”)
Jansi 
(BOB member since 2008-05-12)
The result should have been something different and not the syntax again which you said here
=Connection("Query 1 with GPS Data Warehouse") 
.
haider 
(BOB member since 2005-07-18)
yeah , I expect the same, but the result is same as the formula?
@Jansi- I have a prefix =
Thanks.
JohnJustus (BOB member since 2007-06-25)
I have an upadate.
When I export the report, which has that function to infoview I can see the function results in Infoview but not in Deski.
Thanks…
JohnJustus (BOB member since 2007-06-25)
Quite strange! :?
Jansi (BOB member since 2008-05-12)
Did you check it in another cell in another report tab or another report itself
.
haider (BOB member since 2005-07-18)
How about:
=Connection( dataProvider( <objectfromquery>) ) digpen (BOB member since 2002-08-15)