Monthly Archives: January 2012

Capturing Custom Timescaled Data in Project Server (Part IV)

With this post, we’re pretty much at the finish line.  Now that we have the macro, the baseline mechanics, and the query all figured out, it’s time to flex those Excel muscles and see if we can’t generate a report … Continue reading

Posted in BI, VBA | Tagged | 1 Comment

Capturing Custom Timescaled Data in Project Server (Part III)

So the pieces are starting to come together.  In the last post, I showed you how to write a macro to copy the BCWP data into the Baseline10 Cost timescaled fields.  In the post before that, I discussed how we … Continue reading

Posted in BI, VBA | Tagged | 1 Comment

Capturing Custom Timescaled Data in Project Server (Part II)

First off, let me preface this post with the comment that all customizations should be tested – especially a solution which edits timescaled data.  Solutions such as these are often prone to memory leaks, and as such, it behooves you … Continue reading

Posted in BI, VBA | Tagged | 4 Comments

Capturing Custom Timescaled Data in Project Server (Part I)

Well, it’s that time of year again, the down time between the solar and lunar new year festivities when we bid farewell to 2011 and welcome to the year of the water dragon.   This year, as I attempt to forestall … Continue reading

Posted in BI, VBA | Tagged | 6 Comments