Open Document Hyperlink

[Former Member]

Hi,

I have a unique request from the Customer. first, the User enters prompts values as City and State values and retrieves the Sales for those cities. The Webi report looks like this

City               State     Sales

Fremont            CA      120,000

San Diego         CA      90,000

Sales numbers should be hyperlink. When the User clicks on Sales of Fremont, then a new report should open up with all list of stores and sales for Fremont. Similarly for San Diego.

Can you please provide a solution for this for Business Objects 4.0 SP5
Your response will be appreciated. Thanks for your time.

[Former Member]

Hi,

Create two reports. Parent and Child report.

Parent report will have prompt on State and City.

Child report will contain Store and Sales information with prompt on State and City.

Create hyperlink on sales column in parent report. pass State and City to child report.

For more information on open document refer

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

[Former Member]

Hi Thota,

did you already follow the steps as described in the official tutorials?

here a good one for your question:

Create a link between documents: Web Intelligence 4.x - YouTube

best regards,

Victor

[Former Member]

Hi Victor,

Thanks for providing the link.

I'm not able see the Document in Linking tab (in webi rich client). I have BO 4.0 SP6 client tools.

Is there any other solution for this approach.

thanks,

Raghu

[Former Member]

Hi Thota,

that dialog is not available in the rich client or java applet, only in web mode (dhtml).

Just open an existing report with double click and then that dialog will appear.

best regards,

Victor

[Former Member]

Got it.

Thanks Victor.