I am creating a drilldown bar graph. Each bar in the graph is a hyperlink that runs a fex in the background with a different amper variable. The first time one of the bars is clicked, it runs the background fex fine. However, if I do it again, it doesn't run the fex again... it just pops up the same output as the first time. Is there a way to make sure that every time the bar is clicked, the fex is run again as if it had never been run before?

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

I have a similar graph and drill-down fex that works correctly. What do you mean by "background"?

Are you running the fex in MRE, Dashboard or DevStudio or is it self-service?

More details would help.

graphgui1.fex:

GRAPH FILE CAR
SUM SALES DEALER_COST RETAIL_COST
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setAxisAssignment(2,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     TARGET='_blank',
     FOCEXEC=graphgui1dd.fex(COUNTRY=A1 TYPE='SALES'),
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     TARGET='_blank',
     FOCEXEC=graphgui1dd.fex(COUNTRY=A1 TYPE='DEALER_COST'),
$
TYPE=DATA,
     ACROSSCOLUMN=N3,
     TARGET='_blank',
     FOCEXEC=graphgui1dd.fex(COUNTRY=A1 TYPE='RETAIL_COST'),
$
ENDSTYLE
END

graphgui1dd.fex:

-DEFAULT &COUNTRY='FOC_NONE';
-DEFAULT &TYPE='COUNTRY';

TABLE FILE CAR
PRINT *
BY &TYPE
WHERE COUNTRY EQ '&COUNTRY';
END
-RUN

Keep in mind that a call from the graph is a web call, and you will be constrained by the browser, web server.

This is probably a caching issue.

The simple solution is to have a random number in the call that makes it unique.

Yeah, I've got this at the top of each of my fexes:

-SET &CLEARCACHE = &YYMD || &TOD ;

Apparently it isn't enough to just set it though... I've got to pass it to the following fex, I guess. Not sure.

Yes you are right, it must be passed to the nex fex.

You can do this by adding the variable to the fex call.
FOCEXEC=drill(parm1=field rand='&CLEARCACHE')

You may still have issues if the drill data is moving, and you drill down, use the back button, then drill again, because your variable CLEARCACHE has not changed.