Using the "CAR" Master file as an example, I was able to replicate the troube I am facing with a 3D BAR GRAPH.

I have an initial Graph of "RETAIL_COST" and "DEALER_COST" by "COUNTRY". I am trying to create a drilldown graph of "RETAIL_COST" and "DEALER_COST" by "CAR" in one specific COUNTRY (Depending on where the user clicks on the initial graph). So far I've only been able to create a drilldown to "RETAIL_COST" and "DEALER_COST" by "CAR" in all the COUNTRYs. It seems the measures are the only elements that can be given drilldowns (DEALER_COST,DEALER_COST) , I want the different values of my Dimensions to have drilldowns (COUNTRY). How can the user click on a COUNTRY and have a dynamic drilldown graph of the "RETAIL_COST" and "DEALER_COST" by "CAR" of that specific Country?
Can Someone share an example of the code to be written?
Thank you.

-* File costbycountry.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE CAR
CAR.ORIGIN.COUNTRY: CAR.ORIGIN.COUNTRY, CAR.COMP.CAR, CAR.CARREC.MODEL;
END
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH 3D_BAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
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);
setAxisAssignment(1,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setTitleString("Cost By Country");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBIPastels.txt");
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     TITLETEXT='Cost By Country',
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     FOCEXEC=costbycar.fex,
$
ENDSTYLE
END

******************************

 
-* File CostByCar.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE CAR
CAR.ORIGIN.COUNTRY: CAR.ORIGIN.COUNTRY, CAR.COMP.CAR, CAR.CARREC.MODEL;
END
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST
ACROSS CAR.COMP.CAR
ON GRAPH SET LOOKGRAPH 3D_BAR
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);
setAxisAssignment(1,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setTitleString("Cost By Car");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBIPastels.txt");
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     TITLETEXT='Cost By Car',
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     FOCEXEC=NONE,
$
ENDSTYLE
END

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

Consider this freebie as a welcome to FocalPoint (all this was done in the DS GUI):

-* Created by Douglas Lee for Focal Point
-* http://forums.informationbuild...1057331/m/9197009606
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH PIEMULTI
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 SET VAXIS 600
ON GRAPH SET HAXIS 900
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(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(3);
setTextFormatPreset(getPieSliceLabel(),2);
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,
     FOCEXEC=app/dd_car_report.fex( \
     COUNTRY=A1 \
     ),
$
ENDSTYLE
END

and

-* Created by Douglas Lee for Focal Point
-* http://forums.informationbuild...1057331/m/9197009606
TABLE FILE CAR
SUM
     'CAR.BODY.RETAIL_COST'
     'CAR.BODY.DEALER_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
BY 'CAR.CARREC.MODEL'
WHERE COUNTRY EQ '&COUNTRY.EVAL'
HEADING
"Drilldown Report for &COUNTRY.EVAL "
" "
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END

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

AWESOME!!!

Thank you so much Doug! This simple yet perfect example is going to make me go a lot further with the GRAPH reports.


This ticket is Solved [SOLVED] !!!