SSAS Articles 
Management Ideal Steps for Seamless Migration of SSAS 2000 to 2005 Database
Management Ideal Steps for Seamless Migration of SSAS 2000 to 2005 Database
| Ideal Steps for Seamless Migration of SSAS 2000 to 2005 Database |
| Written by Subhash Subramanyam |
| Tuesday, 31 July 2007 05:51 |
|
Steps to migrate Analysis Services 2000 database to SSAS 2005. "Migration wizard is plagued. it's really a big job. We have to always find the loose ends and tie them. Sometimes it's really better to go for redesigning entirely from scratch." -Lin, Li (OLAP Consultant, HP) It's really a patch work. Major part here include summary of Microsoft BI Webcast by Mike Young, Proclarity and Dave Wickert, Microsoft Corporation. After this, key lies in incorporating or adopting the OLAP Design best practices for SSAS 2005. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
