Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Cascading Multi Drill downs
Go
New
Search
Notify
Tools
Reply
  
[CASE OPENED] Cascading Multi Drill downs
 Login/Join
 
Member
posted
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,


WebFOCUS 7.6, 7.7, 8.1.05
Windows, All Outputs
 
Posts: 18 | Registered: April 11, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
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.


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Member
posted Hide Post
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


WebFOCUS 7.6, 7.7, 8.1.05
Windows, All Outputs
 
Posts: 18 | Registered: April 11, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
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!!


WF 8.2.04
Windows/Unix
All Formats
In Focus since 2006
 
Posts: 74 | Location: UK | Registered: September 17, 2018Reply With QuoteReport This Post
Member
posted Hide Post
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.


WebFOCUS 7.6, 7.7, 8.1.05
Windows, All Outputs
 
Posts: 18 | Registered: April 11, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Cascading Multi Drill downs

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.