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     [CLOSED]Drill Performance - Validating Fex?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Drill Performance - Validating Fex?
 Login/Join
 
Member
posted
I have a report with a very large number of drills that is taking forever to render. When I comment out the drills, it renders very quickly. I appears that the fexes for the drills are evaluated every time the report is executed. Is there an option to stop that from happening? Basically only evaluate the fex for the drills upon the drill being clicked? Any insight is greatly appreciated! Cheers!

This message has been edited. Last edited by: <Emily McAllister>,
 
Posts: 6 | Registered: March 29, 2016Report This Post
Expert
posted Hide Post
quote:
It appears that the fexes for the drills are evaluated every time the report is executed
This is most likely not the case, how did you determine this?

What kind of report is this? HTML, Active HTML?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Please update your profile to include the version of WebFOCUS you're using.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
Thank you for your response Francis! This is an assumption made in that when I execute the report, it takes minutes to run. When I comment out the drills, it runs in seconds. The assumption is that the drills are being evaluated individually. This is in an HTML report on 8.105. I will get my profile updated Wink


WebFOCUS 8.105
Windows, All Outputs
 
Posts: 6 | Registered: March 29, 2016Report This Post
Expert
posted Hide Post
Please post the code (between code tags). I don't see why including drilldowns would affect the speed of displaying the report. The additional HTML for the drilldowns would be fairly small.

[code]
YOUR CODE HERE
[/code]


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
Hey Francis,

I'm going to jump in here for newbie2 as I am part of the team.

There is a large number of drills being created for this report. We are experiencing increased time to render the report as the amount of drills have increased due to changes in the report. The output formats that we are experiencing this problem with are HTML and Excel.


 -IF '&FOCFOCEXEC.EVAL' EQ 'RCASTER' THEN GOTO :SKIPDRILLS;

TYPE=DATA,COLUMN=DESC,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/pointofsalec/clubaccountc/datatrak_club_accounts_drill.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I  ASOF='&ENDDATE' DRDR='DRDR' DRILL='2'),TARGET=_blank,WHEN=DRILL1 EQ 'Y',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL21 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL21 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&BOMDATE' ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL22 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&BOMDATE' ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL22 EQ 'YN',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL21 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL21 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL22 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL22 EQ 'YN',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL23 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL23 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL24 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL24 EQ 'YN',$

TYPE=DATA,COLUMN=DESC,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_early_deposit.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I  ASOF='&ENDDATE' DRDR='DRDR' CYCLE='DLY' DRILL='2'),TARGET=_blank,WHEN=DRILL7 EQ 'Y',$

TYPE=DATA,COLUMN=AMT3,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT3 EQ 'YP',$
TYPE=DATA,COLUMN=AMT3,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT3 EQ 'YN',$
TYPE=DATA,COLUMN=AMT4,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT4 EQ 'YP',$
TYPE=DATA,COLUMN=AMT4,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT4 EQ 'YN',$

TYPE=DATA,COLUMN=AMT3,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT3 EQ 'YP',$
TYPE=DATA,COLUMN=AMT3,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT3 EQ 'YN',$
TYPE=DATA,COLUMN=AMT4,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT4 EQ 'YP',$
TYPE=DATA,COLUMN=AMT4,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT4 EQ 'YN',$

TYPE=DATA,COLUMN=AMT13,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT13 EQ 'YP',$
TYPE=DATA,COLUMN=AMT13,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT13 EQ 'YN',$
TYPE=DATA,COLUMN=AMT14,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT14 EQ 'YP',$
TYPE=DATA,COLUMN=AMT14,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT14 EQ 'YN',$

TYPE=DATA,COLUMN=AMT13,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT13 EQ 'YP',$
TYPE=DATA,COLUMN=AMT13,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT13 EQ 'YN',$
TYPE=DATA,COLUMN=AMT14,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT14 EQ 'YP',$
TYPE=DATA,COLUMN=AMT14,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT14 EQ 'YN',$

