I'm working on a graph which has a multi-drilldown to two other graphs. Several variables are passed through.

However, the multi-drilldown setup doesn't create the correct URL string, and I can't quite figure out why.

Example:

  
TYPE=DATA,
COLUMN=HLD_GRAPH.SEG01.PCT_TURNOVER_VOL,
FOCEXEC=FEXNAME.fex (\
MODE = '1D1' \
FROM_YEAR=&FROM_YEAR.EVAL \
TO_YEAR=&TO_YEAR. \
FROM_MONTH=&FROM_MONTH \
TO_MONTH=&TO_MONTH \
DEPARTMENTCODE=HLD_GRAPH.SEG01.DEPARTMENTCODE \
DIVISIONCODE=&DIVISIONCODE.QUOTEDSTRING \
JOBCODE=&JOBCODE.QUOTEDSTRING \
FROM_DATE='X' \
TO_DATE='X' \
SHOWBENCHMARK = '-*' \
NEXTMODE = '' \
graphsubtitle= '&graphsubtitle' \
),target=_self, $

Is all good, and creates the following string:

  
http://SERVERNAME:8080/ibi_app...btitle=Aug%20%202010

However, the following (intentionally only one option):

TYPE=DATA,
COLUMN=HLD_GRAPH.SEG01.PCT_TURNOVER_VOL,
DRILLMENUITEM='by Job',
FOCEXEC=FEXNAME.fex (\
MODE = '1D1' \
FROM_YEAR=&FROM_YEAR.EVAL \
TO_YEAR=&TO_YEAR. \
FROM_MONTH=&FROM_MONTH \
TO_MONTH=&TO_MONTH \
DEPARTMENTCODE=HLD_GRAPH.SEG01.DEPARTMENTCODE \
DIVISIONCODE=&DIVISIONCODE.QUOTEDSTRING \
JOBCODE=&JOBCODE.QUOTEDSTRING \
FROM_DATE='X' \
TO_DATE='X' \
SHOWBENCHMARK = '-*' \
NEXTMODE = '' \
graphsubtitle= '&graphsubtitle' \
),target=_self, $

Creates

http://SERVERNAME:8080/ibi_app...itle%3DAug%20%202010

I imagine that I've got some error in the syntax of the multi-drill but I can't figure it out...any ideas out there? (I've edited out the servername and fexname for obvious reasons)

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

FROM_YEAR=&FROM_YEAR.EVAL \
TO_YEAR=&TO_YEAR. \

One with an EVAL and one without?

I don't know if this will solve your problem, but I'd code it this way:

FROM_YEAR=&FROM_YEAR.QUOTEDSTRING \ 
TO_YEAR=&TO_YEAR.QUOTEDSTRING \