How To Capture The Inputs given for a Filter Defined at Universe Level

[Former Member]

Hi ,

I have a conditional filter defined at Universe level

Wen this is used for Running Query using web Intelligence, It is asking for a prompt. That is cool and fine

Now my Question is that , I was unable to capture the prompt value being passed while running the Query .

For this object I am passing the values at universe Designer(3.1 SP5)

I would like to capture those prompts, I am not getting the same when I use UserResponse Function

Please Help me on this

Thanks in Advance

[JYOUSAF · Accepted solution]

Regarding Userresponse function:  

You can either create a dimension with the following code   Userresponse(‘Prompt Text’)

Please note that prompt text should be exactly the same as that used in universe filter, otherwise it will not work. 

Or you can drop a free standing cell on the canvas and use the above code.

[former_member4998]

Hi

Is your problem had solve or not?

Note: PLEASE mark the blog helpful & answered

[former_member4998]

Hi

To capture the prompts values entered at query run time.

=UserResponse( "Prompt Text") Like ("Enter Values for Sales ID")

Will give the prompt entered value.

=PromptSummary()

Will give the list of prompts entered at Query run time.

Pleaas find the below link.

http://bobjblog.wordpress.com/tag/userresponse/

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ffc_en.pdf

[Former Member]

Hi,

If you are getting blank in user response then you must have entered wrong Description in UserResponse() function .

Check the Actual description using

=PromptSummary()

Then Copy the Description from output & paste it in UserResponse() function .

[former_member207878]

Hi,

Can you please check, whether you are witing correct text in UserResponse function or not?

If your prompt is like below:

@Prompt('Enter Year','A','time period/year', Multi', Free)

The your user response function should be like:

=UserResponse('Enter Year')

[Former Member]

Hello,

as an alternative you can go ahead with: =ReportFilter([Dimension])

Best regards,

Victor