I have a graph that needs to do a drill according to the slice you click... how can i get the value??

Here is the code of the graph

TABLE FILE F_QLTY_MEDERROR
SUM
'CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
AS 'COUNT,F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
'F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
BY 'F_QLTY_MEDERROR.D_TIME.TIME_YEAR'
BY 'F_QLTY_MEDERROR.D_STAFF.STAFF_TYPE'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS RMSC FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
COLOR='WHITE',
BACKCOLOR=RGB(189 196 193),
STYLE=BOLD,
$
TYPE=TITLE,
SIZE=12,
COLOR='WHITE',
BACKCOLOR=RGB(0 0 139),
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=20,
COLOR='NAVY',
STYLE=BOLD,
$
TYPE=FOOTING,
COLOR='WHITE',
BACKCOLOR='NAVY',
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLOR='NAVY',
BACKCOLOR=RGB(189 196 193),
$
ENDSTYLE
END
-*INTERNAL_PROPERTIES$fieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$enablePreview=true;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$prefixDisplayMode=;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
GRAPH FILE RMSC
-* Created by Advanced Graph Assistant
SUM RMSC.RMSC.ERROR_LEVEL
BY RMSC.RMSC.TIME_YEAR
ACROSS HIGHEST 4 RMSC.RMSC.STAFF_TYPE
WHERE RMSC.RMSC.TIME_YEAR GE 2009;
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIEBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendMarkerPosition(1);
setScaleMinAuto(getY1Axis(),false);
setTextString(getY1Title(),"Error Level");
setDisplay(getY1Title(),true);
restoreAllSlices();
setTextString(getTitle(),"Medical Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Staff");
setDisplay(getSubtitle(),true);
setLegendSeriesCount(0);
setLegendMarkersPerRow(0);
setDisplayOffScale(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),300.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),80.0);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=lvm_mestaffgraphdrillquarter(Year=RMSC.RMSC.TIME_YEAR), $
ENDSTYLE
END

and the code of the drill down graph i want to get..


TABLE FILE F_QLTY_MEDERROR
SUM
'CNT.F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
AS 'COUNT,F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
'F_QLTY_MEDERROR.F_QLTY_MEDERROR.ERROR_LEVEL'
BY 'F_QLTY_MEDERROR.D_TIME.TIME_YEAR'
BY 'F_QLTY_MEDERROR.D_TIME.TIME_QUARTERNAME'
BY 'F_QLTY_MEDERROR.D_STAFF.STAFF_TYPE'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS RMSC FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
COLOR='WHITE',
BACKCOLOR=RGB(189 196 193),
STYLE=BOLD,
$
TYPE=TITLE,
SIZE=12,
COLOR='WHITE',
BACKCOLOR=RGB(0 0 139),
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=20,
COLOR='NAVY',
STYLE=BOLD,
$
TYPE=FOOTING,
COLOR='WHITE',
BACKCOLOR='NAVY',
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLOR='NAVY',
BACKCOLOR=RGB(189 196 193),
$
ENDSTYLE
END
GRAPH FILE RMSC
-* Created by Advanced Graph Assistant
SUM RMSC.RMSC.ERROR_LEVEL
BY RMSC.RMSC.TIME_QUARTERNAME
ACROSS HIGHEST 4 RMSC.RMSC.STAFF_TYPE
WHERE RMSC.RMSC.TIME_YEAR GE 2009;
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIEBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendMarkerPosition(1);
setScaleMinAuto(getY1Axis(),false);
setTextString(getY1Title(),"Error Level");
setDisplay(getY1Title(),true);
restoreAllSlices();
setTextString(getTitle(),"Medical Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Staff");
setDisplay(getSubtitle(),true);
setLegendSeriesCount(0);
setLegendMarkersPerRow(0);
setDisplayOffScale(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),300.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),50.0);
ENDSTYLE
END

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

First of all, you need to have at least a single, if not more, WHERE clause in your child graph.

Then in your parent graph, you should be able to set up the drill right in the GUI tool which you seem to be using. From that tool, you can specify which values to want to send to the child program.

Ok..I've added the WHERE clause..but still..when I pass to the child graph I get the error of not having the WHERE value...

this is the child graph modified...

