Skip to Content
Author's profile photo Former Member

WebI to WebI Open Document in SAP BusinessObjects 4.0

Open Doc (Hyperlink) from WebI- WebI (4.0) i.e., Mother WebI Report to Child WebI Report

Note: This document gives the step by step process, to open the child report based on the prompts passed from the Mother Report.

Data Source: Southeast Sales Universe

Step 1: Create a Mother Report (Parent Report). Here Region, City and Net Sales are result objects as shown below.

/wp-content/uploads/2013/11/1_322039.jpg

Step 2: Create a Child Report having parameter. Here Region is the parameter from mother to child report

Note: Here R is the Parameter text.

/wp-content/uploads/2013/11/3_322053.jpg

    The below screen gives the Child Report.

/wp-content/uploads/2013/11/2_322052.jpg

Step 3: Copy the URL from child report.

Go to Documents –> Right-click on the Child Report –> Document link

/wp-content/uploads/2013/11/6_322113.jpg

/wp-content/uploads/2013/11/5_322054.jpg

Step 4: Go to Mother report, Right-click on the object Region –> Linking –>Add Hyperlink as shown below.

/wp-content/uploads/2013/11/6_322113.jpg

Step 5: Paste the Child report Document link

/wp-content/uploads/2013/11/7_322065.jpg

Step6: Here Region is the parameter, so add &lsSR along with the document link and Parse

           ( As It is a single parameter so &lsSR=([Region] in the below link)

   Where lsS is single value and R is parameter text of child report prompt and Region is the Dimension

/wp-content/uploads/2013/11/7_322065.jpg

Step 7: Select the object as Region as shown in the below screen.

/wp-content/uploads/2013/11/9_322067.jpg

Step 8: select the Target window.

/wp-content/uploads/2013/11/10_322068.jpg

Step 9: As the Region will be highlighted with the link as shown in below screen.

Now select the Region from Mother Report that will open the child report.

Step 10: Here I have selected the Region EEMEA in the Mother report, The child report as to get the data for the same prompt.

/wp-content/uploads/2013/11/11_322103.jpg

The below screen Shows the Child Report:

/wp-content/uploads/2013/11/14_322112.jpg

Hope this documents helps,

Thanks & Regards,

Shivani.

Assigned tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for Sharing...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      thank you Yogesswara reddy... these complements helps me to boost my energy levels

      Author's profile photo Gaurav Aggarwal
      Gaurav Aggarwal

      Thanks for Sharing. I did not understand what R is, is the text for region value EEMEA?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yeah Gaurav, R is the parameter text, By default the parameter text will be like Enter Region: But I have changed it to R for the Convenience.. Please find the screen shot for your reference.

      Please let me know if you need for clarification.

      /wp-content/uploads/2013/11/3_322698.jpg

      Author's profile photo sampath guntha
      sampath guntha

      Nice Post.

      Keep posting........................

      Author's profile photo Former Member
      Former Member

      Hi Shivani,

      Nice and useful blog. Thanks for sharing.

      BR

      Aakash G

      Author's profile photo Former Member
      Former Member

      Good...Thanks for sharing........!!! Keep it up.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you all..!

      Author's profile photo Former Member
      Former Member

      Simple and Clear.......Nicely explained..........

      Regards,

      Chandrakanth

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks ChandraKanth

      Author's profile photo CH Raman
      CH Raman

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Very useful... exactly I was needing 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Enio..

      Author's profile photo Former Member
      Former Member

      Very useful, Keep it up. 🙂

      Author's profile photo Former Member
      Former Member

      Thanks for sharing. I have tried the same but its not working. Please help to resolve this issue.

      I have created Level1 report and its showing Store name,State,City,Sales Revenue.

      For above created one chart in the same report and done "Element Link" for State & City.

      Created Level2 Report and set the store name as prompt and just execute the report by giving prompt value "Store name" as "e-Fashion Austin" and save the report and copied the document link.

      After that adding hyperlink for "Store name" column in the Level1 report and done the steps given in the blog. After click the hyperlink my Level2 report showing the details for store name as "e-Fashion Austin" but in my level1 report, clicked the store name as "e-Fashion Austin".

      I have noticed that level2 report is showing the details according the prompt which i selected while creating a report.

      And its working fine with doucment link option.

      Also plz anybody can explain abt "Use complete URL path to create hyperlink"?? in Document Link. I tired this option by giving document link in the url but i didnt find any difference with this option enabled or disabled 🙁

      Author's profile photo Lakshminarasimhan N
      Lakshminarasimhan N

      Hi, you have used "open document" or "Hyperlink" to connect the parent and child report. Same can be easily achieved via "Document linking"? Is there any reason to choose "Hyperlink" rather than "Document linking"?