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] EXPANDBYROW and Drillthrough

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] EXPANDBYROW and Drillthrough
 Login/Join
 
Member
posted
I'm having some trouble getting Drill-through to work while using EXPANDBYROW. Is there anything i'm missing about using them together ? The EXPANDBYROW works, but there are no links for the Drill-through. If i remove EXPANDBYROW, then the links show up and work as expected. See my Code Below:

 TABLE FILE SAP/DOLLAR_LIST/ZSD_DOLLAR_LIST
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
     COMPUTE Gross_Revenue_T;
     COMPUTE Discount_T;
     COMPUTE Discount_Perc;
     COMPUTE Net_Revenue_T;
     COMPUTE Cost_T;
     COMPUTE GM;
     COMPUTE GM_Perc;
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Division_Name
ON TABLE SUBHEAD
"GM per Customer"
"&Bill_Start_Date - &Bill_End_Date"
ON TABLE SUBFOOT
"*All dollar values listed in thousands of dollars"
WHERE ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Organization EQ 'US22' AND ( ZSD_DOLLAR_LIST.INTERCOMPANY_LIST.Intercompany_Std EQ &Intercompany_Std.(OR(<Intercompany,Intercompany>,<Standard,Standard>|FORMAT=A20)).Intercompany / Std.) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date GE &Bill_Start_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date Start:.QUOTEDSTRING ) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date LE &Bill_End_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date End:.QUOTEDSTRING ) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.ISDISCOUNT EQ &ISDISCOUNT.(OR(<Discounted,Discounted>,<Not Discounted,Not Discounted>|FORMAT=A20)).Discount:.) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Domestic_International EQ &Domestic_International.(OR(<Domestic,Domestic>,<International, International>|FORMAT=A20)).Domestic / International:.) AND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description EQ &Sales_Document_Description.(OR(FIND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description,ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description IN zsd_dollar_list|FORMAT=A20V)).Sales_Document_Description.;
ON TABLE SET GRWIDTH 1
ON TABLE SET EXPANDBYROW ON
ON TABLE SET AUTOFIT OFF
ON TABLE SET ASNAMES ON
ON TABLE RECOMPUTE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET CACHELINES 100
ON TABLE SET HTMLEMBEDIMG ON
TYPE=DATA,
     COLUMN=N2,
     COLOR='WHITE',
     FOCEXEC=IBFS:/WFC/Repository/SAP/DOLLAR_LIST/GM_per_Customer_by_Order.fex( \
     Bill_End_Date=&Bill_End_Date.QUOTEDSTRING \
     Bill_Start_Date=&Bill_Start_Date.QUOTEDSTRING \
     Domestic_International=&Domestic_International.QUOTEDSTRING \
     Intercompany_Std=&Intercompany_Std.QUOTEDSTRING \
     ISDISCOUNT=&ISDISCOUNT.QUOTEDSTRING \
     Sales_Document_Description=&Sales_Document_Description.QUOTEDSTRING \
     Sold_To_Party_Name=N2 \
     ),
$
ENDSTYLE
END


I stripped as much as i could so it wouldn't be a wall of text here, hopefully i didn't omit anything that's causing the issue. Is it possible that my Multi-Verb is part of the problem ?

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


Greg Coley
 
Posts: 11 | Location: Pittsburgh, PA | Registered: February 13, 2019Report This Post
Virtuoso
posted Hide Post
According to the manual:
  
The following requirements must be taken into consideration when creating Accordion Reports:

    Adding a drill-down link to an Accordion Report requires that the TARGET parameter must be set to a value that specifies a new HTML frame.


Can you try adding
  , TARGET='_blank'

to your drill down?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Member
posted Hide Post
quote:
TARGET='_blank'

Thanks for the the info. However, i still get the same results. Code Below:
  
TABLE FILE SAP/DOLLAR_LIST/ZSD_DOLLAR_LIST
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
SUM 
     ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3/P15C:D NOPRINT 
     COMPUTE Gross_Revenue_T;
     COMPUTE Discount_T;
     COMPUTE Discount_Perc;
     COMPUTE Net_Revenue_T;
     COMPUTE Cost_T;
     COMPUTE GM;
     COMPUTE GM_Perc;
