TM1 Forum

Has anyone created a TM1 model that satisfies ANSI 748 Criteria for Earned Value Management?

I am working an an implementation, but it is not solely a TM1 based solution.

I am using a combination of MS Project Server and TM1 to achieve most of it.

I beleive we have talked before....

Have you "intergrated" the data from Project to TM1?

Yes. Through the ODBO connection I was able to bring over the Analysis Services cubes and process most of the data fairly easily. Right now I am synching the metadata between the two systems, which has been a challenge on the Project side based on what they will allow you to include in the analysis services cube. My major complaint with the current linkage is the amount of dimensions that the connection produces on the TM1 side, but I will trim that later via security.

Most of my time has been spent on structuring the metadata accordingly. Once that was done the linkage was simple. We spent alot of time getting our PMs on the same page when it came to their use of project and then the enterprise custom fields were used to tie to data between the systems.

Right now TM1 is acting as the calculator and the historical storage of what we reported on a monthly basis. Project Server itself holds and maintains the more operational numbers and baseline histories that are required since it can so so on a project by project basis.

All in all it is currently working pretty well. I have learned since I first started this that a TM1 ONLY model will not work out very well. Though it could be done in TM1 the historical records of things like the baseline are better done by systems that are better suited to handle individual project versions rather then just whole cube versions. It could be done just would not be very elegant.

My current schedule is to have it ready for certification by our customers by the end of the year.