url with single parameter to open webi report from Dashboard

[Former Member]

Can some one help me with url with single parameter to open webi (Prompted)report on click of Column in a dashboard. I am using Dashboard designer BO 4.0 sp5 I have used following url. it is opening report but prompting for parameter that means my parameter is not passing through url.

="http://<server>:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AX0kppH7znVNkim.VDHKND8&IsSBucket="&I3

IsSBucket is my parameter to which I am giving reference of cell I3

[Former Member]

Hello,

How have you built up your query?

This things i would recommend that you check  are as follows:

1. is your prompt declared correctly?
2. what is your prompt expecting? (Char, Numbers)
3. What are you passing?
4. Does wht your passing through actually work if you manually input it in the Webi?

Let me know what your responses to these questions are.

Thanks,

Em

[Former Member]

Hi Em,

Thank you for reply, I tried all that you suggested and following are the findings.

Data type of my parameter object is string but its values are 1,2,3.

From my dashboard xl sheet, I am passing values 1 or 2 or 3 through url on mouse click.

I tried changing my parameter object type to Numeric and exported universe and tried opening webi report based on that through dashboard but still problem persists. My prompt text is also correct. Manually prompt is working in fine. But not through dashboard parameter passing.

[Former Member]

Hello,

Have you had a look over the following document?

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

I wonder if you are passing a space through in your link. Can you get the link displayed on your dashboard to check this?

Thanks,

Em

[arijit_das]

Make sure of following points:

• You have no other prompts than Bucket. If you have, then you have to pass values for those also.
• The prompt text is "Bucket" without any extra space in left or right.
• The prompt is a single valued prompt (Equal / Not Equal operator).

[Former Member]

Hello Em,

I tried &lsSBucket:=" & I3 still it is prompting for parameter whereas it should consume my Bucket parameter from url, right?

[arijit_das]

It will be nice if you can attach the prompt screen of the report here.

[Former Member]

Hi Arijit,

Thanks for reply.

But its not possible to attach image as it is prohibited activity in our code of conduct.

[Former Member]

Hi Nishant,

Please refer to the below thread where the same was answered and let us know if you have any issues

http://scn.sap.com/message/14262094#14262094

Thanks

Mallik

[Former Member]

Hello,

When i was using a URL to open a webi i had to pass the parameter with the following code:

&lsSBucket:=" & I3

Try this and see if it makes a difference

Cheers,

Em