Focal Point
[CASE OPENED] Multi Drilldowns on text heading in a chart

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

December 06, 2018, 11:18 AM
David Sibert
[CASE OPENED] Multi Drilldowns on text heading in a chart
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
December 06, 2018, 11:44 AM
BabakNYC
Do you get an error or does it not pass the variables?


WebFOCUS 8206, Unix, Windows
December 06, 2018, 12:48 PM
David Sibert
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
December 06, 2018, 01:12 PM
BabakNYC
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 8206, Unix, Windows
December 06, 2018, 02:08 PM
MartinY
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 versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
December 06, 2018, 04:07 PM
David Sibert
Thanks Martin but that does not work. I am currently using WF 8.2.01.


dksib
DC Tech Services Inc
WF 8.2.1M
December 07, 2018, 07:34 AM
MartinY
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 versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
December 08, 2018, 12:33 PM
Danny-SRL
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

December 09, 2018, 03:00 PM
BabakNYC
This is for TABLE FILE. The requirement is GRAPH FILE.


WebFOCUS 8206, Unix, Windows
December 10, 2018, 01:56 AM
Danny-SRL
Works just as well with GRAPH.


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

December 10, 2018, 10:38 AM
David Sibert
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