BusinessObjects Board

Xcelsius: sWindow=New option not working in hyperlink

other Xcelsius - Crystal Dashboard Design
#1

Hi

After publishing SWF file to infoview, when i try to open the SWF file from Infoview the fonts size becomes smaller. When i tried changing the infoview preferences to open it in multiple windows the font size looks good. The disadvantage of this setting is it opens all other reports in a different page.

The requirement is only the .SWF file should open in a new window all other reports should open in the same infoview page.

My workaround

  1. created a folder in infoview named “Dashboard”
  2. Published the .swf file to the dashboard folder.
  3. Created a hyperlink thru CMC and used opendocument link to open this swf file.
    http://:/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AXvDotUUdTZFt2Owx4JzUQc&sWindow=New
    Swindow=New is not working. After researching in forums came across sWindow=New option is disabled in BO 3.1 version

They recommend to use the below link which gives error in CMC
=<ahref=“http://:/OpenDocument/opendoc/openDocument.jsp?sDocName=Drilldown” target="_blank"> MyTest

Can anyone please suggest how to open SWF file in a new window. Is there any alternative approach available for sWindow=New

ambrose.leo (BOB member since 2012-01-17)

#2

It is true that Window=new is not a reliable parameter in BOBJ 3.1. It is also true that much of the SAP support details are written by non native speakers of English. Sometimes, the explanations and code portions are very sloppy. As it is in the case you found.

This technique only describes how to get your links to open in New Windows outside of Infoview (bobj security still is active tho). The OP will have to experiment to get the files to behave exactly like you want. Using Infoview has alot of disadvantages.

Here is your correct syntax. Be a sport and reply if this works in your environment:

How to code Xcelsius to open new windows:

  1. In cell A1, type the following.
<a href="http://server:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AbSMFlhBdWlInOi79bwOHrs&amp;sIDType=CUID&amp;sType=wid" target="_blank">Go to My Sweet Webi Report</a>
  1. Get a Text Component.
  2. In General Properties, CHECK HTML FORMATTING
  3. Bind Text component to cell A1.
  4. Preview / Test

Bonus Content:

Inevitably someone will find this post and ask about how to do the same thing but with Parameters…so…today is your birthday:

Simple example of link with a parameter restricting the Webi to a specific location that opens in a new window.

Tip#1
**the Webi has a parameter in the Query Filter section, called ‘location’ MATCHES PATTERN [Location ABBR]

<a href="http://server:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AbrWsXwHAf1Miimb_tIpQ3c&amp;sIDType=CUID&amp;sType=wid&amp;lsSlocation=([Location ABBR])&amp;sRefresh=N" target="_blank">Go to My Sweet Webi Report</a>

Tip#2
***The phrase in the above code [Location ABBR] is actually replaced, via Excel concatenation with a value. No quotes, no nothing. Just replace [Location ABBR] with Chicago or New York or China, etc.

You will want to do that dynamically, of course, using cool xcelsius selectors.

Tip#3
All OpenDoc links syntax is case sensitive. For this reason, when you make Webi parameters, use small letters and no spaces. Spaces are difficult to deal with in OpenDoc.

Cairmor :us: (BOB member since 2008-06-05)

#3

Thanks Cairmor. This helped me a lot.

ambrose.leo (BOB member since 2012-01-17)

#4

Hi Cairmor,
It isn’t my birthday, but maybe you can help me out anyway.

Is there a way to set the URL in such way it “lives” through my OTAP street?

----EDIT----
Whoops, just celebrated my own birthday

Replacing the first part: htt://servername:8080/open…
with

../../../

will do this for you

Tiny :netherlands: (BOB member since 2004-11-10)