Patrick Huebgen
-
Posts
439 -
Joined
-
Last visited
-
Days Won
55
Community Answers
-
Patrick Huebgen's post in How do you do a HyperLink in Designer was marked as the answer
You can add links to the repository and you can add those items to link tiles
if you need link lists you can create a report or custom html pages
-
Patrick Huebgen's post in How can one set Schedule Status of all DM flows to "Inactive" from Web Console was marked as the answer
There's some code in the fex to control the scheduler
-*DM_LOG=5 -*DM_SCHDCODE=110000000009530000000000000000000000000000000000000 -*DM_SCHDSTRT=202505270953 -**Scheduler Type : Run Once. -**Scheduler Start : 2025/05/27 09:53:00 -**Log Destinations : ETLLOG, E-Mail -*DM_REQ_ACT=I
-
Patrick Huebgen's post in Using a COMPUTE field in a WHERE clause was marked as the answer
@Franco Simone COMPUTE in WHERE will not work - Master file based COMPUTE in WHERE TOTAL should work.
If you are using WHERE TOTAL - this is the WebFOCUS version of HAVING - and you still get an error ...
I saw an issue with one version of WebFOCUS that caused error messages - you might want to open a ticket to make sure this is not what is causing the problem
-
Patrick Huebgen's post in Hotfixes was marked as the answer
@Erin Trotter this depends - there are different type of hotfixes.
Some hotfixes are full reporting server install packages - for those you will only need the latest.
Others, like any client hotfix and some (rarely) server fixes will ask you to manually replace files - for those you should start with the oldest and apply each hotfix - sometimes you will replace the same file again and again but it's still easier then trying to determine which file is is multiple packages.
-
Patrick Huebgen's post in Offline Page was marked as the answer
You want to check if the database server is down or the Reporting Server?
In general you can check for error messages in WebFOCUS
TABLE FILE CAR PRINT SALES BY COUNTRY ON TABLE HOLD END -RUN -IF &FOCERRNUM NE 0 THEN GOTO HANDLE_ERROR; -* Continue with normal processing if no error -TYPE Successful execution. -EXIT -HANDLE_ERROR -TYPE An error occurred! Error number: &FOCERRNUM -* You can add more sophisticated error handling here -EXIT
-
Patrick Huebgen's post in HTML visualization filter passes a PDF report was marked as the answer
As discussed sharing some code to create an additional custom button to be added to the page
-SET &DF_WH_PRODUCT_CATEGORY = &DF_WH_PRODUCT_CATEGORY.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN retail_samples/wf_retail |FORMAT=A40V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY)).Product Category.; -SET &DF_WH_PRODUCT_SUBCATEG = &DF_WH_PRODUCT_SUBCATEG.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG IN retail_samples/wf_retail |FORMAT=A50V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG,WITHIN=DF_WH_PRODUCT_CATEGORY)).Product Subcategory.; -SET &DF_WH_WF_RETAIL_WF_RETAIL_TIME_SALES_TIME_YEAR = &DF_WH_WF_RETAIL_WF_RETAIL_TIME_SALES_TIME_YEAR.(OR(FIND WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_YEAR IN retail_samples/wf_retail |FORMAT=I4,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_YEAR)).Sale Year.; -HTMLFORM BEGIN <!DOCTYPE html> <html> <body> <h2>Just a simple test</h2> <button onclick="myFunction()">Test Parameters</button> <BR> <a href="http://webfocus.local:8080/ibi_apps/run.bip?BIP_REQUEST_TYPE=BIP_RUN&|BIP_folder=IBFS%253A%252FWFC%252FRepository%252FMy_Workspace%252F~admin%252F&|BIP_item=heading.fex&|DF_WH_PRODUCT_CATEGORY=!IBI.AMP.DF_WH_PRODUCT_CATEGORY;" target='_blank')">Klick hier!</a> <script> function myFunction() { alert("values: \n !IBI.AMP.DF_WH_PRODUCT_CATEGORY; \n !IBI.AMP.DF_WH_PRODUCT_SUBCATEG; \n !IBI.AMP.DF_WH_WF_RETAIL_WF_RETAIL_TIME_SALES_TIME_YEAR; "); } </script> </body> </html> -HTMLFORM END
-
Patrick Huebgen's post in FEX Odometer and NO DATA AVAILABLE FOR THE CHART was marked as the answer
Here's a sample
-SET DF_WH_PRODUCT_CATEGORY=''Wrong''; -SET &ECHO=ALL; TABLE FILE retail_samples/wf_retail SUM WF_RETAIL.WF_RETAIL_SALES.DISCOUNT_US WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &DF_WH_PRODUCT_CATEGORY.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN retail_samples/wf_retail |FORMAT=A40V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY)).Product Category.; ON TABLE HOLD AS TEST END -RUN -IF &RECORDS EQ 0 GOTO NOTHING_FOUND; ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD SET SQUEEZE=ON -DEFAULTH &WF_HTMLENCODE=ON; SET HTMLENCODE=&WF_HTMLENCODE SET HTMLCSS=ON -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT -DEFAULTH &WF_EMBEDHEADING=ON; SET EMBEDHEADING=&WF_EMBEDHEADING SET GRAPHDEFAULT=OFF -DEFAULTH &WF_UNITS=INCHES; SET UNITS=&WF_UNITS -DEFAULTH &WF_STYLE_UNITS='INCHES'; -DEFAULTH &WF_STYLE_HEIGHT='4.21875'; -DEFAULTH &WF_STYLE_WIDTH='8.020833'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; -DEFAULT &DF_WH_PRODUCT_CATEGORY = _FOC_NULL; SET ARVERSION=2 -DEFAULTH &WF_STYLE_UNITS='INCHES'; -DEFAULTH &WF_STYLE_HEIGHT='4.21875'; -DEFAULTH &WF_STYLE_WIDTH='8.020833'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE retail_samples/wf_retail -* Created by Designer for Graph SUM WF_RETAIL.WF_RETAIL_SALES.DISCOUNT_US WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ &DF_WH_PRODUCT_CATEGORY.(OR(FIND WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY IN retail_samples/wf_retail |FORMAT=A40V,COMPARATOR=EQ,SORT=ASCENDING,FIELDNAME=WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY)).Product Category.; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET GRAPHCVTUNITS ON ON GRAPH SET LOOKGRAPH GAUGE ON GRAPH SET EMBEDHEADING ON ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * INCLUDE=IBFS:/WFC/Global/Themes/Standard/Default/theme.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', ARGRAPHENGINE=JSCHART, $ TYPE=DATA, COLUMN=N1, BUCKET=measure, $ *GRAPH_SCRIPT *GRAPH_JS_FINAL "gaugeProperties": { "layout": "simple", "startAngle": 270.0, "endAngle": 270.0 } *END ENDSTYLE END -GOTO THE_END; -NOTHING_FOUND ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD SET SQUEEZE=ON -DEFAULTH &WF_HTMLENCODE=ON; SET HTMLENCODE=&WF_HTMLENCODE SET HTMLCSS=ON -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT -DEFAULTH &WF_EMBEDHEADING=ON; SET EMBEDHEADING=&WF_EMBEDHEADING SET GRAPHDEFAULT=OFF -DEFAULTH &WF_UNITS=INCHES; SET UNITS=&WF_UNITS -DEFAULTH &WF_STYLE_UNITS='INCHES'; -DEFAULTH &WF_STYLE_HEIGHT='4.21875'; -DEFAULTH &WF_STYLE_WIDTH='8.020833'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; -DEFAULT &DF_WH_PRODUCT_CATEGORY = _FOC_NULL; SET ARVERSION=2 -DEFAULTH &WF_STYLE_UNITS='INCHES'; -DEFAULTH &WF_STYLE_HEIGHT='4.21875'; -DEFAULTH &WF_STYLE_WIDTH='8.020833'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE retail_samples/wf_retail -* Created by Designer for Graph SUM COMPUTE NIX/D20 MISSING ON= IF PRODUCT_CATEGORY EQ 'Camcorder' THEN '' ELSE '' ; WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY EQ 'Camcorder' ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET GRAPHCVTUNITS ON ON GRAPH SET LOOKGRAPH GAUGE ON GRAPH SET EMBEDHEADING ON ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * INCLUDE=IBFS:/WFC/Global/Themes/Standard/Default/theme.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET='*', ARGRAPHENGINE=JSCHART, $ TYPE=DATA, COLUMN=N1, BUCKET=measure, $ *GRAPH_SCRIPT *GRAPH_JS_FINAL "gaugeProperties": { "layout": "simple", "startAngle": 270.0, "endAngle": 270.0 } *END ENDSTYLE END -THE_END
-
Patrick Huebgen's post in Percentages in Subfoot using column notation was marked as the answer
There are some limitations here's a more complex sample
TABLE FILE CAR SUM CAR.BODY.SEATS CAR.BODY.SALES CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR BY CAR.CARREC.MODEL ON CAR.ORIGIN.COUNTRY RECOMPUTE CNT. 'CAR.BODY.SEATS' ASQ. 'CAR.BODY.DEALER_COST' FST. 'CAR.BODY.RETAIL_COST' AS '*TOTAL' ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE END
-
Patrick Huebgen's post in WebFOCUS Debugging - how to use session monitor (Video) was marked as the answer
Time for a new Tips & Tricks video about ibi | Information Builders WebFOCUS Debugging - how to use session monitor
-
Patrick Huebgen's post in Designer Vizualizations and URL's - Best Format for URL was marked as the answer
@Gene Gauthier i personally prefer biprun but REST is documented and therefore "more standard"
-
Patrick Huebgen's post in Help ? mark icons don't work in Webfocus was marked as the answer
For offline help download
https://docs.tibco.com/pub/wf-wf/9.3.1/doc/html/Default.htm
or
https://docs.tibco.com/pub/wf-wf/9.3.2/doc/html/Default.htm
button "Download Help"
Create those folder for tomcat
Extract content form zip file into "wf" folder
do the same for the server offline help
"Download Help" here
https://docs.tibco.com/pub/wf-rs/9.3.1/doc/html/Default.htm
https://docs.tibco.com/pub/wf-rs/9.3.2/doc/html/Default.htm
just extract the "html" folder content into the "rs" folder
restart your Tomcat
-
Patrick Huebgen's post in How to configure Default Custom Theme for Designer was marked as the answer
@Clinton Etheridge Just send you a direct message - as there are multiple ways to achieve what you are looking for
-
Patrick Huebgen's post in GIS_POINT was marked as the answer
@Alex Huguet Perez They are "malformated" For example numbers for center of city of Rome would be
"x":41.900961799187286, "y":12.48580465847452
but there's for sure a decimal separator missing
Please check https://webfocusinfocenter.informationbuilders.com/wfappent/TL3s/TL_server/source/gis_point.htm
for more background
-
Patrick Huebgen's post in Windows authentication SSO on tomcat port 8080 was marked as the answer
I wonder why you cannot use port 80
Usually most firewalls prefer those standard ports - but yes if the port is the problem you can reconfigure IIS to use a different port - just make sure to first change the Tomcat port to something outside 8080
for instructions on changing IIS just Google for iis change port
-
Patrick Huebgen's post in WebFOCUS Portals - Folders in Sub-Folders was marked as the answer
@rueben_ramirez levels are the same in 9.3 - the new capability is a portal editor on top of the existing portal capabilities.
-
Patrick Huebgen's post in Unable to authenticate to the WebFocus home page was marked as the answer
@Erin Trotter for urgent requests please open a ticket.
"I can log in there with my AD credentials and see everything I am supposed to see." the audit log shows that the user cannot login at all in the client as the user is not registered.
I guess you can logon to the server console (port 8121) - if this is the case this would indicated that you did not configured the trusted connection between server and client.
To get you into the client to be able to configure security you can add and IBI_ADMIN_NAME and IBI_ADMIN_PASS to webfocus.cfg
Some documentation here https://docs.tibco.com/pub/wf-wf/9.2.3/doc/pdf/IBI_wf-wf_9.2.3_security_administration.pdf
Having done so please restart and make sure to complete the security setup and use this user independent from the AD security to fix potential security issues.
-
Patrick Huebgen's post in Assemble a visualization page with a link within a report in one container opening html content on another container in the visualization page was marked as the answer
@Erin Trotter - created a short tutorial for you -
-
Patrick Huebgen's post in Adding Median line to Bar Chart was marked as the answer
@Kiran Kethineni Not built in feature but easy - just create a new computed field in Designer, Info Assist or Code like this and add it to the chart as line
PARTITION_AGGR( YOUR_MEASURE_HERE , TABLE , B , E , MEDIAN)
More details here
https://docs.tibco.com/pub/wf-wf/9.2.2/doc/pdf/IBI_wf-wf_9.2.2_functions.pdf?id=14
-
Patrick Huebgen's post in Globally referencing a Stylesheet in 8207.28 was marked as the answer
@Doug Monson Please try to put the command in a client profile instead of edasprof
all type of settings and other language commands are part of my universal profile
-
Patrick Huebgen's post in Is it possible to allow an InfoAssist user to access a mas file while preventing another InfoAssist user to use this mas file to generate new content? was marked as the answer
"Yes you can" - server security allows you to setup security based on folders or files "Directory/File Priviledges"
-
Patrick Huebgen's post in Changes required in cloned server to configure it as standalone environment. was marked as the answer
You can install an additional configuration and then migrate all settings.
To clone the config - you can clone your repository (using the repository tool or the database administration tool - depends on your database and preferences).
For the configuration you can manually cehcek the config on both systems or use a tool to compare and merge the config files (I usually use Winmerge - to merge those changes.
You need to do this for the config files in
WebFOCUS Client WebFOCUS Server Apache Tomcat ReportCaster config is stored in repository - so cloning the repository will take care - but you need to change some settings to make sure they fit for the new system.
-
Patrick Huebgen's post in Anyone else having an issue where selected theme in InfoAssist is not being applied to the report? was marked as the answer
I was able to reproduce this in my 9.11 release but in 9.21 it worked fine - please open a ticket to see which version will fix this - I have no 9.12 release to test
-
Patrick Huebgen's post in Is WAR files kept in webapps folder is required post installation? was marked as the answer
just for clarification - if you confirmed step 4 from above link
4 Open xxx:ibitomcatconfCatalinalocalhostibi_apps.xml. If docBase does not include .war, your testing is complete.
You are safe to delete the war files
-
Patrick Huebgen's post in How can I onclick on a container on a page and open a new page on a new tab? was marked as the answer
Did you looked into "Link Tile" instead of a regular container?
https://kb.informationbuilders.com/topic/linking-external-content-page-8207
-
Patrick Huebgen's post in [SOLVED] How can I execute custom javascript in WebFocus 9.1.1 to send an API call to Snowflake was marked as the answer
You can create a Snowflake procedure ike this sample with JavaScript
CREATE OR REPLACE PROCEDURE my_test_1(
VALUE1 double,
VALUE2 double
)
returns double
language javascript
strict
execute as caller
as $$
var result = VALUE1 + VALUE2;
return result;
$$;
and create a WebFOCUS Report like this:
-SET &value1 = 5;
-SET &value2 = 2;
ENGINE SQLSNO SET DEFAULT_CONNECTION <NAME_OF_YOUR_CONNECTION_HERE>
SQL SQLSNO EX <ADD_TABLE_SCHEMA_HERE>.my_test_1 &value1, &value2;
TABLE FILE SQLOUT
PRINT *
END
-RUN
Instead of sending the values via SET you can of course create a Designer form to send the parameters from a prompt.
Patrick
