user response

building reports webintelligence legacy
1

Whenever I use the useresponse function,It always returns nothing.I Have a prompt which has the message “Unit Number:”.So when i use userresponse(“Unit Number:”), it returns nothing.Can anyone tell me where i am going wrong.

Thanks,
Raj

BOConsul :canada: (BOB member since 2005-01-12)

2

You have to provide the name of the data provider as well, for example:

UserResponse("Query 1 on Beach", "Which resort?")

Andreas :de: (BOB member since 2002-06-20)

3

Thanks Andreas,

          But in our User Manual it says it is optional and you have mentioned Data provider,Is it the object name or the universe name.In the example you had shown Query 1 on beach,Does beach denotes the universe name?.

Raj

BOConsul :canada: (BOB member since 2005-01-12)

4

Neither … it’s the data provider name. By default, data providers are named “Query x with universename” but the best way to determine the data provider name is look in the Data Manager (View, Data…).

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

5

Hi Dwayne,

     I am using Webintelligence too in my place.The syntax works perfectly well in Full client.But does not for the Webi reports.

Thanks

BOConsul :canada: (BOB member since 2005-01-12)

6

Webi does not require the data provider name. You got the responses you did since you posted in the “Reporter” forum. I’ll move it to Webi. 8)

As to your question… the prompt text must match exactly, case, punctuation, and spaces all count. If you copy the prompt text from the query panel and paste it into your formula, does that work?

Dave Rathbun :us: (BOB member since 2002-06-06)

7

I am really sorry for posting this here…But I cant help that beocause I am having both Full Client and Webi in my place and I have to implement in both.Anyways coming to our discussion,I cannot copy it directly from query panel as I have created a prompt conditional object in universe.I copied and pasted it from there and I am not able to get anything.

The syntax of that is as follows

UNIT.CURRENT_UNIT IN @Prompt(‘Enter Unit(s):’,‘C’,multi,free)

and the syntax I use in the report is

UserResponse(‘Enter Unit(s):’)

Can you tell me whats wrong in this…

Thanks,
Raj

BOConsul :canada: (BOB member since 2005-01-12)

8

Hi. I don’t know if this issue is still outstanding for you but I thought I would post the answer regardless…

The reason why your function isn’t displaying the user’s response is because of the (s) at the end of Enter Unit(s)…

WebI thinks that the parantheses are part of the formula rather than just part of your prompt. Until BO fixes this in WebI, I am thinking the only option you have is to have someone modify the @prompt in the universe so that it says
Enter Unit or Units
instead of the (s)

Hope this helps.
GW

geowickey (BOB member since 2005-04-09)

9

I don’t think that’s the reason. I think it’s because of the C.

@Prompt('Enter Unit(s):','C',,multi,free)

should be

@Prompt('Enter Unit(s):','A',,multi,free)

Steve Krandel :us: (BOB member since 2002-06-25)