I've created a "basic pie graph" with the graph assistant.

It's a sum of Sales by Facility. When I hover over a 'slice' of the pie graph, it shows the Facilty Code and the total Sales amount, then when I click on it to drill down into a report that I've specified it passes an entirely different Facility value!

I hover and it shows "HC $4,700" and I click on the "HC" slice and it shows a report for facility "NE"

First time I've seen this, is it something obvious?
Here's the code if it helps anything.

GRAPH FILE D_EXECUTIVE_FACILITY_PIE_VW
SUM SALES
ACROSS FACILITY_CODE
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 275
ON GRAPH SET HAXIS 325
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);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),10);
setPieFeelerTextDisplay(2);
setPieLabelDisplay(0);
setReverseSeries(true);
setTextFormatPreset(getPieSliceLabel(),8);
setLegendDisplay(true);
setFootnoteString("MTD Sales by Facility");
setTextJustHoriz(getFootnote(),1);
setFontSizeAbsolute(getFootnote(),true);
setFontSize(getFootnote(),12);
setFontStyle(getFootnote(),3);
setTextRotation(getFootnote(),0);
setTextWrap(getFootnote(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBIColorToWhite.txt");
setPlaceResize(getSubtitle(),0);
setPlaceRotate(getSubtitle(),0);
setPlaceAlign(getSubtitle(),0);
setPlaceWordWrap(getSubtitle(),0);
setPlaceResize(getFootnote(),0);
setPlaceRotate(getFootnote(),0);
setPlaceAlign(getFootnote(),0);
setPlaceWordWrap(getFootnote(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
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,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
FOCEXEC=matrixxg/app/wcqrgj18.fex(FACILITY_CODE=A1 REP_GRP_CHRONO='BYMONTH' REP_GRP_LOCALE='BY_STR' REP_GRP_ATTRIB='PL' REP_SHOW_BUDGET='TRUE' BEGIN_MONTH='200707' END_MONTH='200707' YEAR_COUNT='2'),
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,

What is the URL showing you.
Is it what you expect, so in the FACILITY_CODE the value HC?

Or is it a problem in the child application?

I see all kind of "values", being fixed.

the URL shows the wrong value....so the report is properly functioning...

The graph slice I click on is "HC" but passes "ID" (both are facilities in our company)
Another slice "PS" passes a "BB" value when clicked...again, both are legitimate in the company...

I found that when I used the print verb in the GRAPH FILE command, the drill down wasn't passing the correct value, but when I used SUM it worked fine:


THIS DOESN'T WORK....

GRAPH FILE CAR
PRINT SEATS
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON GRAPH SET HAXIS 660
ON GRAPH SET VAXIS 260
ON GRAPH SET LOOKGRAPH PIESINGL
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N2, FOCEXEC=DRILL_TEST(VAR1=MODEL), $
ENDSTYLE
END


------report being drilled to-----------


-DEFAULT &VAR1='FOC_NONE';

-*-? &

-TYPE &VAR1
-RUN

-------------------------------------------------------------------------


THIS DOES WORK!!!!!!!!!!!!!!!!!!

GRAPH FILE CAR
SUM SEATS
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON GRAPH SET HAXIS 660
ON GRAPH SET VAXIS 260
ON GRAPH SET LOOKGRAPH PIESINGL
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N2, FOCEXEC=DRILL_TEST(VAR1=MODEL), $
ENDSTYLE
END

-------------report being drilled to-----------


-DEFAULT &VAR1='FOC_NONE';

-*-? &

-TYPE &VAR1
-RUN