In the project that I am currently working we are using SQL Server 2005 and its components. We recently upgraded SSRS 2005 to 2008. Now we are in the process of upgrading SSAS from 2005 to 2008.
To process the cubes in 2005 version, we were using 2 methods. One is using XML and the other is SSIS packages. We upgraded one of our cubes to 2008 and we are unable to process the cube using XML but its processing fine when we are using SSIS package.
I Suspect it is something to do with the "Ignore Dimension Key Errors". There are some dimension keys that are missing. It was working fine in 2005 version and also in 2008 version with SSIS.
Please help me with this and let me know the reasons why this happens.
View Complete Post