Home > Business Intelligence > BI Migration from AS2008 to Analysis Services in SQL Server 2012

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:

  1. Stay with cubes in the multidimensional model
  2. Move existing cubes to the tabular model
  3. Keep existing cubes, but do all new development in the tabular model
  4. Do future development using both models
There are a variety of issues with these choices and questions about how to migrate existing cubes to the tabular model, if that’s what you want to do. I discuss it all in this whitepaper. Please let me know what you think. I’d like to know what the opinions are out there regarding these issues:

BI Strategies Migrating from Analysis Services 2008 to Analysis Services 2012

Categories: Business Intelligence
  1. Olaf
    March 19, 2015 at 3:08 pm

    Dear Tim,

    I wonder if you have progressed on the migration tool since 2011. It sounds like a good starting point for a migration I’ll have to do very soon.

    Cheers
    Olaf

    • March 19, 2015 at 6:27 pm

      Hi Olaf –

      Unfortunately we have not done anything more with the migration tool. We thought it would be a good opportunity when the tabular model first came out, and we built a tool that did a successful simple conversion. Our plan was to find jobs where we would do conversions, which would then give us the chance to improve the tool. But we never got any conversion jobs, so we haven’t done anything more with it.

      There are some fundamental problems with the idea of converting from Analysis Services multidimensional cubes to Analysis Services tabular models. The multidimensional cubes are more versatile and give you more options. Even if the tabular model is easier to use, if you already have cubes, why do you want to change to the tabular model? Some things will always not be able to be converted. And the structures of the two systems are so different, it maybe is easier to just start over when creating tabular models.

      So – I’m sorry that we don’t have a tool that’s ready to use. However, if you are doing a multidimensional to tabular conversion and you want help with it, I would be available to advise you on it. And there is a possibility that our tool could be helpful in doing the conversion. We are willing to get it out and start working with it again, if we believe it would be helpful for a project. Being the first time it was really used, it would have to be approached as an experiment. It might be a helpful approach. Or it might not.

      I wish I had better news for you. We really thought this would be a popular idea when we first worked on it. Send me an e-mail directly if you would like to follow up with me more on this – tpeterson@solidq.com

      Thanks for your inquiry!

      Tim

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: