Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED PARTIALLY] WF7.6.9 and FOCEXURL

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED PARTIALLY] WF7.6.9 and FOCEXURL
 Login/Join
 
Darin Lee
Virtuoso
posted
Someone on 7.6.x please ease my mind on this one. We are upgrading from 7.1.6 to 7.6.9 and I am running into an issue with drilldowns from PDF/Excel reports. I've gone through the posts, tech issues, etc. but i'm still banging my head on this one. In the 7.1.x version, I generate a report with a drilldown. The link looks like

http: //servername/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,budgetbm.budgetbm,htm&IBIF_ex=app/moed02.fex&CLICKED_ON=name/value...

When I run the same report in WF 769, the URL is VERY different:

http: //servername/ibi_apps/WFServlet?IBIF_ex=app/moed02.fex&CLICK_ON=name/value...

Seems like it's losing half the necessary information. The second url results in "procedure not found"

I have the FOCEXURL=http: //servername/ibi_apps/WFServlet? in the fex, but it doesn't seem to be working. Possible something I am missing in my client server configuration?

This message has been edited. Last edited by: Darin Lee,


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
Further notes - I am trying to drill from an MRE procedure to a second MRE procedure. If I do not include the SET FOCEXURL= in the procedure, then I get the entire properly formed URL, except that it begins with file: /// instead of http: //

Any ideas?


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
¿¿¿hmmm???


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Dave Ayers
Platinum Member
posted Hide Post
I've never seen an extension used in the focexec parm before, so you might try it without that...

IBIF_ex=app/moed02.fex
IBIF_ex=app/moed02


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Dan Pinault
Guru
posted Hide Post
Darin,

You mentioned that you are running a report in 7.6.9 that was created in 7.1.6. What happens if you recreate the report from scratch in 7.6.9?

I just created a drill-down report from scratch in 7.6.9 and the URL to the second report looks like...
http: //servername:port/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,powersys/powersys.htm&IBIF_ex=app/car2&CLICKED_ON=&COUNTRY=ITALY


As you can see here the MRE Domain = powersys, the procedure being called = car2, and the variable being passed is &COUNTRY=ITALY

This looks to be configured the same way your 7.1.6 URL is. I didn't SET anything or add any code beyond what the GUI created.

Dan


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
 
Posts: 393 | Location: St. Paul, MN | Registered: November 06, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
After a few days of testing, here's what I found out. I am using a freshly-built PC to do all my testing (didn't want to mess something up with my DevStudio install). On that PC, the Acrobat Reader and Excel open in their own windows, instead of opening with the browser plug-in. For whatever reason, if they do not open in the browser, the http: // portion of the URL becomes file: ///. Don't know why - seems like if it can be opened two different ways that WF should work for both of those ways. That's an easy-enough work-around (at least for us) but seems like a bug to me. Everything works OK as long as everything opens in the browser using plug-in helper apps.

What's more, I found that simply adding the SET FOCEXURL=http: //servername/ibi_apps/WFServlet into the focexec causes should ONLY be used for drilling to server procedures because it causes all the MR information to be lost.

I am still pursuing a full resolution through tech support but there's an answer for now (kind of).


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
ERINP
Platinum Member
posted Hide Post
Darin,
I was wondering if you ever resolved this issue. I am working with a similar problem and was curious to know if this was ever "truelly" solved? I am trying to allow for a drilldown in excel to another fex. If the excel spreadsheet is saved the drilldowns don't seem to work. I have also noticed the different URL's being used depending on where the report is being ran from...sometimes it is http://ibi_apps and other times it is C:///. If the URL is of http:// then the links seem to be "savable" but if it is the C:/// then they DO NOT work. Any ideas?

This message has been edited. Last edited by: ERINP,


WebFOCUS 7.6.9

Reporting client Windows 2003 Service pack 2 using IIS and TomCat 5.5
Reporting Server OS/400 V5R4M0
Outputs: HTML, Excel, PDF, CSV, and Flat Files
 
Posts: 130 | Location: Columbus, Ohio | Registered: February 25, 2009Report This Post
Tracey
Member
posted Hide Post
I'm having the same issue with Excel and drilldowns too. It only happens in Excel - all other formats work fine. If someone has some any ideas, please pass them my way!

WebFocus 7.6.10


On 7.6.10 Windows - all output formats
 
Posts: 8 | Registered: April 03, 2007Report This Post
<JG>
posted
Normally when you create a drilldown using FOCEXEC the link is generated as a relative URL
which requires the PDF or Excel to open in the browser.

When opened directly in the application any incomplete URL is always rendered as either file:///
or if you have saved it as x::/// where x is the drive you saved it to.

SET FOCEXURL =http://host/ibi_apps/WFServlet

forces a full url for none MRE drilldowns so they will open correctly

For MRE there is no equivalent to FOCEXURL so the best option is actually create the drilldown as a URL drilldown

for example for a none MRE drilldown

FOCEXEC=app/drill2(COUNTRY=N1),$

would become

URL=http://localhost/ibi_apps/WFServlet?(\
IBIF_ex='drill2' MODEL=N3),$


For MRE using Dans example it would be
 
URL=http://servername:port/ibi_apps/WFServlet?(\
IBIF_webapp=/ibi_apps \
IBIC_server=EDASERVE \
IBIWF_msgviewer=OFF \
&|IBIMR_drill=X,powersys/powersys.htm \
IBIF_ex=app/car2 \
CLICKED_ON= \
COUNTRY=ITALY \
),$


note any global vars need coding as &|


You can add in parameters you need based on the above example
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED PARTIALLY] WF7.6.9 and FOCEXURL

Copyright © 1996-2020 Information Builders