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     [CLOSED] dynmaic distribution fex burst variable
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] dynmaic distribution fex burst variable
 Login/Join
 
Platinum Member
posted
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
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 152 | Registered: March 29, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
ja, thats the Problem.. do you know if the dynamic fex would accept global variables?


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1560 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dynmaic distribution fex burst variable

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