S
Shawn Everingham
Using the Reporting database, I have a query ... well, the joins are below...
So...We have bereavement time set up as a custom value for administrative
time. We are pulling all administrative time and pushing the info to our time
keeping system.
Here's the deal...
I pulled all the administrative time for the month of March, using
TimeByDay. One of our resources filled out their timecard for 40 hrs
bereavement, saved and submitted...self approved timesheet. I notice this on
my audit report, specifically because he claimed 9 hrs every day, when we
work 8 hr days. He indicated to me that he had corrected those entries, in
fact, changed that time off, from Bereavement to a Management category in his
timesheet for that week. He was basically questioning my report, because it
was showing the bereavement time, when in actuality, his timecard reflected
something totally different.
I have rebuilt the cube. Refreshed the data...I can't for the life of me
figure out why it still thinks he has bereavement time.
Can anyone help? my last few posts have gone unanswered. Maybe I'm treading
in uncharted territory. I need some answers...please help me if you know
what's up...
thanks in advance.
dbo.MSP_TimesheetActual as ta
inner join dbo.MSP_TimesheetResource_OlapView as tr
on tr.ResourceNameUID = ta.LastChangedResourceNameUID
inner join dbo.MSP_TimesheetLine_OlapView as tl
on tl.TimesheetLineUID = ta.TimesheetLineUID
inner join dbo.MSP_TimesheetProject_OlapView as tp
on tp.ProjectNameUID = tl.ProjectNameUID
inner join dbo.MSP_EpmResource_UserView as er
on er.ResourceUID = tr.ResourceUID
inner join dbo.MSP_Timesheet_OlapView as ts
on ts.TimesheetUID = tl.TimesheetUID
inner join dbo.MSP_TimesheetPeriod_OlapView as p
on p.PeriodUID = ts.PeriodUID
inner join dbo.MSP_TimesheetClass_OlapView as tc
on tc.ClassUID = tl.ClassUID
inner join dbo.MSP_TimesheetTask_OlapView as tt
on tt.TaskNameUID = tl.TaskNameUID
So...We have bereavement time set up as a custom value for administrative
time. We are pulling all administrative time and pushing the info to our time
keeping system.
Here's the deal...
I pulled all the administrative time for the month of March, using
TimeByDay. One of our resources filled out their timecard for 40 hrs
bereavement, saved and submitted...self approved timesheet. I notice this on
my audit report, specifically because he claimed 9 hrs every day, when we
work 8 hr days. He indicated to me that he had corrected those entries, in
fact, changed that time off, from Bereavement to a Management category in his
timesheet for that week. He was basically questioning my report, because it
was showing the bereavement time, when in actuality, his timecard reflected
something totally different.
I have rebuilt the cube. Refreshed the data...I can't for the life of me
figure out why it still thinks he has bereavement time.
Can anyone help? my last few posts have gone unanswered. Maybe I'm treading
in uncharted territory. I need some answers...please help me if you know
what's up...
thanks in advance.
dbo.MSP_TimesheetActual as ta
inner join dbo.MSP_TimesheetResource_OlapView as tr
on tr.ResourceNameUID = ta.LastChangedResourceNameUID
inner join dbo.MSP_TimesheetLine_OlapView as tl
on tl.TimesheetLineUID = ta.TimesheetLineUID
inner join dbo.MSP_TimesheetProject_OlapView as tp
on tp.ProjectNameUID = tl.ProjectNameUID
inner join dbo.MSP_EpmResource_UserView as er
on er.ResourceUID = tr.ResourceUID
inner join dbo.MSP_Timesheet_OlapView as ts
on ts.TimesheetUID = tl.TimesheetUID
inner join dbo.MSP_TimesheetPeriod_OlapView as p
on p.PeriodUID = ts.PeriodUID
inner join dbo.MSP_TimesheetClass_OlapView as tc
on tc.ClassUID = tl.ClassUID
inner join dbo.MSP_TimesheetTask_OlapView as tt
on tt.TaskNameUID = tl.TaskNameUID