Focal Point
[SOLVED] Multiple Drilldown In Graph

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/963108231

May 30, 2009, 02:04 PM
Devi C
[SOLVED] Multiple Drilldown In Graph
Hi,

I am trying to do multiple drilldown in Graph.
In the help document http://documentation.informati...graph/wf761graph.pdf,
it is given that multiple drilldown is possible in Graph... But when i execute the same code as per the document, i didn't get the output.

Please help me so.
Thanks in advance.

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


WebFOCUS 7.6.4,7.6.9
OS: Windows XP
HTML,EXCEL,PDF
June 01, 2009, 08:28 AM
PBrightwell
According to that documentation this should work. However, I have never gotten this to work from a graph but things have changed since 5.3.
 
TYPE=DATA, STYLE=BOLD,
FIELD=BU_DESC,
 DRILLMENUITEM='  By Customer By Product Excel', FOCEXEC=app/und041b.fex(BU=BU_NO SB='CUST' OUT='EXL97'), TARGET=_blank,
 DRILLMENUITEM='  By Product By Customer',FOCEXEC=app/und041c.fex(BU=BU_NO SB='PROD'), TARGET=_blank,
 DRILLMENUITEM='  By Salesperson Excel', FOCEXEC=app/und041b.fex(BU=BU_NO SB='SLSP' OUT='EXL97'), TARGET=_blank,
 DRILLMENUITEM='  By Customer By Product HTML', FOCEXEC=app/und041b.fex(BU=BU_NO SB='CUST' OUT='HTML'), TARGET=_blank,
 DRILLMENUITEM='  By Salesperson HTML', FOCEXEC=app/und041b.fex(BU=BU_NO SB='SLSP' OUT='HTML'), TARGET=_blank,
$

If your commands do not fit on one line, you need a continuation '/' 



Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
June 02, 2009, 06:50 AM
Devi C
Hi,

Thanks for your reply.

I tried using your code, but still i didn't get the output.

 

GRAPH FILE CAR
SUM
SEATS
BY CAR
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET STYLE *
TYPE=DATA, STYLE=BOLD,
FIELD=SEATS,
DRILLMENUITEM='DrillDown 1',URL=http://www.informationbuilders.com,TARGET=_blank,
DRILLMENUITEM='DrillDown 2',URL=http://www.google.com,TARGET=_blank,
$

ENDSTYLE
END



Any other suggestions??


Thanks,
Devi C


WebFOCUS 7.6.4,7.6.9
OS: Windows XP
HTML,EXCEL,PDF
June 02, 2009, 07:30 AM
<JG>
Multiple Drill-Down From Graph is not supported for graphs before The latest version,
It is a new feature in 7.6.9
June 02, 2009, 08:33 AM
mrguru
It does work in 7.6.9. I just tested it. The documentation you are looking at has been updated for 7.6.9. The previous version DN4500708.1208 did not have the multiple link in it.


WF 8.2.01M
8.2.01M Reporting Server
Windows 2012 Srvr R2
PDF,Excel, HTML
Graphs - a lot of graphs
June 06, 2009, 11:31 AM
Devi C
Thanks for your reply JG and Mrguru.


WebFOCUS 7.6.4,7.6.9
OS: Windows XP
HTML,EXCEL,PDF