Hi,

I am trying to create cascading multi drill downs, having issues with the KEYWORD NAME, PARENT from the below code.

please take a look at it and suggest some solution.



TABLE FILE GGSALES
SUM
GGSALES.SALES01.UNITS
GGSALES.SALES01.DOLLARS
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.CATEGORY
BY GGSALES.SALES01.PRODUCT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
FONT=TAHOMA, GRID=OFF,$
TYPE=DATA,COLUMN=B2,
DRILLMENUITEM='Sales Details', NAME=menu2,
DRILLMENUITEM='By Month',
PARENT=menu2, NAME=menu21,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM='By Quarter',
PARENT=menu2, NAME=menu23,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM=SEPARATOR, PARENT=menu2,
DRILLMENUITEM='By Product',
PARENT=menu2, NAME=menu24,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM='By Customer',
PARENT=menu2,NAME=menu25,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM=SEPARATOR, PARENT=menu2,
DRILLMENUITEM='Profitablity Analysis',
PARENT=menu2,NAME=menu3,
DRILLMENUITEM='By Month',
PARENT=menu3, NAME=menu31,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM='By Region',
PARENT=menu3, NAME=menu32,
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
DRILLMENUITEM='Forecasts',
FOCEXEC=detailreport.fex(PARAMETER=CATEGORY),TARGET=_blank,
$
TYPE=DATA,COLUMN=B3,
DRILLMENUITEM='IBI Links',NAME=menu4a,
DRILLMENUITEM='Information Builders',
PARENT=menu4a, NAME=menu41,
URL=http://www.ibi.com,TARGET=_blank,
DRILLMENUITEM='Summit 2015',
PARENT=menu4a, NAME=menu42,
URL=http://www.ibi.com,TARGET=_blank,
DRILLMENUITEM='Competative Analysis',
PARENT=menu4a, NAME=menu43,
URL=http://www.ibi.com,TARGET=_blank,
DRILLMENUITEM='External Links', NAME=menu4b,
DRILLMENUITEM='Google',
PARENT=menu4b, NAME=menu45, URL=http://www.google.com,TARGET=_blank,
DRILLMENUITEM='Weather',
PARENT=menu4b, NAME=menu46, URL=http://www.weather.com,TARGET=_blank,
DRILLMENUITEM='CNN',
PARENT=menu4b,NAME=menu47, URL=http://www.cnn.com,TARGET=_blank,
$
ENDSTYLE
END



This message has been edited. Last edited by: FP Mod Chuck,

Hi,
I ran your code and it works fine.
I was able to open all the external URLs
fex will obvirously not run but the code is working as expected.
Can you post the error you are getting.

Hi Addy,

Thanks for the reply. Below is the error I am seeing when I run the code.

(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE 16: NAME

Just to let you know we are currently on Developer Studio v8.1.05

Hi Kishor,
As I said earlier.. your code works for me and it could very well be the version issue as I am on 8204.

I would suggest you try introducing once section at a time and see how far it goes. So just add first drill menu and run if it works go for the next section and so on..

Or you can definately check with Tech Support.

Sorry could be of much help Mate!!

Hi Addy,

Thanks for the reply again.
The normal Multi drill downs work. its when we are creating nesting drill downs with Parent and child we are having issue.

I will work with tech support on this.
Thanks for taking a look at it.