Distribution by email using publisher query

[hopkinsc]

Hi everyone.

I have a task set up to distribute via email some regional reports. The problem i am getting is that some of the regional supervisors are receiving other regional reports too.

The reason for this is i am reducing the data by a field called [Operative Region], and when operatives complete jobs in other regions it then send the 2 regional reports to the one regional supervisor.

e.g.

If an operative from the EAST team completes a job in the WEST area then the regional supervisor for the EAST will receive a report for the EAST and WEST.

I have recently made changes so that in the example above the job will be reported against the operator rather than the region but any hisorical jobs don't change. meaning that the YTD figures are still going to trigger the WEST email to go to the EAST regional supervisor.

I hope this makes sense..

I only want the reports to go to their own regional supervisors.

Can anyone help?

[hallquist_nate]

I see this two ways.  You can configure the report to use the Operative's home region, as apposed to the Jobs Region.  the other thing you could do is use a Mapping Load to correct the historical data.  I think either way, you are going to have to do a full reload, which it seems like you do not want to do.

Hope this helps.