 |
|||||
|
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 [CLOSED] dynmaic distribution fex burst variable
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynmaic distribution fex burst variable Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] dynmaic distribution fex burst variable | Login/Join |
| Platinum Member |
hi, I am using the dynamic Distribution. that means i need a fex in the repository area, where my dest an value needs to be defined. because it's an SQL Report, I also Need to define my SQL in the dynamic Distribution fex. now the Problem is, that I need to set variables for the date dynamically. but I have no idea how to tell the Distribution fex, what the values for the fex are.. in my normal fex (the one I write in the Task of the Scheduler) gets it's variable Definition from the prarameters in the Task of the Scheduler. where does the dynamic Distribution fex get ist variables from ??This message has been edited. Last edited by: FP Mod Chuck, WebFOCUS 8.1.05 Windows, All Outputs | ||
|
| Platinum Member |
Hi Jenni, This is indeed an issue. You can not pass parameters (directly) to the dynamic distribution fex. At least not upto the version we are using, maybe in newer version it has improved, but I have not heard about it. The way we go about this is to write parameters from the scheduled task fex to a disk file, and the dynamic distribution fex reads this disk file. This disk file needs to have a fixed static name however, which can cause concurrency issues when 2 ReportCaster jobs with dynamic distribution run at the same time, so it should be created at the end of the scheduled task, and in scheduling we try to prevent thise jobs to run simultaneously. I am curious if in newer versions there are improvements on this, or maybe other users have found better ways to go about this issue. Martin. WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster | |||
|
| Platinum Member |
ReportCaster does pass internal variables like &DSTSCHEDID to the fex called in the tasks, but unfortunately even those are not passed to the dynamic ditribution list procedure. Martin. WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster | |||
|
| Platinum Member |
ja, thats the Problem.. do you know if the dynamic fex would accept global variables? WebFOCUS 8.1.05 Windows, All Outputs | |||
|
| Virtuoso |
Jenni Unfortunately no. I tried that and it did not work. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynmaic distribution fex burst variable
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynmaic distribution fex burst variableCopyright © 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 |