-SET &AMTCNT = 1;
-REPEAT :LOOP4 WHILE &AMTCNT LE 18;
-SET &DATERNG3 = IF &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN &ASOF ELSE &DATERNG1;
-SET &BEGINDT3 = IF &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN &ENDDATE ELSE &BOMDATE;
-SET &RTBORDER = IF &RUNTYPE EQ 'D' AND &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN LIGHT
-                ELSE IF &RUNTYPE NE 'D' AND &AMTCNT IN (2,4,6,8,10,12,14,16,18) THEN LIGHT ELSE OFF;
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
          FOCEXEC=daily_billing_ccd_pass_thru(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pay_type_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pay_type_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pft_ctr_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pft_ctr_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=daily_billing_ccd_pass_thru(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' DATERNG1='&DATERNG3' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL45&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' DATERNG1='&DATERNG3' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL45&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE' ICFLT='TOT REV'),
		  TARGET=_blank,WHEN=DRILL154T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE' ICFLT='TOT REV'),
		  TARGET=_blank,WHEN=DRILL154T&AMTCNT EQ 'YN',$
-*

-SET &FS_BEG_DTE = IF &TOYYMD EQ &EOM_FUL_SVC AND &AMTCNT EQ 1 THEN &AGGRMTH | '16' ELSE &AGGRMTH | '01';
-SET &FS_END_DTE = IF &TOYYMD EQ &EOM_FUL_SVC THEN &TOYYMD ELSE &AGGRMTH | '15';
-SET &DATERNG1 = EDIT(&FS_BEG_DTE,'$$$$99/') || EDIT(&FS_BEG_DTE,'$$$$$$99/') || EDIT(&FS_BEG_DTE,'9999');
-SET &DATERNG2 = EDIT(&FS_END_DTE,'$$$$99/') || EDIT(&FS_END_DTE,'$$$$$$99/') || EDIT(&FS_END_DTE,'9999');
-INCLUDE parse_range.fex
-SET &FS_HEADER = &HDRDTE;
-SET &FRDATE = &DRDR_FRDATE;
-SET &TODATE = &DRDR_TODATE;
-SET &HDRDTE = &DRDR_HDRDTE;

TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='EML' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSEML&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='IBC' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSIBC&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='VCE' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSVCE&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='SMS' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSSMS&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='LTR' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSLTR&AMTCNT EQ 'YP',$
-*

-SET &AMTCNT = &AMTCNT + 1;
-:LOOP4;

TYPE=DATA,COLUMN=DESC,BORDER-RIGHT=LIGHT,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='R' DATERNG1='&DATERNG1' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL46 EQ 'YP',$
-*
TYPE=DATA,COLUMN=C1,BORDER-RIGHT=LIGHT,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/abc_ca_recon_sum.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I CYCLE='DLY' DLYDATE='&DLYDATE'),
		  TARGET=_blank,WHEN=DRILL851T EQ 'YP',$
-*
TYPE=DATA,COLUMN=C1,BORDER-RIGHT=LIGHT,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/abc_ca_recon_sum.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I CYCLE='DLY' DLYDATE='&DLYDATE'),
		  TARGET=_blank,WHEN=DRILL851T EQ 'YN',$
-*
-:SKIPDRILLS; 


WebFocus 8, Windows, All Outputs
 
Posts: 3 | Registered: May 28, 2015Report This Post
Virtuoso
posted Hide Post
Brian & newbie2,

You should probably do some debugging using the "salami" technique: cut out pieces and see what happens and when.
I see within your mounds of drills that there is a loop (18 times).
If you cut out the loop what happens?
Also, within the loop you have "-INCLUDE parse_range.fex" what does that do?
Lastly, you put semi-colons at the end of labels e.g. "-:LOOP4;". I wouldn't do that.


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

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Expert
posted Hide Post
A took a look at the first few lines of the drilldown stylesheet, form column AMT1.

I rearranged the code a little. The conditions for lines 1 and 2 are the same, and the conditions for lines 5 and 6 are the same. The syntax used in these drilldowns does not allow for multiple drilldowns, so only one drilldown per condition will be on the report.

TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YN', TARGET=_blank, FOCEXEC=ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YN', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL23 EQ 'YN', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'), TARGET=_blank, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'), $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'), $


I agree with Danny, I'd say the code needs to be examined carefully.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
Daniel and Francis,

Thank you for your responses. I did apply "salami" testing to figure out where and in what instances we would experience the slowness of this report as you suggested.

This report is much like a pivot table in the way it displays the data, but is not built in that way. The data is grouped in to 9 categories which contain 2 columns for each category giving a total of 18 numeric columns total. The categories columns are split between a daily value column and a month-to-date value column. The user running the report has the ability to choose to run the report for "Daily Only", "MTD Only", or "Daily & MTD" together. So when running the report for "Daily Only" or "MTD Only" there is only 9 columns being produced instead of the 18.

I found that the drills section created with a loop was trying to create drills for all 18 columns when the report was run for Daily Only or MTD Only which was only using 9 columns. A simple adjustment of the loop cleared up the speed differences. It would appear that it managed to run even when the loop tried to create the drills for missing columns, but the amount of time for it to complete increased.

I agree Francis, the code here needs to be examined further to see where the amount of drills created could be reduced from single instance drilldowns to multiple. Unfortunately as it is in most work places, the work load is full and has to be prioritized into the to-do list by the business.

Thanks for both of your input.


WebFocus 8, Windows, All Outputs
 
Posts: 3 | Registered: May 28, 2015Report 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     [CLOSED]Drill Performance - Validating Fex?

Copyright © 1996-2020 Information Builders