Archive for February, 2009
Add Time Hierarchy in Project Server 2007 Cubes
28 February 2009{
{
WriteMessage(”Start Cube Extension”);
Server OLAPServer = new Server();
OLAPServer.Connect(”Data Source=” + e.ServerName + “;Provider=msolap;”);
WriteMessage(”Analysis service server connected:” + e.ServerName);
Database EPMOLAP = OLAPServer.Databases.FindByName(e.DbName);
if (EPMOLAP == null)
{
EventLog.WriteEntry(LogSource, “Database: ” + e.DbName + ” does not exist in Project Server 2007 cube.”, EventLogEntryType.Error);
return;
}
Dimension dmnTime = EPMOLAP.Dimensions[TimeDimensionID];
{
EventLog.WriteEntry(LogSource, “Time dimension does not exist.”, EventLogEntryType.Error);
return;
}
if (dmnTime.Hierarchies.FindByName(NewTimeDimensionName) != null)
{
EventLog.WriteEntry(LogSource, “New Time hierarchy has already been created by other process.”, EventLogEntryType.Error);
return;
}
Hierarchy NewTime = dmnTime.Hierarchies.Add(NewTimeDimensionName);
DimensionAttribute atrYear = dmnTime.Attributes.FindByName(YearAttributeName);
if (atrYear == null)
{
EventLog.WriteEntry(LogSource, “Year attribute does not exist in Time dimension.”, EventLogEntryType.Error);
return;
}
DimensionAttribute atrWeek = dmnTime.Attributes.FindByName(WeekAttributeName);
if (atrWeek == null)
{
EventLog.WriteEntry(LogSource, “Week attribute does not exist in Time dimension.”, EventLogEntryType.Error);
return;
}
DimensionAttribute atrDay = dmnTime.Attributes.FindByName(DayAttributeName);
if (atrDay == null)
{
EventLog.WriteEntry(LogSource, “Day attribute does not exist in Time dimension.”, EventLogEntryType.Error);
return;
}
Level lvlYear = PPGTime.Levels.Add(YearLevelName);
lvlYear.SourceAttributeID = atrYear.ID;
Level lvlWeek = PPGTime.Levels.Add(WeekLevelName);
lvlWeek.SourceAttributeID = atrWeek.ID;
Level lvlDay = PPGTime.Levels.Add(DayLevelName);
lvlDay.SourceAttributeID = atrDay.ID;
// save the changes to database.
dmnTime.Update();
WriteMessage(”Complete Cube Extension”);
catch (Exception ex)
{
EventLog.WriteEntry(LogSource, ex.ToString(), EventLogEntryType.Error);
}
}
Popularity: unranked [?]
Project Server Experts February FAQ Updates
28 February 2009MSProjectExperts is pleased to summarize the updates we made to our free http://www.projectserverexperts.com FAQs and support knowledgebase during the month of February. We hope you find these informative and useful.
Common Errors:
Microsoft Office Project Professional 2007 is required for this action
Explains how a Project Options setting can cause this error
Server Error In Application: Object reference not set to an instance of an object
Shows how to resolve this error if due to an unstable web part in the page
The query could not be processed displays on the Data Analysis page
Updated to include more causes and troubleshooting steps for the inability to render OLAP views in Project Server 2007
Developers:
Set the Data Access timeout in Project Server 2007
Use a PSI Method to set the data access layer timeout value for Project Server 2007
How To:
Understand the color-coding of tasks in the My Tasks page
Explains color coding values on the My Tasks page in Project Server 2007
Set the session timeout value in SharePoint
Simple instructions to set the session timeout value in SharePoint
Find Actual Overtime Work and Planned Overtime Work in the OLAP cubes
Explains where to find these values in the OLAP cubes
Understand Actual Work, Actual Work Billable, and Overtime Work Billable in Project Server 2007
A primer on working with billable work types in Project Server 2007
Change the Date Format on the My Tasks Page
Shows you how to manipulate the My Tasks page display in Project Server 2007
Use Team Resources in a project
Updated to reflect changes in behavior included in recent updates to Project Server 2007
Understand the SharePoint container hierarchy and nomenclature
A brief primer on the SharePoint container structure in WSS 3.0
Popularity: unranked [?]
Blog Moved
28 February 2009

Popularity: unranked [?]
Project 2009 Conference
28 February 2009 
Save $150 by being one of the first 500 attendees to register! Register now at https://pc2009.dynamiceventsreg.com/ to secure your Early Bird discount rate of $699.
And, we wanted to be sure you also received this: Your personal invitation to present at Project Conference.
New this year! The Project Conference team has received a tremendous amount of interest from customers and partners to present content at Project Conference 2009. In response, we are formally offering customers, partners and you an opportunity to contribute to and present content at Project Conference 2009. We encourage customers, partners and you to utilize the content submission form at https://pc2009cfc.dynamiceventsreg.com to propose content ideas and speakers. Time is limited – let your customers and partners know and act now!
=”" width=”0px” height=”0px” src=”http://c.live.com/c.gif?NC=31263&NA=1149&PI=73329&RF=&DI=3919&PS=85545&TP=yasirbutt.spaces.live.com>1=Yasirbutt”>
Popularity: unranked [?]
Project Pro: Overallocated or not?
28 February 2009Quick webcast today on overallocation, and looking at the calendar and fine level time phasing to see why Project thinks the way it does.
Shortly after recording this I also discovered that if you have actual work equal to the planned work in the scenario described then it does not show in red as overallocated. I guess if you managed to work 2 hours in 1 hour then not worth re-planning
.
Popularity: unranked [?]
Project Server 2007: Rollup Podcast for w/c 2/23/2009
28 February 2009Another podcast rollup of the week’s events. Enjoy!
Popularity: unranked [?]
Project Server 2007: The continuing saga of check-in pending
27 February 2009Thank you all for your continued feedback saying we still haven’t nailed this – and the offers of copies of caches and repro steps. Fortunately we had an internal Microsoft user who read my blog and offered his repro and cache which gave us the benefit of a local repro where we could get at both his cache and his server (Thanks Ken!).
The result of this is a better understanding of where we need to look to resolve this issue and also, with all your feedback, confirmation that even deleting the cache folder (which is now accepted as the best quick fix – as long as your project is REALLY saved and checked in on the server) does not mean the problem will not come back. The problem would appear to be some sort of corruption in the cache that can be re-introduced from a suspect project. Aik now has the smoking gun, and the issue is making its way into our hotfix process (See EPMConnect for other on-demand and Live webcasts).
Stay tuned!
Popularity: unranked [?]
Announcing the 2009 Microsoft Project Conference!
27 February 2009As I wake up to more snow in the Pacific North West what better news than a conference in Phoenix! A little time to wait though – September 14-17, 2009. Early Bird registration is open for the first 500 so get in quick. Hopefully I will get to meet some of you there (if I get invited). The site also has links to allow you to suggest content, refer a friend and tell us what is important to you. All this can be found at http://www.msprojectconference.com – and it is less than 200 days away (countdown on the site too
). Enjoy!
Popularity: unranked [?]
Support your customers better with voice notes
26 February 2009
Popularity: unranked [?]
Bad Economy, Good for EPM
26 February 2009If your organization is like most, management is running cautious right now, if not completely driven by economic fear. The market abhors uncertainty and the typical automatic management reaction to uncertain times often results in new project paralysis, including the fear of launching projects that could dramatically improve performance and productivity. Organizations that react this way are missing an excellent opportunity to make some of the changes that they may even have lamented not having done prior to the last stretch of prosperous business activity. This is shortsighted because an economic downturn is the best possible time to orchestrate business improvement efforts like Enterprise Project Management as well as other process improvement initiatives.
When an organization makes a serious commitment to implement new management practices, it often requires the addition of new talent. There is no better time to shop for new talent than a time when companies are indiscriminately cutting their workforces. In this case indiscriminate refers to the practice of slashing by the numbers rather than by carefully sifting through the talent pool and choosing to cut based on measures of worth. Organizations that cut jobs by the thousands cannot possibly take the time to be discriminate responding to pure economics rather than other business drivers. The result is that many companies release very talented people into the market where companies wise enough to seize the opportunity to grab them, can significantly improve the talent and experience profile of their staff. The end of the dot-com boom saw a similar widespread release of IT talent providing an opportunity for companies who had previously hired marginal talent, to reconstitute their technology staff with a better grade of employee. That same opportunity exists today, but on a much wider scale.
One of the most common excuses for not implementing EPM or other process improvement initiatives is lack of time. "We’re just too busy right now to take this on," is a common lament. If there is any one thing that a business slowdown brings, it is time. Of course, an organization faced with a business slowdown must invest some of this time into building strategies and tactics to survive the economic realities it is facing, but a wise organization spends some of this newly available energy and time on making the existing business approach better and more profitable. Now that the time is available, it makes sense to undertake process improvements that can yield cycle time reductions and improve performance. The best time to implement EPM is when you have the time to do it well.
Perhaps the greatest challenge to implementing management style changes is the organizational resistance that they invoke. Changing the way people work is never a popular sport, but people are much more likely to get the reasons for doing so during economic hard times than in times of prosperity. With the stock market losing almost half of its value and with daily job loss announcements and soaring unemployment numbers, even people who are not so worried about our jobs, are a little bit worried at this point. An economic downturn is the perfect stage set for introducing management changes that an organization would normally push back on. Selling a new management approach is not nearly as difficult when the government and media are constantly talking down the economic outlook. People instinctively get that process improvement is good when times are bad.
While we all must work through this time of economic uncertainty, some of us will emerge stronger and healthier through the experience. Those organizations that recognize the opportunities of time, talent and attitude that a recession brings can seize the moment and implement process improvements that will yield a significant ROI for many years and economic conditions to come.
Popularity: unranked [?]


