[CLOSED] Multiple drill downs with Advanced Graph Assistant

Is there a way to create multiple drill downs for graphs created with the Advanced Graph Assistant, like you can in the Report Painter, so when it runs and you click on a drill-down value, you get the pop-up menu that lists the child reports?

Thank you,

John

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

WF 7.7.03, Windows 7, HTML, Excel, PDF

Posts: 225 | Location: San Francisco Bay Area, California | Registered: October 26, 2006

GinnyJakes

Expert

posted

Hide Post

I'm pretty sure this cannot be done. See these previous posts:

Post 1

Post 2

Search on DRILLMENUITEM and GRAPH in the Advanced Search.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

posted

We are able to multiple drilldown menu options from graphs using the following.

Copy below in an app folder.

---*

-* File popup_box_test.fex
SET JSURL=/approot/html/popup_box.js
SET CSSURL=/approot/html/popup_box.css
DEFINE FILE GGSALES
POPUP_BOX/A100='';
END
GRAPH FILE GGSALES
SUM UNITS
ACROSS PRODUCT
HEADING
"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 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);
setSeriesType(0,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 *
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,
JAVASCRIPT=showPopup(A1),
$
ENDSTYLE
END

--****
-* File popup_box_drill1.fex

TABLE FILE GGSALES
SUM UNITS DOLLARS
BY PRODUCT
BY REGION
WHERE PRODUCT EQ '&PARMVALUE'
END

---** popup_box.js
var topX, topY;

function getXY() {

topX = event.clientX ;
topY = event.clientY ;
}

function getXOffset(offset) {
docWidth=document.body.clientWidth;
newOffset;

if (topX > (docWidth / 2))
newOffset=offset*-1;
else
newOffset = offset;
return newOffset;
}

function getYOffset(offset) {
docHeight=document.body.clientHeight;
newOffset;

if (topY > (docHeight / 2))
newOffset=offset*-1;
else
newOffset = offset;
return newOffset;
}

function showPopup(inVal) {

/* getXY();
xOff=getXOffset(objId.style.pixelWidth);
yOff=getYOffset(objId.style.pixelHeight);
*/
objId=document.getElementById('POPUP');
objId.style.pixelTop = 3;
objId.style.pixelLeft = 3;
text1 = 'Drilldown 1 for ' + inVal + '
';
text2 = 'Drilldown 2 for ' + inVal + '
';
objId.innerHTML = text1 + text2;
objId.style.visibility='visible';
}

function hidePopup() {
objId=document.getElementById('POPUP');
objId.style.visibility='hidden';
}

--***** popup_box.css
#POPUP {
font-size: 9pt;
font-family: arial;
font-weight: bold;
padding: 5px;
text-align: left;
vertical-align: top;
background-color: rgb(192,192,192);
border: outset 2;
visibility: hidden;
position: absolute;
width: 200px;
}

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED] Multiple drill downs with Advanced Graph Assistant

Focal Point | Privacy Statement | Terms of Service