July 29, 2005, 01:53 PM
<kvn> OLAP multiple drilldown?
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?
August 03, 2005, 04:34 AM
<rsaini> 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
August 03, 2005, 02:53 PM
<kvn> 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.
August 12, 2005, 05:32 PM
Kerry 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 , November 22, 2005 03:16 PM