The run button is what controls whether the variables will be global to the portal. This is based on the Request action of Refresh and Target type of Refresh BI Portal on the tasks and animations tab for the run button.
Hope this helps
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 13, 2017, 03:59 PM
AMC
Thanks for your responses. Let me look at these steps Chaudhary, and if I have other questions, I can post.
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 14, 2017, 01:40 PM
AMC
So theses steps are kind of similar to adding filters for regular pages. I stepped through the example and the steps for it. I added all filters to the template page, but none of the selections for the filters seem to be working. The values are not changing on the charts and reports. Any ideas Chaudhary or anyone?
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 14, 2017, 02:41 PM
FP Mod Chuck
AMC
You may need to post the code, but one thought is that maybe the names of the parameters in the html don't match what the fex is expecting. Remember they are case sensitive...
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 14, 2017, 05:40 PM
AMC
This is the code for that first report used in the example for adding the filter. It's added to the first panel on the left.
TABLE FILE CAR HEADING CENTER " " "Open Orders" "SUM DEALER_COST AS 'Booking $' RETAIL_COST AS 'Booking/Open %' SALES2 AS 'Cubic Volume' ON TABLE PCHOLD FORMAT HTML ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE OFF ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, GRID=OFF, BORDER=OFF, BACKCOLOR=NONE, $
I noticed the same a Chaudhary that there is no WHERE statement in the code you posted. That would cause the results not to change...
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 15, 2017, 05:55 PM
AMC
Right I saw that as well, but shouldn't WHERE statements already be there for this example to work?
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 15, 2017, 07:53 PM
FP Mod Chuck
No you have to code them into the fex with the correct parameter names to match what you have defined in the html page.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 18, 2017, 09:58 AM
AMC
Ok, but I guess why doesn't the example take you through the process of creating the WHERE statements like it did for creating the parameters?
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 18, 2017, 11:02 AM
AMC
The parameters that the example steps you through to create are Region and Product. However, some of the reports and charts for this example have car as a data point.
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 18, 2017, 12:16 PM
FP Mod Chuck
AMC
Not sure I didn't create the sample but you should be able to change you html to use the car file and use COUNTRY and CAR instead..
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 18, 2017, 12:52 PM
AMC
Chuck W - Created a car parameter but it's not working like it should. I created a drop-down for it on html template and added the WHERE statement for it in one of the fexes so far.
I think the linking is off in the Parameters tab though. So when I run the html template, it gives me it's own drop-down parameter list for that specific report I created the WHERE for and it also puts a drop-down at the top of html template where I created it. However, that one does not control the filtering so something must be off in the linking I'm guessing.
WF 8.1.05 Windows SQL Server 2014 HTML, PDF, EXCEL
December 18, 2017, 02:43 PM
FP Mod Chuck
AMC
You are probably right.. I suggest opening a case with techsupport as they can do a WebEx with you to work through getting this working..
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats