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,

quote:

RDF templates?

http://infocenter.informationbuilders.com

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

Thanks for your responses. Let me look at these steps Chaudhary, and if I have other questions, I can 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?

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...

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

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,

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...

Right I saw that as well, but shouldn't WHERE statements already be there for this example to work?

No you have to code them into the fex with the correct parameter names to match what you have defined in the html page.

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?

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.

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..

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.

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..