How to apply more condition for Drill condition

Dear Sir,

We can use condition to control a special value cannot drill down, but when we want to control more values, we cannot found how to do it. Are there any one have the experience. Your responses are appricate. Thank you

Best Regards,
B. H. Tang

Posts: 4 | Registered: May 03, 2007

BlueZone

Platinum Member

posted

Hide Post

Tang :
Please explain the kinds of conditions in more detail if you could. That will help you get specific answers.

If you are talking about supressing drilldown on various conditions, here are couple of ways that we do it -
1>> Bypass the drilldown statement in the stylesheet by using DM statements

ON TABLE SET STYLE *
-IF &VAR1 EQ 'X' GOTO LBL_SKPDRLL;
-IF &VAR2 EQ 'Y' GOTO LBL_SKPDRLL;
TYPE=DATA,OBJECT=FIELD,ITEM=1,FOCEXEC=......
-LBL_SKPDRLL
ENDSTYLE

2>> Or you can dynamically comment out Drilldown statements by assigning '-*' to the front like this..

-SET &COM1=IF (&VAR1 EQ 'X') OR (&VAR2 = 'Y')
- THEN '-*' ELSE ' ' ;
-*
ON TABLE SET STYLE *
&COM1.EVAL TYPE=DATA,OBJECT=FIELD,ITEM=1,FOCEXEC=......
ENDSTYLE

Best Regards,
Sandeep Mamidenna

-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!

Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006

Ignored post by BlueZone posted

Show Post

Francis Mariani

Expert

posted

Hide Post

Are you talking about conditional drill-downs using 'WHEN'?

If so, you have to DEFINE a field that contains the multiple conditions. e.g.:

DEFINE FILE CAR
DD1/A03 = IF SALES GT 1000 AND WHEELBASE GT 2 THEN 'YES' ELSE 'NO';
END
TABLE FILE CAR
SUM
DD1 NOPRINT
WHEELBASE NOPRINT
SALES/D10
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=CALLJSP (COUNTRY=COUNTRY), WHEN= DD1 EQ 'YES', $
ENDSTYLE
END
-RUN

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, 2005

Ignored post by Francis Mariani posted

Show Post

B. H. Tang

Member

posted

Hide Post