The author is a Business Intelligence / Performance Management Consultant from the USA, that has been in the IT industry for nearly 14 years. He has designed and implemented Cognos BI solutions for major corporations such British Petroleum and General Motors. Over the course of the past four years, the author has utilized the Microsoft BI Tool Suite for Energizer Holdings, Inc. During that period, he focused on the implementation of Microsoft PerformancePoint Server 2007. As of early September 2007, he was one of only a handful of people in the world to implement PPS Planning in a production environment for a Fortune 1,000 company. Since April 2009, he has been leading an effort to transition and integrate the IT systems of an acquired company into the parent corporation in the pharmaceutical industry.
December 19, 2008 at 5:05 pm
Hi i saw a post that you wrote on Staging data into PerformancePoint Planning :
“I recommend that you that when you synchronize your staging database, you should execute a script to add indexes back to your staging tables. The sync process drops all staging indexes. You’ll find performance will increase considerably with proper indexes, i.e. BizSystemFlag, MemberId, Label. Without these indexes, I have experienced timeouts when trying to load staging to the app database. — David Street bieasystreet.wordpress.com”
http://performancepointing.blogspot.com/2007/10/staging-data-into-performancepoint.html?showComment=1193710020000#c6273519622943171434
My question is how do i know if the sync drops my staging indexes? After the sync i still see the index object in staging database.
Thanks,
Dinh