Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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: 25 | Registered: April 11, 2013Report 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, 2018Report 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: 25 | Registered: April 11, 2013Report 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, 2018Report 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: 25 | Registered: April 11, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders