I can't seem to find any information on this but can OLAP be told to do multiple drilldowns and in those alternative drilldowns, drilldown to a different report?

Try this

TABLE FILE GGSALES
SUM
DOLLARS/D12.2CM
BUDDOLLARS/D12.2CM
BY ST
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,$

TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,$

TYPE=DATA,
COLUMN=N1,
COLOR='BLUE',
STYLE=UNDERLINE,
DRILLMENUITEM='DRILLDOWN 1',
URL=HTTP://WWW.INFORMATIONBUILDERS.COM,
DRILLMENUITEM='DRILLDOWN 2',
FOCEXEC=DETAILREPORT(PARAMETER=N1),$

TYPE=TITLE, STYLE=BOLD,$

TYPE=TITLE,
COLUMN=N1,
COLOR='BLUE',
STYLE=BOLD+UNDERLINE,
DRILLMENUITEM='DRILLDOWN 1',
URL=HTTP://WWW.INFORMATIONBUILDERS.COM,
DRILLMENUITEM='DRILLDOWN 2',
FOCEXEC=DETAILREPORT(PARAMETER=N1),$

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


R Saini

rsaini I'm looking to do multi drilldowns in an OLAP enabled report. It doesn't seem the sample report you displayed is using OLAP.

I'm guessing this can not be done. Using OLAP and automatic drilldown.

Hi kvn,

Has this issue regarding OLAP multiple drilldown been resolved?

I ran a quick search on Information Builder's online documentations and came across the following topics which may be of interest.

How to use drilldowns in OLAP reports?
http://techsupport.informationbuilders.com/sps/81191069.html

Summary: DS: DrillDown to URL feature doesn't work in OLAP.
http://techsupport.informationbuilders.com/known_problems/83251070.html

Summary: OLAP autodrill with hidden fields creates a WHERE condition http://techsupport.informationbuilders.com/known_problems/10902086.html

Hope this helps.

Cheers,

Kerry

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