GRAPH FILE RMSC
-* Created by Advanced Graph Assistant
SUM RMSC.RMSC.ERROR_LEVEL
BY RMSC.RMSC.TIME_QUARTERNAME
ACROSS HIGHEST 4 RMSC.RMSC.STAFF_TYPE
WHERE RMSC.RMSC.TIME_YEAR GE 2009;
WHERE RMSC.RMSC.TIME_YEAR EQ '&TIME_YEAR.(FIND RMSC.RMSC.TIME_YEAR IN RMSC).Time_year:.';
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIEBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendMarkerPosition(1);
setScaleMinAuto(getY1Axis(),false);
setTextString(getY1Title(),"Error Level");
setDisplay(getY1Title(),true);
restoreAllSlices();
setTextString(getTitle(),"Medical Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Staff");
setDisplay(getSubtitle(),true);
setLegendSeriesCount(0);
setLegendMarkersPerRow(0);
setDisplayOffScale(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),300.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),50.0);
ENDSTYLE
END

I have attempted to reproduce your situation but I'm not sure that you are going to like it. First off, you can only drill on a measure in a graph, not a dimension as you are doing. But I did get it to work a bit. Secondly, it makes more sense to screen on the variable passed in the TABLE request of the child program, not the graph. Also notice that I did the BY HIGHEST 4 in both programs in the TABLE as well as the graph to reduce the number of points earlier in the process. For what it is worth, here is my code:

-* File centsales_graph_parent_drill.fex
SET ASNAMES=ON
TABLE FILE CENTURYSALES
SUM RETURNS AS ERROR_LEVEL
BY YEAR AS TIME_YEAR
-*BY PLANTNAME
BY HIGHEST 4 PRODUCTCATEGORY AS STAFF_TYPE
WHERE PLANTNAME EQ 'Boston'
ON TABLE HOLD AS RMSC FORMAT ALPHA
END
GRAPH FILE RMSC
-* Created by Advanced Graph Assistant
SUM RMSC.RMSC.ERROR_LEVEL
BY RMSC.RMSC.TIME_YEAR
ACROSS HIGHEST 4 RMSC.RMSC.STAFF_TYPE
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIEBAR
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendMarkerPosition(1);
setScaleMinAuto(getY1Axis(),false);
setTextString(getY1Title(),"Error Level");
setDisplay(getY1Title(),true);
restoreAllSlices();
setTextString(getTitle(),"Medical Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Staff");
setDisplay(getSubtitle(),true);
setLegendSeriesCount(0);
setLegendMarkersPerRow(0);
setDisplayOffScale(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),300.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),80.0);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=centsales_graph_drill(Year=TIME_YEAR), $
ENDSTYLE
END

-* And the child or drilled to program:
-* File centsales_graph_drill.fex
-? &
-*-EXIT
SET ASNAMES=ON
TABLE FILE CENTURYSALES
SUM RETURNS AS ERROR_LEVEL
BY YEAR AS TIME_YEAR
BY QUARTER AS TIME_QUARTERNAME
BY HIGHEST 4 PRODUCTCATEGORY AS STAFF_TYPE
WHERE PLANTNAME EQ 'Boston'
-*WHERE RMSC.RMSC.TIME_YEAR GE 2009;
WHERE YEAR EQ '&Year'
ON TABLE HOLD AS RMSC FORMAT ALPHA
END
GRAPH FILE RMSC
-* Created by Advanced Graph Assistant
SUM ERROR_LEVEL
BY TIME_QUARTERNAME
ACROSS HIGHEST 4 STAFF_TYPE
-*WHERE RMSC.RMSC.TIME_YEAR GE 2009;
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIEBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPieDepth(10);
setPieFeelerTextDisplay(1);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setLegendMarkerPosition(1);
setScaleMinAuto(getY1Axis(),false);
setTextString(getY1Title(),"Error Level");
setDisplay(getY1Title(),true);
restoreAllSlices();
setTextString(getTitle(),"Medical Error");
setDisplay(getTitle(),true);
setTextString(getSubtitle(),"By Staff");
setDisplay(getSubtitle(),true);
setLegendSeriesCount(0);
setLegendMarkersPerRow(0);
setDisplayOffScale(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),300.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),50.0);
ENDSTYLE
END

Good luck!

Thank you so much..
Your code clear my doubts

Also notice, as I forgot to mention this, in your stylesheet drill syntax, you said "Year=". Well, then &Year has to be the name of the amper variable checked in the child program, not &TIME_YEAR.

haha yes i noticed that