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     Drill Down when All option is selected

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Drill Down when All option is selected
 Login/Join
 
<Sengott>
posted
Hi,

I have 4 user selectable prompts, and their default value is "ALL".

My problem is that when i select any one prompts as "ALL", the drill down is not working.

But when i make sure that i dont select ALL in the prompt, my drill down works fine.

Kindly help me

Regards

Sengot
 
Report This Post
codermonkey
Platinum Member
posted Hide Post
without seeing the code, my first guess is that you are not bypassing the WHERE statement. I'm assuming when the user picks any other value from the drop down you are passing it to a WHERE statement:

WHERE field1 EQ '&var1'
If you don't bypass this WHERE when the user selects ALL you are probably checking for:
WHERE field1 EQ 'ALL' which I'm assuming isn't a valid value.

There are a number of techniques to bypass the WHERE on an 'ALL' condition depending on your release. The quickest might be to bypass the WHERE using Dialog Manager.

If I'm way off base, please post your code and that will help.

Good Luck!
 
Posts: 118 | Location: DC | Registered: May 13, 2005Report This Post
<Sengott>
posted
Hi,

I am attaching the code here, I have enabled All option available in the HTML Layout viewer

Main Code

JOIN
A1.A TO MULTIPLE A1.B J0
END
GRAPH FILE A
SUM CNT.A2
ACROSS A3
BY A3
WHERE ( A4 EQ '&Platform.(FIND A4 IN A).Plate.' );
WHERE ( A5 EQ '&Ent.(FIND A5 IN A).Ent.' );
WHERE ( A6 EQ '&VP.(FIND A6 IN A).VP.' );
WHERE ( A7 EQ '&BPO.(FIND A7 IN A).BPO.' );

ON GRAPH SET STYLE *
TYPE=DATA,
ACROSSCOLUMN=N1,
TARGET='DRILLOUTPUT',
FOCEXEC=app/el7hpmp3.fex(Version=A1 Plate='&Plate
' Ent='&Ent' VP='&VP' BPO='&BPO'),
$
ENDSTYLE
END

---------------------
 
Report This Post
<Sengott>
posted
Drilled Report

JOIN
A1.A TO MULTIPLE A1.B J0

END
TABLE FILE T_ORA_DBAS_V
PRINT
A9
A11
A8
BY A6_N
BY A7_N
WHERE ( A3 '&Ver' ) AND ( A4 EQ '&Plate' ) AND ( A5 EQ '&Ent' ) AND ( A6 EQ '&VP' ) AND ( A7 EQ '&BPO' );
END
 
Report This Post
Francis Mariani
Expert
posted Hide Post
Your "ALL" option probably uses 'FOC_NONE' as the value, when this is put into a WHERE statement, the whole line is ignored. Separate your WHERE statements:

Instead of

WHERE ( A3 '&Ver' ) AND ( A4 EQ '&Plate' ) AND ( A5 EQ '&Ent' ) AND ( A6 EQ '&VP' ) AND ( A7 EQ '&BPO' );

do

WHERE ( A3 '&Ver' ) ;
WHERE ( A4 EQ '&Plate' ) ;
WHERE ( A5 EQ '&Ent' ) ;
WHERE ( A6 EQ '&VP' ) ;
WHERE ( A7 EQ '&BPO' ) ;


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
<Sengott>
posted
I have tried this out, but my problem is The drill down just does not happen when any one or all prompts has All selected, It does not shows me an error, an blank page. It is does nothing as though nothing has been clicked.
 
Report This Post
dhagen
Virtuoso
posted Hide Post
When you say the drill-down is not working ... if what you mean is that the link is no longer there, then it is a different problem.

Francis is correct when he stated the entire line will be ignored. This would include the drill down line in the style sheet. To avoid these problems, always use the .EVAL when building your drill down link with ampher variables. Example:

TYPE=DATA,
COLUMN=N1,
TARGET='_self',
FOCEXEC=d4_step_02(RPT_DATE='&RPT_DATE.EVAL' LVL_1=N1),
$


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Francis Mariani
Expert
posted Hide Post
To add to dhagen's comments, if you have a hyperlink, right-click and copy it and then paste it somewhere - examine the link, does it look right?


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
Piipster
Guru
posted Hide Post
quote:
FOCEXEC=app/el7hpmp3.fex(Version=A1 Plate='&Plate
' Ent='&Ent' VP='&VP' BPO='&BPO'),



Try putting your parameters in your drill-down code on separate lines. If FOC_NONE causes a line to be ignored it will be only that one variable.

FOCEXEC=app/e17hpmp3.fex( \
Version=A1 \
Plate='&Plate' \
Ent='&Ent' \
VP='&VP' \
BPO='&BPO' \
),


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
<Sengott>
posted
Sengot

Thank Piipster, Francis Mariani and codermonkey

Now I am able to achieve that functionality

Sengot
 
Report 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     Drill Down when All option is selected

Copyright © 1996-2020 Information Builders