BusinessObjects Board

Hyperlinks within the reports in Favorites?

building semantic layer
#1

Hi,

Can we create hyperlinks to the reports within Favorites folder?

While I was trying to link to the report in Favorite folder from Dashboard manager, it didnot show the document in the list of documents.

Actually, I want to know the object CUID for the report in favorites folder. But I am not able to get.
Any suggestions please.

GowthamSen :india: (BOB member since 2006-08-31)

#2

I’m not sure why you would want a hyperlink to a document in a personal folder. No one can get to it, except the document’s owner, or the Administrator.

What version are you using? In XI 3.0, you can view the document’s properties, including the CUID, in InfoView.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#3

Hi,

I am using XIR2.

Actually, I am creating some reports in my favorite folder and tried to link between the reports.

I verified the document properties in the infoview by opening the report–> Document --> Properties. But I couldnot able to see the CUID.

Can you please let me know, am I looking at the right place?

GowthamSen :india: (BOB member since 2006-08-31)

#4

Well, you are looking in the right place, but the wrong version. :roll_eyes: XIR2 doesn’t show the CUID. You’ll have to use Query Builder to find the CUID. See this post for some sample queries that may help.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#5

Hi,

Thank you. I am able to get the CUID.

Now I am facing 2 problems with hyperlinks.

  1. I wan to pass the date as parameter to the subreport. When I pass the date, the report is not showing data. But when I run the subreport with the same date as input, its working. Is there any difference for date objects passing as parameters in hyperlinks?

  2. In another hyperlink, I am getting the error as follos
    “Internal error occured: Database error: ORA-01722: invalid number . Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)”.

The hyper link I provided is as follows.

="<a href='/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sType=wid&amp;sRepoType=Corporate&amp;iDocID=xysom_yunfNAragC5z4uVww&amp;sIDType=CUID&amp;sViewer=html&amp;sRefresh=Y&amp;imode=full&amp;sDocName=Report+-+sample&amp;lsSDocument="+[Doc Name]+"&amp;lsSFiscalMonth="+[Fiscal Month]+"&amp;lsSFiscalYear="+[Fiscal Year]+"' Target=_blank>"+[Fiscal Month]+"</a>"

Please suggest me.

GowthamSen :india: (BOB member since 2006-08-31)

#6

Hi,

I got the problem for the (2) nd query.
I am passing year as a parameter. I applied FormatNumber and passed it. I worked.

Still I am facing the problem with passing date parameter.

GowthamSen :india: (BOB member since 2006-08-31)

#7

I don’t see any dates in your code. Am I missing something? There shpuldn’t be any difference in passing a date or passing any other variable.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#8

Thank you Michael Welter.

Actuallly, for the dates, there is another hyperlink.
I solved the issue now.

I created a variable and converted the date into a string. And passed that variable as input to the date parameter.

Its working fine.

Thank you very much for your quick responses. :wave:
Good day!

GowthamSen :india: (BOB member since 2006-08-31)