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,

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.

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.

ja, thats the Problem.. do you know if the dynamic fex would accept global variables?

Jenni

Unfortunately no. I tried that and it did not work.