A
Astro Boy
We have run across a strange behavior (strange to me, at least) that
Microsoft claims is part of the MOPS 2007 design.
When you delete timesheets using PWA>Delete Enterprise Objects, the
data from those deleted teimsheets remains in the Reporting database.
Our scenario is this:
Prior to going live on MOPS, we did a lot of training using the to-be-
production system. At the end of training, we deleted all projects and
timesheets, then also deleted all timesheet periods. We then created
new timesheet periods, started loading projects, and began using new
timesheet periods to create new timesheets and report project and non-
project (Admininstrative Time Categories) time.
Now we are seeing info from the timesheets used in training appearing
in our Data Analysis views and our Reporting database.
We have a case open with Microsoft Premier Support. The engineer there
is telling us this is designed behavior. I can't imagine why this is -
delete means DELETE, right? Apparently not so here.
Can anyone explain to my why you might want to keep data from deleted
timesheets in the Reporting db? Does anyone know how to remove this
data from Reporting, or at least filter it out?
Thanks in advance!
AB
Microsoft claims is part of the MOPS 2007 design.
When you delete timesheets using PWA>Delete Enterprise Objects, the
data from those deleted teimsheets remains in the Reporting database.
Our scenario is this:
Prior to going live on MOPS, we did a lot of training using the to-be-
production system. At the end of training, we deleted all projects and
timesheets, then also deleted all timesheet periods. We then created
new timesheet periods, started loading projects, and began using new
timesheet periods to create new timesheets and report project and non-
project (Admininstrative Time Categories) time.
Now we are seeing info from the timesheets used in training appearing
in our Data Analysis views and our Reporting database.
We have a case open with Microsoft Premier Support. The engineer there
is telling us this is designed behavior. I can't imagine why this is -
delete means DELETE, right? Apparently not so here.
Can anyone explain to my why you might want to keep data from deleted
timesheets in the Reporting db? Does anyone know how to remove this
data from Reporting, or at least filter it out?
Thanks in advance!
AB