Hi Suman,
Yes, understood. Doing so perpetuates problems/complexities with report design. However, this might allow us to avoid migrating the historic data from indirect to other work. The indirect work is not that valuable to the business – its value isn’t zero, but it approaches zero real quick, say after a year.
I’ll put this forward to the team:
- Future: All reporting out of DWH with Jaspersoft, with Indirect as Other Work
- Historic: Will have an ‘Historic Indirect” report
o it will look at ‘obsolete’ Indirect data source
o it will be available for a year
o then it will be made inactive
A report for ‘Historic Indirect’ should be small effort, vs. large or XL effort for migration. Also, if value of this indirect is low enough, we ought to ask ourselves, why even collect it in the first place. Maybe all we need is one “Other Work” instance for this kind of thing, named “I’m not here” – just for project scheduling/availability concerns.
Dale