Document/hyper link among webi reports

[former_member222155]

Hi Gurus,

I am trying to link webi documents,

I hav 2 options

1.)hyperlink and

In hyper link I am using this link but i am not able open the target document..

https://bodev.pg.com/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=ATjA2dUY7u1Hldh9n... Date]

2.) document link

I am  not able to see the document link tab  in report elements (as in attachments). I would like to know how to view that option

regards

mahi

[former_member193866 · Accepted solution]

Hi Mahendra,

If you apply hyperlink by using opendoc, it will prompt the user to select a value

If you use document linking you don't get prompt

Regards

Riaz

[former_member222155 · Accepted solution]

Hi Riaz,

Thanks for your comment..

I dont want any prompts in child rep, whn i click on parent rep 'rundate' it should navigate to child rep and child should run on that particular 'run date'...

I tried both hyperlink and document link , in both cases i am able to link the reps but the child rep is not picking the val from parent.. i tried keeping/removing 'rundate' prompt in child rep but no luck...

For achieving this what setting i need to put in parent and child reps cn any one suggest(i tried all possible options, want to know if still im missing anything)

I am using BOBI 14.0.5 version

Thanks in adv...!

mahi

[former_member193866 · Accepted solution]

Hi Mahendra,

With out applying prompt in child report how can you pass the value from parent?

Try document linking by applying prompt in child report (same obj should be there in both reports eg: year in parent,same obj in child). Apply prompt on year as per eg.

Ask if you need any help

regards

Riaz

[former_member222155 · Accepted solution]

Hi Riaz,

Thanks alot.........!!!!!!!! for ur valuable time..

Actually i tried the same but seting in parent rep is missing..

Now every thing is fine, documentlinking is working and values are passing..

@Every one : Thanks alot.........!!!!!!!! for ur valuable time frnds..

thanks and Regards,

mahi

[former_member222155 · Accepted solution]

Hello Riaz,

I am able to apply doc linking on horizontal/vertical  tab successfully but I want to apply doc linking on crosstab..

And the linking should be row wise linking.. I have 7 rows in my main rep where when i click on each row it should get navigated to respective detailed report.

Please advice me..

thanks

mahi

[former_member193866 · Accepted solution]

Hi Mahendra,

Can you share your reports screen shot?

Regards

Riaz

[former_member222155 · Accepted solution]

Hi Riaz,

Please find the below screenshot... If i click RPT4 row it should go to RPT4(order cuts) for respective date..(I am passing rundate over here)..

and same way if i click RPT6 row it should go to RPT6 for respective date..(I am passing rundate over here)..

and the detailed reps RPT4,RPT6 will be running for selected date.. this feature im able to achive in normal table but in cross tab whn i right click on particular row to apply doc linking whole body of the tab is getting selected and doc linking is getting applied to all row.. but it need to be applied for only selected row like RPT4 or RPT6..

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahendra,

Crate a variable by using if condition.

If [Coulumn]= "RPT4" then <copy and paste the formula of the hyperlink here> (by double clicking the hyperlinked column you will get the formula.In the place of doc id give "RPT4's detail report id") elseif <copy and paste the formula of the hyperlink here> (here give RPT6's doc id)

Than select read content as hyperlink option.

Ask me if you need any help on this

Regards

Riaz

[former_member222155 · Accepted solution]

Hi Riaz,

thanks for your above response ..

I am using  the below formula for creating a variable

=If([Report ID]="RPT4") Then (<a href=\"../../opendoc/openDocument.jsp?iDocID=ATjA2dUY7u1Hldh9n6imWmM&sIDType=CUID&sType=wid&lsSpsEnter%20values%20for%20Run%20Date%3A="+URLEncode(""+[Run Date])+"\" title=\"Click to verify Order Cycle Analysis\" target=\"_blank\" nav=\"doc\"> </a>)

ElseIf([Report ID]="RPT6") Then <a href=\"../../opendoc/openDocument.jsp?iDocID=AcuNeLMciGdLrPTSTJBd6Sk&sIDType=CUID&sType=wid&lsSpsEnter%20values%20for%20Run%20Date%3A="+URLEncode(""+[Run Date])+"\" title=\"Click to verify Order Cycle Analysis\" target=\"_blank\" nav=\"doc\"> </a>

It is giving some sub expression missing error.

And i need to use the above variable at vertical position in the cross tab right...??(pls confirm)

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahi,

Put hyperlink formulas in ""

Regards

Riaz

[former_member222155 · Accepted solution]

Riaz..

I tried that too but it is taking as string and displaying the whole formula in the rep..

i used this formula..

=If([Report ID]="RPT4") Then "<a href=\"../../opendoc/openDocument.jsp?iDocID=ATjA2dUY7u1Hldh9n6imWmM&sIDType=CUID&sType=wid&lsSpsEnter%20values%20for%20Run%20Date%3A="+URLEncode(""+[Run Date])+"\" title=\"Click to verify Order Cycle Analysis\" target=\"_blank\" nav=\"doc\"> </a>"

ElseIf([Report ID]="RPT6") Then "<a href=\"../../opendoc/openDocument.jsp?iDocID=AcuNeLMciGdLrPTSTJBd6Sk&sIDType=CUID&sType=wid&lsSpsEnter%20values%20for%20Run%20Date%3A="+URLEncode(""+[Run Date])+"\" title=\"Click to verify Order Cycle Analysis\" target=\"_blank\" nav=\"doc\"> </a>"

pls assist.

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahi,

Right click on the cell and select "read as hyperlink"

Regards

Riaz

[former_member222155 · Accepted solution]

Riaz..

that variable is working

As per the below screen.. im using the respective fields in the below cross tab.. and whr to use that new variable im not getting , can u pls  suggest me..

red : data mismatch in detailed rep RPT4 and RPT6 for date 5/30/2014

green : data match in detailed rep RPT4 and RPT6 for date 5/29/2014

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahi,

Palce at rep names

Regards

Riaz

[former_member222155 · Accepted solution]

Hello Riaz,

I paced at rep names now hyperlink is appplying to that col only, but

1.)it need to be applied whn i click on cell(red/green)

for ex if i click on a cell that is common to 5/30/14 and Order Cuts then the order cuts detailed rep should be opened for the date 5/30/14

and same way for SD Adhoc STO also

2.) And for this variable what we created I am getting blank cell as shown..any idea y we are getting this blank cell...

