Setting up a new Analysis Services project

The first step towards creating a new cube is to create a new Analysis Services project in SSDT. Immediately after doing this, we strongly recommend putting your new project into source control. It's easy to forget to do this, or not bother, because building a cube doesn't seem like a traditional development project, but you'll be glad that you did it when you receive your first request to rollback a change to a complex MDX calculation.

As you're probably aware, there are two ways of working with Analysis Services projects in SSDT:

  • Project mode: This is where you work with a local Visual Studio project and deploy to your Analysis Services server only when you're happy with all the changes you've made
  • Online ...

Get Expert Cube Development with SSAS Multidimensional Models now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.