Skip to Content
0
Former Member
Dec 07, 2011 at 10:26 AM

Modelling question

26 Views

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