BI Migration from AS2008 to Analysis Services in SQL Server 2012
Microsoft Business Intelligence is entering into a very significant period of change with the coming release of SQL Server 2012. The addition of the tabular model, the new Power View tool in Reporting Services, the integration of individual BI and corporate BI, the columnstore indexes in the relational model – there are a whole new set of tools available for bringing key information to business users.
But what about those who are already using cubes in Analysis Services? What happens to all the time and effort that has been invested creating cubes in AS2008? There are some choices to be made. I have written a whitepaper outlining the four main choices, as I see them:
- Stay with cubes in the multidimensional model
- Move existing cubes to the tabular model
- Keep existing cubes, but do all new development in the tabular model
- Do future development using both models