Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster: Passing a variable from the main fex to the dynamic list fex
Go
New
Search
Notify
Tools
Reply
  
ReportCaster: Passing a variable from the main fex to the dynamic list fex
 Login/Join
 
Member
posted
So I have a few reports that I need to FTP burst to different locations. They will all be bursting on the same burst VALUE, but depending on what report it is, each report will have a different DEST. Is it possible to have a compute field in the fex that creates the dynamic list:


TABLE FILE LIST
PRINT VALUE
COMPUTE DEST/A20V = '/Home/' || '&FOLDER_NAME' || '/' || VALUE || '.pdf';
ON TABLE PCHOLD
END

and have &FOLDER_NAME come from the main fex?

I tried to provide this as a parameter in the schedule under Task/Paramaters but without any luck.
I also tried to create a hold file in the main fex and access it from the dynamic list fex but to no avail. Is this even possible?
The fex that creates the dynamic list, is it run before or after the main fex?


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: July 23, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
Is this even possible?
My favorite anser to this is: Yes, we can do that in WebFOCUS.

I create the Dynamic Distribution List (DDL) in "the main fex" which creates a XML file which in turn is used as the DDL in the Distribution section of the RC job.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Currently with Fidelity Investments
 
Posts: 3052 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Great. Glad to hear its possible. A noob follow up question then:

So if the main fex is creating the list on the fly, how do you reference that in the Distribution section of the RC job?


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 2 | Registered: July 23, 2014Reply With QuoteReport This Post
Master
posted Hide Post
Hi,

Refer to below forum posts. You need to use RC system variables to get necessary details.

Page 12 of below best practice document.
http://documentation.informati...stpractices_7611.pdf


http://forums.informationbuild...087036216#4087036216


Hope this will give you an idea. At runtime, reading BOTSCHED and BOTPARAM table using SCHEDULEID you can meet your requirement.

Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Ram,

Thanks for the document.
It seems however that those RC parameters like &DSTSCHEDID are available in the procedures called from the tasks in the RC schedule, but they are not available in the fex called to retrieve the dynamic list (the Dynamic Address Procedure in the Distribution tab of ReportCaster). Or am I wrong?

It occasionally happens to us if two RC schedules finish about the same time that one schedule will use the dynamic list created by the other schedule.
Do you have a way to prevent this?

Martin.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster: Passing a variable from the main fex to the dynamic list fex

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.