February 11, 2008, 05:01 PM
FrankDutchrun fex with different parameters
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?
February 11, 2008, 06:10 PM
GinnyJakesCan 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?
February 12, 2008, 02:55 AM
Tony AFrank,
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
February 12, 2008, 04:42 AM
GamPAnd 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.
February 12, 2008, 05:13 AM
FrankDutchThe 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.
February 12, 2008, 05:16 AM
Tony AFrank,
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