Hyperlinking and Drill

building reports webintelligence
1

Hello,
I have a master report which has 3 levels of drill:

Year–Region–Sales, when the user clicks on the sales a child report needs to be displayed with details. I am able to link the report but the values are not being passed (the value of year and region are not passed to the child report)

Following is the code used in the master report:

="<a
href=“http://server:1200/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?&iDocID=12564&sDocName=Sales_Detail&sType=wid&sRefresh=Y&lsSFinancial_Year=”+[Financial Year]+"&lsSRegion="+[Region]+"&lsSSales="+[Sales]+"">"+[Sales]+""

I have tried to embed the link in the object in the universe, still does not work,following is the code used:

="<a
href=“http://server:1200/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?&iDocID=12564sType=wid&sDocName=Sales_Details&lsSDemography=’||Demography.Region||’&lsSSales=’||Totals.Sales||’&lsSFiscalYear=’||FISCAL_MONTH.FISCAL_YEAR_NAME||’”>’||FISCAL_MONTH.FISCAL_YEAR_NAME||’’

Any Clues??

karthikeyani (BOB member since 2007-03-24)

2

Hi karthikeyani,

Please let me know the Demography.Region & Totals.Sales are like TABLENAME.COLUMNNAME ?

Regards,
Siva

SivakumarS :singapore: (BOB member since 2006-08-10)

3

Yes, Sivakumar thats right

karthikeyani (BOB member since 2007-03-24)

4

Hi karthika,

Please try this code and let me know

‘’||FISCAL_MONTH.FISCAL_YEAR_NAME||’’

Regards,
Siva

SivakumarS :singapore: (BOB member since 2006-08-10)

5

Thx for your response Siva,

I have managed to parse the object successfully,

'<a href="http://server:1080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sType=wid&amp;sDocName=Income_Expense_Detail&amp;iDocID=12564&amp;lsSChartfield='+D_CONTEXT.CHARTFIELD+'&amp;lsSOperating_Unit='+D_DEPTS.OPERATING_UNIT+'&amp;lsSAccount='+D_CONTEXT.ACCOUNT+'&amp;lsSBudget_Account='+D_TRANSACTION_CONTEXT.BUDGET_ACCOUNT+'&amp;lsSFiscal_Year='+D_FISCAL_MONTH.FISCAL_YEAR_NAME+'">'||D_FISCAL_MONTH.FISCAL_YEAR_NAME+'</a>'

The object in the drill hierarchy where I am embedding the hyperlink is a character, I have changed the object format to a “Number” and enabled the “Read as HTML” option.

When I try to run the parent report, the object is not recognized, get “ORA-01722” invalid number.

Any thoughts here…??

Thanks

karthikeyani (BOB member since 2007-03-24)

6

You can use to_char() function to resolve this issue.

SivakumarS :singapore: (BOB member since 2006-08-10)

7

where do I place the to_char

karthikeyani (BOB member since 2007-03-24)

8

Change the Object Type to Character

SivakumarS :singapore: (BOB member since 2006-08-10)

9

Is it working now ?

SivakumarS :singapore: (BOB member since 2006-08-10)

10

Sivakumar,
I think when an object is hyperlinked, the format should be
a number, however I did try by changing the format to a character, did not work.

          How do I use the to_char function in the object ?? this should

work…

karthikeyani (BOB member since 2007-03-24)

11

Paste the Object definitions with type I will look into this…

SivakumarS :singapore: (BOB member since 2006-08-10)

12

however i’ve a hyperlink object that has character as format, so it’s not a number and it works

carrera4 (BOB member since 2007-03-09)

13

The link works now…

  • Format needs to be a character

  • I used “||” in the code

  • The report needs to have a change in the format of the object - “Needs to be read as a cell”

Thank you

karthikeyani (BOB member since 2007-03-24)

14

Cool

SivakumarS :singapore: (BOB member since 2006-08-10)

15

We are trying to implement this for the first time at our shop. I am in a position where I can drill, I can link, but I can’t drill down to the floor and then subsequently link out to the detailed document.

We couldn’t get Oracle to parse our hyperlink at the universe level, and after spending an hour on the BOB had concluded this would need to be a report level solution. :nonod:

="<a href = 'http://enterprisereporting.blah.com:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?iDocID=308803&amp;lsSRegion+Name="+[Region Name]+"&amp;lsSArea+Name="+[Area Name]+"&amp;lsSSub+Area+Name="+[Sub Area Name]+"&amp;lsSSystem+Name="+[System Name]+"&amp;lsSFranchise+Authority="+[Franchise Authority]+"'>"+[Franchise Authority]+"</a>"

At the webI level, the link works fine. We are drilling 5 levels deep using a geographic hierarchy, before drilling to fact level details that sit in a report with 5 prompts.

The issue is that the hyperlink cannot be added to the level 5 dimension once the report has been run, and you cannot add a level 6 dimension (report variable) to the hierarchy at the report level. Yes?

Can anyone help me connect the dots?!
Thanks

lotsarows :us: (BOB member since 2002-10-02)

16

Hi Sivakumar,

Please can you help me in this issue

I am tying to do the open document .If i clicked on modify the document it asking enter the date values then it will open source report after that i clicked on opendocument link it is opening fine with parsing source reoprt dates. If i click on Document Name then child report is asking enter the date values after that if i clicked on open document link then target report asking enter the date values.

Please can help me to resolve this issue.

I am using this link

="<a href=http://server name/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName=LACcallcenterdetails&sWindow=Same&lsSSelect%20Start%20Date:="+[StartDate]+"&lsSSelect%20End%20Date:="+[EndDate]+"&sRefresh=Yes> Link To LAC Call Center Details"

Regards,
Rave

ravek (BOB member since 2006-08-03)

17

For the Target Report

a)Uncheck the Refresh on Open Checkbox

b)Please be sure you have no other Prompts than the one you are passing value.

c) Visit http://www.geocities.com/prabhatdotnet/Reports_Hyperlinking.doc
for details

Prabhat

prabhat :india: (BOB member since 2007-01-16)