Hi Guys,
I have 2 DSOs for resources... 1 DSO is for the location of the resource and another one having contract hours per day.. below are the DSOs
DSO1 (bold are the key fields)
Resource Start date End date Location
15832 01-Oct-2010 03-Aug-2011 Z201
15832 15-Aug-2011 31-Aug-2011 Z509
15832 01-Sep-2011 30-Sep-2020 Z201
DSO2 (bold are the key fields)
Resource Start date End date Hrs. per day
15832 01-Oct-2010 09-Aug-2011 7
15832 10-Aug-2011 30-Sep-2020 8
Now in my report, I need the Location and Contract Hrs per day of a Resource on a Fiscal Period. What I am currently doing is distributing my each DSO for a period in the next layer. So, if have to do it for 10 years than I have 120 records for each resource. And then I do a look up with both the DSOs and get into one DSO3.
Is there any better way of doing it ?
Thanks,
Suresh