how to select prompt value from url in webi

[former_member631791]

Hi All

The requirement is very simple and straight forward. I am sending one PurchaseOrderNo by a relative URL to WEBI from lumira designer.

APPLICATION.openNewWindow('/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=saferjkhnwu478347nhch3473hue3u&sIDType=CUID&PONo='+selectedPO);

the above code is working perfectly fine(redirecting to the desired WEBI report).

Now I am unable to configure my WEBI report to extract the PurchaseOrderNo from the URL and use it as a i/p for the prompt.

Kindly help me.

i am using BO 4.2 Lumira Designer 2.3 SP 2 and universe as my data source for both dashboard and webi.

Thanks in advance.

[denis_konovalov]

I have fixed your tags to properly represent your question substance.

[arijit_das]

&PONo='+selectedPO

Above part of the opendocument url should pass the value to the prompt (PONo). Add sRefresh=Y in the url to refresh the data.

In WebI you can retrieve the value used in the prompt using UserResponse function.