this linking i have done in normal table but as this is cross tab im not able to link cell wise..

pls assist..Riaz

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahi,

for the blank cell Add else [obj name] to the formula in the end

Coming to the hyperlink for the detail....

Apply alert with the same formula

Regards

Riaz

[former_member222155 · Accepted solution]

Thanks Riaz..

This blank cell issue i have when i used normal table also, I applied this in that table and working fine..

And one more thing when I am apply hyper link to the cell, the cell contents are getting changed to underlined(hyperliked) so because of this the alert is not getting applied.... any suggestion over here pls..

alert i applied is(when cell contents are equal to "Green" apply green colour to the cell), when i apply hyperlink the "Green" is getting changed to Green so alert is not geting applied..

thx

mahi

[former_member193866 · Accepted solution]

Hi Mahendra,

In the alert if you click on format... there you can see formula tab. There put the hyperlink formula and select read as hyperlink. In the left select colour.

Regards

Riaz

[former_member210032]

Hi mahendra,

1.hyperlink

In your link include port number

2.Document link

In preferences change web i to interactive then you got document link.

3.You want to pass the "rundate" dim val from parent rep to child rep and the child rep should run based on that date....

use "rundate" prompt in child report then you get data as per your date report .

Thank you

Mustafa

[former_member222155]

Hi Mustafa,

thanks alot for your wonderful suggestion..

I am using document linking and i am able to link parent and child reps..

And I kept rundate as the bo prompt in child rep.. when i am clicking rundate in parent rep it is navingating to child rep but child rep is not taking that data(child rep is asking a prompt again)

any advice pls

thank you

mahi

[Former Member]

The Java applet interface (=Rich Internet Application) does not offer that option, only the Web mode (DHTML). You can change the mode under the user preferences in LaunchPad.

Here are further differences:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/12/16/feature-differences-be...

[former_member222155]

Thank you Victor..

I want to pass the "rundate" dim val from parent rep to child rep and the child rep should run based on that date....

may i know whether this is possible in document linking or i need to go to hyperlink concept...

suggetion pls..

thanks

mahi

[Former Member]

you need to go for Document linking, not Element linking. As an example:

[former_member222155]

Thanks alot Victor the document is vry infromative..

I linked the parent and child with document linking ..but the rundate value is nt passing properly..

The child rep also having the bex variable... The child table to pick up the val from parent do i need to remove the existing bex variable in child rep..??

or do i need to modify the bex variable to single date in the child rep

Note: child rep having bex variable of both start date and end date.. but i am passing only one date val..

thanks

mahi

[Former Member]

if the child report has a range you should be fine, just change your syntax to range and pass the same value twice for stard and end date.

But of course you can also have a single value variable in the child report to pass.

[former_member222155]

Hello Victor,

I am able to apply doc linking on horizontal/vertical  tab successfully but I want to apply doc linking on crosstab..

And the linking should be row wise linking.. I have 7 rows in my main rep where when i click on each row it should get navigated to respective detailed report.

Please advice me..

thanks

mahi

Document/hyper link among webi reports