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] Multi Drilldowns on text heading in a chart
Go
New
Search
Notify
Tools
Reply
  
[CASE OPENED] Multi Drilldowns on text heading in a chart
 Login/Join
 
Platinum Member
posted
I am trying to create a multi item drill on a text field in a chart. I am able to create a single drill with no tag/label/alternative text on the Text. Is there an issue with this in 8201?

TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=9, COLOR=RGB(109 110 113), STYLE=NORMAL,
DRILLMENUITEM='Detail',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All Rxs' \
POLICYNAME= 'FOC_NONE' \
DRUGNAME= 'FOC_NONE' \
DRCLASS= 'FOC_NONE' \
), TARGET=_blank,
DRILLMENUITEM='GPI4',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_gpi4_rpt.fex( \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All RxS' \
), TARGET=_blank,
DRILLMENUITEM='Top Drugs',
FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_drugname_rpt.fex( \
GPI4='_FOC_NULL' \
FLD='_FOC_NULL' \
DATE='_FOC_NULL' \
FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING \
TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING \
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING \
WFRPT='All Rxs' \
), TARGET=_blank,
$

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


dksib
DC Tech Services Inc
WF 8.2.1M
 
Posts: 112 | Location: US | Registered: February 09, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Do you get an error or does it not pass the variables?


WebFOCUS 8203, Unix, Windows
 
Posts: 1344 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It is broken,it does not do anything. Once I removed two of them it works for the remanding 1 drilldown.


dksib
DC Tech Services Inc
WF 8.2.1M
 
Posts: 112 | Location: US | Registered: February 09, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
There are a couple of entries that mention something about EMBEDHEADING. http://forums.informationbuild...1057331/m/6957001096

Can you try SET EMBEDHEADING = OFF and see if that makes a difference?


WebFOCUS 8203, Unix, Windows
 
Posts: 1344 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Using DRILLMENUITEM you need to have all your parameters on the same line where the FOCEXEC is

FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING FLD='_FOC_NULL' DATE='_FOC_NULL' 
 GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING WFRPT='All Rxs' POLICYNAME= 'FOC_NONE' DRUGNAME= 'FOC_NONE' DRCLASS= 'FOC_NONE' ), TARGET=_blank,


Seems that using \ as concatenation char is not anymore working in 8.2. for DRILLMENUITEM
I have been told by IB that this is not a bug, this is what the default style sheet produces now.


WF 7.7.05M, 8.1.05M, 8.2.0.1M gen240 Windows, HTML, Excel, PDF
In Focus since 2007
 
Posts: 1807 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks Martin but that does not work. I am currently using WF 8.2.01.


dksib
DC Tech Services Inc
WF 8.2.1M
 
Posts: 112 | Location: US | Registered: February 09, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
And having all on the same line such as
DRILLMENUITEM='Detail', FOCEXEC=IBFS:/WFC/Repository/Pharmacy/aco_pharmacy_claims_detail_xls.fex( FR_DATEFILLED=&FR_DATEFILLED.QUOTEDSTRING TO_DATEFILLED=&TO_DATEFILLED.QUOTEDSTRING FLD='_FOC_NULL' DATE='_FOC_NULL' 
GPI4CLASSNAMEDESC=&GPI4CLASSNAMEDESC.QUOTEDSTRING WFRPT='All Rxs' POLICYNAME= 'FOC_NONE' DRUGNAME= 'FOC_NONE' DRCLASS= 'FOC_NONE' ), TARGET=_blank,


Please share your code


WF 7.7.05M, 8.1.05M, 8.2.0.1M gen240 Windows, HTML, Excel, PDF
In Focus since 2007
 
Posts: 1807 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I created the following with AppStudio:
  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.BODY.BODYTYPE
HEADING
"Drill"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = warm,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     DRILLMENUITEM='ds1',
          FOCEXEC=focalpoint/ds1( \
     MSORT='CAR' \
     ),
          TARGET='_blank',
     DRILLMENUITEM='ds2',
          FOCEXEC=focalpoint/ds2( \
     CSORT='SEATS' \
     ),
          TARGET='_blank',
$
ENDSTYLE
END

ds1:
  
TABLE FILE CAR
SUM SALES
BY &MSORT
END

ds2:
  
TABLE FILE CAR
SUM SALES
BY COUNTRY
ACROSS &CSORT
END

As you can see, no problem with \


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1909 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
This is for TABLE FILE. The requirement is GRAPH FILE.


WebFOCUS 8203, Unix, Windows
 
Posts: 1344 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Works just as well with GRAPH.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1909 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Still is not working in 8.2.01. As a work around I one line with each drill as a separate Text in the heading. I will be opening a case with IB for this issue.

Thanks for the help.


dksib
DC Tech Services Inc
WF 8.2.1M
 
Posts: 112 | Location: US | Registered: February 09, 2004Reply 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] Multi Drilldowns on text heading in a chart

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