Hello,

I have two fex files. One is creating a drop down box that i"m using in my banner as a filter.
The second fex file I want to use in the page portion of my dashboard.

how do I join the two together. So when I select a value in the drop down how do i get it to pass to the page and display the correct information?

Thanks for the help.

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

Do you have code you could share with us? Also, what tools are you using to build your dashboard? InfoAssist? AppStudio? Portal Designer? Etc.?

You should be able to create filters that work responsively within AppStudio, using them to pass to a portal page of content panels that need to resolve the values therefrom.

Try looking into creating page filters with AppStudio for use in a BI Portal (using the Portal Designer), since you're using 8.1.04 as it were.

When I go to my htmlpage Requests & Data Sources and

I don't have the requests -> Parameters -> Filter Panel option.
I only have the requests -> Parameters -> Controls option.

Yeah, I think that's only in 8.2.xx. You'll have to look into upgrading to such. Sorry! Them's the breaks of 3rd party solutions though. Our site has had to learn that the hard way.

What I would do in your shoes, if you can't upgrade, is look into getting a hold of the RDF templates CM package for the 8.1 era of releases. Best solution while you're stuck in 8.1.

FEX File 1 accepts the user and pulls their fleet # per their userinitials. It then populates the fleet #'s into a drop down list. I then put this drop down in the banner of my portal.

Fex file 2: then SHOULD take the fleet # selected in the drop down and create the report. I just need to figure out how to pass this fleet # from the drop down to the fex file 2.

Fex file 1:

 APP HOLD metricsdash

ENGINE SQLSYB SET DEFAULT_CONNECTION SYBASE

SQL SQLSYB
-*EX mastersys..GetFleetByInitialsOrID '&USERINITIALS';
EX mastersys..GetFleetByInitialsOrID '&FOCSECUSER';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MDUSERFLEETDEV
END

SET HOLDLIST=PRINTONLY
TABLE FILE MDUSERFLEETDEV
BY     fleetId
BY     initials
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MDGETFLEETDEV FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN

TABLE FILE MDGETFLEETDEV
WHERE fleetId EQ &fleetId.(FIND fleetId IN MDGETFLEETDEV).fleetId:.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN
 

FEX FILE 2:

 ENGINE SQLSYB SET DEFAULT_CONNECTION SYBASE
APP HOLD METRICSDASH

-*-DEFAULTH &fleetId = '143';
-DEFAULT &fleetId;


SQL SQLSYB
EX reporting..MDFleetTruckMiles;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MDFTM
END

TABLE FILE MDFTM
SUM CNT.MDFTM.MDFTM.csrType AS 'CountCSRType'
BY  LOWEST MDFTM.MDFTM.csrType
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MDCNTCSRTYPE FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
JOIN
 FILE mdftm AT MDFTM.MDFTM.csrType TO MULTIPLE FILE mdcntcsrtype
 AT MDCNTCSRTYPE.SEG01.csrType TAG J0 AS J0
 WHERE MDFTM.MDFTM.csrType EQ J0.SEG01.csrType;
 END
TABLE FILE MDFTM
PRINT
     MDFTM.MDFTM.fleetId
     J0.SEG01.COUNTCSRTYPE


BY LOWEST MDFTM.MDFTM.csrType
	RANKED BY TOTAL HIGHEST COMPUTE milestrk/D12.2 = MDFTM.MDFTM.truckMiles / MDFTM.MDFTM.trucks;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MDFLEETTRUCKMILES FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=TABHEADING,
     LINE=1,
     JUSTIFY=LEFT,
$
ENDSTYLE
END
TABLE FILE MDFLEETTRUCKMILES
HEADING
"Miles/Truck"
"<MDFLEETTRUCKMILES.SEG01.milestrk"
" "
"<MDFLEETTRUCKMILES.SEG01.RANK /<MDFLEETTRUCKMILES.SEG01.COUNTCSRTYPE"
"Rank"
WHERE fleetId EQ &fleetId; -*.(OR(FIND fleetId IN MDFLEETTRUCKMILES)).fleetId:.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     FONT='TREBUCHET MS',
     SIZE=9,
     COLOR='WHITE',
     BACKCOLOR='NONE',
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     SIZE=12,
     COLOR=RGB(32 135 238),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=10,
     WIDTH=1.250,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=16,
     WIDTH=1.250,
$
TYPE=HEADING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=6,
     JUSTIFY=LEFT,
     WIDTH=1.250,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=8,
     WIDTH=.250,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=8,
     JUSTIFY=RIGHT,
     WIDTH=.500,
$
TYPE=HEADING,
     LINE=4,
     OBJECT=FIELD,
     ITEM=2,
     SIZE=8,
     JUSTIFY=LEFT,
     WIDTH=.500,
$
TYPE=HEADING,
     LINE=5,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=7,
     WIDTH=1.250,
$
ENDSTYLE
END
 

If I were in your shoes, working in the 8.1 release, desiring what you currently do, I would do the following:

- Create a fex similar to your fex #1 but output the display and return value desired in your dropdown to XML via a statement like ON TABLE PCHOLD FORMAT XML;
- Within AppStudio, use the HTML Canvas/Composer tool to build out your filtering controls in a form that submits to a BIP;
- In the desired dropdown control, populate it with your XML output from fex #1 tying the return value to an amper variable named after the unresolved self-same variable value in your fex #2;
- In Portal Designer, drop your filtering form HTML page in the banner;
- Then drop your fex #2 content into whatever page and panel you wanted it in, and Save.
- Run the portal with both in place and it should function as long as you've specified the correct target for your filter page under the Tasks & Animations panel, and your content requires the variable values being passed from your filter page (variables must be named the same).

Hope that helps jump start ya.