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 ENDThis message has been edited. Last edited by: <Kathryn Henning>,
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
July 13, 2007, 10:55 AM
FrankDutch
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.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
July 13, 2007, 11:09 AM
Jason K.
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...
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
May 15, 2014, 05:42 PM
SJL123
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
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