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     [CLOSED] Filter Panels on RDF Templates

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Filter Panels on RDF Templates
 Login/Join
 
Platinum Member
posted
How do you include a global filter on the filter panels for the RDF templates?

This message has been edited. Last edited by: FP Mod Chuck,


WF 8.1.05
Windows
SQL Server 2014
HTML, PDF, EXCEL
 
Posts: 175 | Registered: March 24, 2017Report This Post
Platinum Member
posted Hide Post
quote:
RDF templates?

http://infocenter.informationbuilders.com


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Report This Post
Virtuoso
posted Hide Post
AMC

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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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.

-DEFAULTH &BACKCOLOR = 'rgb(240, 80, 80)';

-DEFAULTH &WF_TITLE = 'TITLE';
-SET &WF_SUMMARY = 'SUMMARY';

DEFINE FILE CAR
SALES2/D12.2M = SALES;
END

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, $

TYPE=HEADING, LINE=1, COLOR=WHITE, BORDER=OFF, SIZE=10, $
TYPE=HEADING, LINE=2, COLOR=WHITE, BORDER=OFF, SIZE=10, $
TYPE=HEADING, LINE=3, COLOR=WHITE, BORDER=OFF, SIZE=24, $
TYPE=HEADING, LINE=4, COLOR=WHITE, BORDER=OFF, $

TYPE=TITLE, COLOR=WHITE, BORDER=OFF, JUSTIFY=CENTER, BACKCOLOR=NONE, SIZE=8, $
TYPE=DATA, COLOR=WHITE, BORDER=OFF, JUSTIFY=CENTER, BACKCOLOR=NONE, SIZE=10, $
ENDSTYLE
END
-RUN

-SET &IBIAPPS = GETTOK(&FOCEXURL,&FOCEXURL.LENGTH,1,'/',64,'A64');
-SET &IBIAPPS = TRUNCATE(&IBIAPPS);
-HTMLFORM BEGIN
<script type="text/javascript" src="./jquery/js/jquery.min.js">
<script>
$('body').css( { 'background-color':'!IBI.AMP.BACKCOLOR;' } );
$('body > table').width( '100%' );
$('.x6').width( '33%' );

-HTMLFORM END


WF 8.1.05
Windows
SQL Server 2014
HTML, PDF, EXCEL
 
Posts: 175 | Registered: March 24, 2017Report This Post
Platinum Member
posted Hide Post
AMC ,
Please make sure that you are passing your global filters in you report's where statement.

Try this code and make a global filter parameter as CAR in you HTML page ,

  DEFINE FILE CAR
SALES2/D12.2M = SALES;
END

TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST AS 'Booking $'
     CAR.BODY.RETAIL_COST AS 'Booking/Open %'
     CAR.BODY.SALES2 AS 'Cubic Volume'
HEADING
" "
"Open Orders"
WHERE CAR.COMP.CAR EQ &CAR.(OR(FIND CAR IN car)).CAR.;
ON TABLE SET HTMLENCODE OFF
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=DATA,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     SIZE=10,
     BACKCOLOR='NONE',
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     SIZE=8,
     BACKCOLOR='NONE',
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
$
TYPE=HEADING,
     LINE=2,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
$
TYPE=HEADING,
     LINE=3,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     SIZE=24,
$
TYPE=HEADING,
     LINE=4,
     BORDER-TOP=OFF,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=OFF,
     BORDER-RIGHT=OFF,
     COLOR='WHITE',
$
ENDSTYLE
END
-RUN


-SET &IBIAPPS = GETTOK(&FOCEXURL,&FOCEXURL.LENGTH,1,'/',64,'A64');
-SET &IBIAPPS = TRUNCATE(&IBIAPPS);
-HTMLFORM BEGIN
<script type="text/javascript" src="./jquery/js/jquery.min.js">
<script>
$('body').css( { 'background-color':'!IBI.AMP.BACKCOLOR;' } );
$('body > table').width( '100%' );
$('.x6').width( '33%' );

-HTMLFORM END

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


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
 
Posts: 186 | Location: Infobuild India | Registered: August 28, 2015Report This Post
Virtuoso
posted Hide Post
AMC

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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 175 | Registered: March 24, 2017Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report 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     [CLOSED] Filter Panels on RDF Templates

Copyright © 1996-2020 Information Builders