how do I 'freeze' project data / create a snapshot history?

[stu futrill]

Hi

I hope someone can offer a solution to this ...
I need to 'freeze' all project data in the SQL tables at a
given point in time. This will allow me to build up a
picture of how the projects were performing over time.
For example I need to have data frozen in line with month
end financial reports. If a team member submits his
timesheet after the month end cut off then financially
his/her hours should go into the next month. But on
Project his/her hours would obviously go against when the
work was done.

So how can I achieve this?
I have thought about using new OLAP cubes each time I want
data frozen, but I don't think this is a good idea.
My only other thoughts are to extract the data into
MSaccess or MSexcel, and build up a history this way.

Any ideas greatly appreciated?

Stuart.

 

[Jack D.]

Hi

I hope someone can offer a solution to this ...
I need to 'freeze' all project data in the SQL tables at a
given point in time. This will allow me to build up a
picture of how the projects were performing over time.
For example I need to have data frozen in line with month
end financial reports. If a team member submits his
timesheet after the month end cut off then financially
his/her hours should go into the next month. But on
Project his/her hours would obviously go against when the
work was done.

So how can I achieve this?
I have thought about using new OLAP cubes each time I want
data frozen, but I don't think this is a good idea.
My only other thoughts are to extract the data into
MSaccess or MSexcel, and build up a history this way.

Any ideas greatly appreciated?

Stuart.

You can create a new table in the database to hold the extracted data.
Use a stored procedure or even access as a front end to extract the data and
store it in a useful manner (obviously you don't need all the information,
so pull out what you think you need) include a time period in each record
and you can easily query the table for different time periods.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++