 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point run fex with different parameters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point run fex with different parameters Read-Only TopicGo | Search | Notify | Tools |
| run fex with different parameters | Login/Join |
| Virtuoso |
I have a fex that needs to run several times a month with different parameters. I created a fex like this EX myfex COUNTRY=ITALY, OUTPUT=EXL2K EX myfex COUNTRY=ENGLAND, OUTPUT=EXL2K (the country and output are both amper variables in "myfex") If I run this than the browser would open two excel sheets with the same name. If I run this via ReportCaster I only get the first excel sheet in my mailbox. Any suggestions?
| ||||||
|
| Expert |
Can you run myfex just once with multiple values for the variable and use SET COMPOUND=BYTOC? Or will that not give you what you want? Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
Frank, If I run an equivalent of your code then I do not get two browser windows open, I only get the first Excel workbook. However, that may not be important. Do you need two outputs from RC? If so set up separate tasks for each. One other method of getting two reports on the same browser without merging, is to use a method posted in the Forum quite a while ago - BYTOC with CGIVARS. The code is simple to apply to your example - -TYPE WEBFOCUS CGIVAR IBIWF_mreports=INDEX -TYPE WEBFOCUS CGIVAR IBIWF_index=OFF -TYPE WEBFOCUS CGIVAR IBIWF_mprefix=Description Report 1 EX myfex COUNTRY=ITALY, OUTPUT=EXL2K -RUN -TYPE WEBFOCUS CGIVAR IBIWF_mprefix=Description Report 2 EX myfex COUNTRY=ENGLAND, OUTPUT=EXL2K -RUN You will still get the "same file name" message (even with DHagan's fix) as they are run within the same agent process, but it does provide a nice output. This would also make a good alternative for those report writers out there who want to be able to provide multiple reports within the same frame set-up (this uses frames but you don't have to code them  !!).T
| |||||||||
|
| Virtuoso |
And what about a compound excel report? Would that be a solution for you? In that case you could have one excel sheet with two worksheets, so you'd only have 1 excel file. GamP
| |||||||||
| ||||||||||
| Virtuoso |
The client wants separate spreadsheets and if possible with different names, so I think at the end the RC solution will be the best and I will try if I can use the burst option. The field "COUNTRY" will be the burst value.
| |||||||
|
| Expert |
Frank, There is another alternative to the BYTOC indexing above to give you multiple Excels in one HTML page - -TYPE WEBFOCUS CGIVAR IBIWF_mreports=frame EX myfex COUNTRY=ITALY, OUTPUT=EXL2K -RUN EX myfex COUNTRY=ENGLAND, OUTPUT=EXL2K -RUN T
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point run fex with different parameters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point run fex with different parametersCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |