Unable to call the WebI reports

other Xcelsius - Crystal Dashboard Design
1

Hi All,
I am using relative path hyperlink syntaxes to WebI reports.
These links are working fine while calling from BO application.
I am using the same syntaxes in xcelsius dashboard to call the same report but it is not working fine.

="<a href='../../opendoc/openDocument.jsp?&amp;sType=wid&amp;sRefresh=N&amp;sIDType=CUID&amp;iDocID=AeIxFiaT07dHvfCvsOK8gjc&amp;sWindow=New'"+"\"target=_Parent>"+[Blank]+"</a>"
<a href="../../opendoc/openDocument.jsp?&amp;sType=wid&amp;sRefresh=N&amp;sIDType=CUID&amp;iDocID=AeIxFiaT07dHvfCvsOK8gjc&amp;sWindow=New">Blank</a>

Can you please suggest me that what was missed in this.
Thanks in advance.

Arjun (BOB member since 2008-07-28)

2

Are you try to open webi reports in Xcelsius?? If not, I think your in the section.

katullus :us: (BOB member since 2009-08-21)

3

why are you using …/…/ path? To get that to work you have to call it from a specific location on your web server. Use fully qualified URL and you should be good.

J0sh :australia: (BOB member since 2006-10-09)

4

So does it work if you use the full path?
What do you mean they work when calling from the BO application? Is that from InfoView? How do you call them like that?

You need to outline what you are doing a bit further before anyone can help you.

J0sh :australia: (BOB member since 2006-10-09)

5

Thanks for the replies.

Yes.

Because I need to move the file to different environments. But each time I need to update the server:port,reportname,details.So, I am using the relative path.

I am getting the error in while openuing the report in infoview:

HTTP Status 404 - /jsp/Flash_View/opendoc/openDocument.jsp

message /jsp/Flash_View/opendoc/openDocument.jsp
description The requested resource (/jsp/Flash_View/opendoc/openDocument.jsp) is not available.

Anybody facing the same? Or any solution? :roll_eyes:

Arjun (BOB member since 2008-07-28)

6

You’ll probably find that you can’t use relative paths from within Xcelsius.

As a workaround, you could add a cell to your Excel model that contains the server and port numbers, and inserts them into the absolute opendocument path. Then you just have a couple of cells to change when you move environments.

cashworth (BOB member since 2005-02-09)

7

cashworth,Thanks for the reply.
Can you please tell me the steps to implement the server and port numbers details on Excel sheet. I am little bit confusing on this.

Arjun (BOB member since 2008-07-28)

8

Well, somewhere in your dashboard you have the URL to link to the web intelligence document, like this :

<a href="../../opendoc/openDocument.jsp?&amp;sType=wid&amp;sRefresh=N&amp;sIDType=CUID&amp;iDocID=AeIxFiaT07dHvfCvsOK8gjc&amp;sWindow=New">Blank</a>

Use a cell on your Excel sheet (E1 for example) to contain the server/port information, e.g.

http://boxiserver:8080/OpenDocument/opendoc/

Then, replace all your opendocument URLs with :

CONCATENATE("a href=", E1, "openDocument.jsp?&amp;sType=wid&amp;sRefresh=N&amp;sIDType=CUID&amp;iDocID=AeIxFiaT07dHvfCvsOK8gjc&amp;sWindow=New">Blank</a>")

Excuse any syntax errors, but you should get the idea…

cashworth (BOB member since 2005-02-09)

9

cashworth, Excellent :slight_smile:
I have implemented the above but how to pass the server details dynamically?
For example, if I export to server A , It needs to call Server A details(Server,port number and CUID) in the hyperlink details from the cell.

Arjun (BOB member since 2008-07-28)

10

Hmm, not entirely sure how you’d do that, I don’t know if you can pull the current host or referrer from flash variables (if such environment variables exist).

cashworth (BOB member since 2005-02-09)

11

Anybody faced the same issue? :blue:

Arjun (BOB member since 2008-07-28)

12

Two things:

  1. Make sure that CUID is same across the servers

  2. Use Relative path (do not hardcode server name in the excel). It will start as below. Export the flash into the new server and by default the new server will be effective (if doubtful, perform some data validation).

/OpenDocument/…/…/…/…

selvaips (BOB member since 2005-05-03)

13

You actually can use relative addressing in Xcelsius. It just isn’t exactly the same syntax you would use in WebI or Crystal. We faced this problem a while back. What I found is that for some reason Xcelsius does not properly substitute the server value with the syntax

"../../OpenDocument/opendoc/openDocument.jsp?

If you remove the first 2 dots as in

"/../OpenDocument/opendoc/openDocument.jsp?

it will work fine. It took a bit of investigation to see what Xcelsius was actually generating, then I experimented to see if I could get it to work. I’m not sure why Xcelsius doesn’t like the standard syntax but the modified syntax as shown above does work.

tmarion :us: (BOB member since 2002-08-20)

14

tmarion and selvaips,
Thanks for the spending time for this issue.
I am using this syntax but still it throws the error in infoview and doen’t work on xlf file.
Syntax:

"/../OpenDocument/opendoc/openDocument.jsp?&amp;sType=wid&amp;sRefresh=N&amp;sIDType=CUID&amp;iDocID=AeIxFiaT07dHvfCvsOK8gjc&amp;mode=full"

Error:


HTTP Status 404 - /jsp/Flash_View/OpenDocument/opendoc/openDocument.jsp

--------------------------------------------------------------------------------

type Status report

message /jsp/Flash_View/OpenDocument/opendoc/openDocument.jsp

description The requested resource (/jsp/Flash_View/OpenDocument/opendoc/openDocument.jsp) is not available.

Please correct the syntax what I used.

Arjun (BOB member since 2008-07-28)

15

Can you please do this?

Add server name before the OpenDoc and copy the whole and paste it in a new browser and see whether it opens a report?

http://dev:8080/OpenDocument/…

selvaips (BOB member since 2005-05-03)