[SOLVED] Graph drill down issue

December 04, 2013, 09:42 AM

BI_Developer

Hello

I am working on a simple bar graph and am having drill down issue. I tried several ways but could not get it. I replicated the same using CAR file

GRAPH FILE CAR
SUM SALES AS ''
BY HIGHEST TOTAL SALES NOPRINT
BY COUNTRY  AS ''
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 650
ON GRAPH SET VAXIS 450
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIPlumOnWhite.txt");
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDisplay(getO1MajorGrid(),false);
setFontName(getO1Label(),"Arial");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 8);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     COLUMN=N3,
     TARGET='_blank',
     FOCEXEC=app/drill_down.fex(CNTRY_NM=COUNTRY),
ENDSTYLE
END

When we click the drill down, all the time FRANCE is being sent as the value. This is the line that is creating the issue - "BY HIGHEST TOTAL SALES NOPRINT". If I remove that line, drill down is working fine and passing correct value.

Please provide a fix or a work around for this.

Thank you..

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

December 04, 2013, 09:53 AM

Francis Mariani

I ran your code, as posted, and, as you can see from the URLs, the correct country is being passed in the variable:

http://localhost:8080/ibi_apps...fex&CNTRY_NM=ENGLAND

http://localhost:8080/ibi_apps...CNTRY_NM=W%20GERMANY

In drill_down.fex, you need to use &CNTRY_NM in the filter.

Also, though it works, I would probably use TYPE=DATA instead of TYPE=REPORT for the drilldown.

December 04, 2013, 10:07 AM

Tom Flynn

  
GRAPH FILE CAR
SUM SALES AS ''
   COUNTRY NOPRINT
BY HIGHEST TOTAL SALES NOPRINT
BY COUNTRY  AS ''
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 650
ON GRAPH SET VAXIS 450
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIPlumOnWhite.txt");
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDisplay(getO1MajorGrid(),false);
setFontName(getO1Label(),"Arial");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 8);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     COLUMN=N3,
     TARGET='_blank',
     FOCEXEC=app/drill_down.fex(CNTRY_NM=N4),
ENDSTYLE
END

December 04, 2013, 10:11 AM

BI_Developer

Hi Tom,

Is the below code working for you?
I still see FRANCE being passed..!!

Thanks

quote:

Originally posted by Tom Flynn:

  
GRAPH FILE CAR
SUM SALES AS ''
   COUNTRY NOPRINT
BY HIGHEST TOTAL SALES NOPRINT
BY COUNTRY  AS ''
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 650
ON GRAPH SET VAXIS 450
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIPlumOnWhite.txt");
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDisplay(getO1MajorGrid(),false);
setFontName(getO1Label(),"Arial");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 8);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     COLUMN=N3,
     TARGET='_blank',
     FOCEXEC=app/drill_down.fex(CNTRY_NM=N4),
ENDSTYLE
END