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     can i use more than one parameters in drilldown

Read-Only Read-Only Topic
Go
Search
Notify
Tools
can i use more than one parameters in drilldown
 Login/Join
 
<ammy>
posted
hi
any budy help for use a more than one parameters in drilldown i tired out with multiple drilldown but any other solution
 
Report This Post
Kamesh
Master
posted Hide Post
you can use more than one parameter in your drill down.

try like this,

-DEFAULT &PARAM1=5;
-DEFAULT &PARAM2='XXXXX';
-DEFAULT &PARAM3=100 ;

TYPE=DATA,COLUMN=P1(which column you want to do drilldown),JUSTIFY=RIGHT,
FOCEXEC=test(PARAM1=&PARAM1 \
PARAM2='&PARAM2.eval' \
PARAM3=&PARAM3) , $
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
<ammy>
posted
hi kamesh
actually i am taking value from fields
so how i can declare those value at defaults
see my code

-* File drill_demo.fex

JOIN
SALES_FACT.SALES_FACT.CUSTOMERKEY IN sales_fact TO
CUSTOMER_DIM.CUSTOMER_DIM.CUSTOMERKEY IN customer_dim AS J6
END
JOIN
SALES_FACT.SALES_FACT.PRODUCTKEY IN sales_fact TO
PRODUCT_DIM.PRODUCT_DIM.PRODUCTKEY IN product_dim AS J7
END
JOIN
SALES_FACT.SALES_FACT.TIMEKEY IN sales_fact TO TIME_DIM.TIME_DIM.TIMEKEY
IN time_dim AS J8
END
DEFINE FILE SALES_FACT
totalsales/D20.2=((LINEITEMQUANTITY + LINEITEMFRIEGHT) * LINEITEMTOTAL) * UNITPRICE;
END
TABLE FILE SALES_FACT
PRINT
totalsales
BY
CATEGORYNAME

ON CATEGORYNAME SUBTOTAL AS '*TOTAL CATEGORYNAME'
WHERE ( CATEGORYNAME EQ '&Category.(,,,,,
,,
.Category.' ) AND
( YEAR EQ &Year.(<1996,1996>,<1997,1997>,<1998,1998>Wink.Year. );
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=CATEGORYNAME,JUSTIFY=RIGHT,
FOCEXEC=DRILL1_TEST(Category='&Category.EVAL'\Year=&Year),
$
TYPE=TITLE,
COLUMN=N1,
FOCEXEC=DRILL1_TEST,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
<DocServices>
posted
Hi,

For information on parameters in a drill down report, please see the section titled "Creating a Parameter" in Chapter 4 (Creating Reports With the Report Painter) in the "Creating Reports With Graphical Tools Version 5.3 manual (DN2102020.0904).

As always, this forum is another source for answering your questions.

Have a great day.
Jennifer
 
Report This Post
Kamesh
Master
posted Hide Post
Hi Ammy,
The one I shown is just for example. That's the way to add multiple parameters to drilldown.

If you are using Database field, you can use the name directly on your focexec

ex:
DEFINE FILE TEST
FIELD1/A10='XXXX';
END

TABLE FILE TEST
BY XXXX
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=P1,FOCEXEC=TEST(FIELD1=FIELD1 \
FIELD2='&FIELD2'),$
ENDSTYLE
END

\ - USED FOR CONCATENATION. IF YOU ARE GIVING YOUR PARAMETERS IN THE SAME LINE, NO NEED OF USE THIS.

EX:
TYPE=DATA,FOCEXEC=TST(FIELD1=FIELD1 FIELD2=FIELD2)

Hope I answered your question,

Thanks
Kamesh
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
<ammy>
posted
hi jennifer
i go through the mannual but its working for one parameter in drill down but i want to use
more than one parameter i am tried but its not working
can u help me
 
Report This Post
<ammy>
posted
its not working
please refer my code
you may get some idea
 
Report This Post
Leo L
Gold member
posted Hide Post
I noticed you used the &Category variable just to compare it to the field name CATEGORYNAME...
Also, anytime you use an "&" variable in a drilldown, it has to be in single quotes... I noticed Year was not in quotes and would cause errors.

this should work:

TYPE=DATA,
COLUMN=CATEGORYNAME,JUSTIFY=RIGHT,
FOCEXEC=DRILL1_TEST(Category=CATEGORYNAME, Year='&Year'),
$

Leo
 
Posts: 96 | Location: Winnipeg, Manitoba, Canada | Registered: January 22, 2004Report This Post
<DocServices>
posted
Ammy,

Okay, here is another option for related documentation. Go to the "Creating Reports With WebFOCUS Language 5.3" manual (DN4500580.0904).

In Chapter 10 (Linking Reports to Other
Resources) there is a topic called "Creating Parameters" and in that topic there is an example called "Using Multiple Parameters."

Hope this helps.

-Jenn
 
Report This Post
reFOCUSing
Guru
posted Hide Post
ammy, what errors are you getting? Are you trying to create the report using the gui or a text editor?
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
<ammy>
posted
thanks to all
now its working
 
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     can i use more than one parameters in drilldown

Copyright © 1996-2020 Information Builders