BY TOTAL HIGHEST ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Subtotal_3 NOPRINT 
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sold_To_Party_Name
BY  ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Division_Name
ON TABLE SUBHEAD
"GM per Customer"
"&Bill_Start_Date - &Bill_End_Date"
ON TABLE SUBFOOT
"*All dollar values listed in thousands of dollars"
WHERE ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Organization EQ 'US22' AND ( ZSD_DOLLAR_LIST.INTERCOMPANY_LIST.Intercompany_Std EQ &Intercompany_Std.(OR(<Intercompany,Intercompany>,<Standard,Standard>|FORMAT=A20)).Intercompany / Std.) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date GE &Bill_Start_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date Start:.QUOTEDSTRING ) AND ( ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Bill_Date LE &Bill_End_Date.(FROM 20170101 TO &YYMD|FORMAT=YYMD).Bill Date End:.QUOTEDSTRING ) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.ISDISCOUNT EQ &ISDISCOUNT.(OR(<Discounted,Discounted>,<Not Discounted,Not Discounted>|FORMAT=A20)).Discount:.) AND (ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Domestic_International EQ &Domestic_International.(OR(<Domestic,Domestic>,<International, International>|FORMAT=A20)).Domestic / International:.) AND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description EQ &Sales_Document_Description.(OR(FIND ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description,ZSD_DOLLAR_LIST.ZSD_DOLLAR_LIST.Sales_Document_Description IN zsd_dollar_list|FORMAT=A20V)).Sales_Document_Description.;
ON TABLE SET GRWIDTH 1
ON TABLE SET AUTOFIT OFF
ON TABLE SET ASNAMES ON
ON TABLE RECOMPUTE AS 'Total'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET CACHELINES 100
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/WFC/Repository/SAP/DOLLAR_LIST/warm_IPEGEXPANDING.sty,
$
     ORIENTATION=LANDSCAPE,
     TITLETEXT='&WF_TITLE',
$
TYPE=REPORT,
     FONT='IBIDEFAULT',
     SIZE=12,
     COLOR=RGB(20 20 20),
     ARGRAPHENGINE=JSCHART,
$
TYPE=DATA,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(215 215 215),
     BORDER-BOTTOM-COLOR=RGB(215 215 215),
     BORDER-LEFT-COLOR=RGB(215 215 215),
     BORDER-RIGHT-COLOR=RGB(215 215 215),
$
TYPE=DATA,
     COLUMN=N2,
     FOCEXEC=IBFS:/WFC/Repository/SAP/DOLLAR_LIST/GM_per_Customer_by_Order.fex( \
     Bill_End_Date=&Bill_End_Date.QUOTEDSTRING \
     Bill_Start_Date=&Bill_Start_Date.QUOTEDSTRING \
     Domestic_International=&Domestic_International.QUOTEDSTRING \
     Intercompany_Std=&Intercompany_Std.QUOTEDSTRING \
     ISDISCOUNT=&ISDISCOUNT.QUOTEDSTRING \
     Sales_Document_Description=&Sales_Document_Description.QUOTEDSTRING \
     Sold_To_Party_Name=N2 \
     ),
          TARGET='_blank',
$
TYPE=TABHEADING,
     COLOR=RGB(75 75 75),
     STYLE=BOLD,
     JUSTIFY=LEFT,
$
TYPE=TABHEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=TABHEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='HELVETICA',
     SIZE=24,
$
TYPE=TABHEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=BOLD+ITALIC,
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='HELVETICA',
     SIZE=24,
     STYLE=NORMAL,
$
TYPE=SUBTOTAL,
     BORDER-LEFT=LIGHT,
     BORDER-LEFT-COLOR='BLACK',
$
TYPE=GRANDTOTAL,
     BORDER-TOP=OFF,
     BORDER-LEFT=LIGHT,
     BORDER-TOP-COLOR=RGB(102 102 102),
     BORDER-LEFT-COLOR='BLACK',
$
ENDSTYLE
END


Greg Coley
 
Posts: 11 | Location: Pittsburgh, PA | Registered: February 13, 2019Report This Post
Virtuoso
posted Hide Post
What happens if you expand all the way to Division? I think the drill is only available at the lowest BY field.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 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] EXPANDBYROW and Drillthrough

Copyright © 1996-2020 Information Builders