[SOLVED]: EXPANDBYROW DRILL-DOWN

March 01, 2017, 11:14 PM

HI,
Cant seem to figure out how to add drill-down. Tried a few things but cant seem to make it work. Is it a known issue. I searched it on the forum as well and didnt find anything.
Here is the syntax I am using:

TYPE=DATA,
COLUMN=N6,
FOCEXEC=IBFS:/WFC/Repository/.../DrillDown.fex,
$

Thanks

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

March 02, 2017, 07:34 AM

MartinY

It does work, but only on the last BY field.
If COLUMN=N6 is not the last BY it doesn't work.

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
   COLUMN=MODEL,
   FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex,
$
END

-* Procedure2
TABLE FILE CAR
PRINT *
END

Or with using parameters (which make more sense)

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
   COLUMN=MODEL,
   FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$
END

-* Procedure2
TABLE FILE CAR
PRINT *
WHERE COUNTRY EQ '&FCOUNTRY';
WHERE CAR     EQ '&FCAR';
WHERE MODEL   EQ '&FMODEL';
END

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

March 02, 2017, 12:08 PM

Thanks but COLUMN N6 is a measure.

Basically, I want to do something like the example below.

quote:
TABLE FILE CAR
SUM SALES
DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDBYROW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA,
COLUMN=SALES,
FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$

TYPE=DATA,
COLUMN=DCOST,
FOCEXEC=IBFS:/WFC/Repository/.../Procedure2.fex (FCOUNTRY=COUNTRY FCAR=CAR FMODEL=MODEL),
$

END