O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 53. Autogenerating SSAS cubes

Johan Åhlén

This chapter describes how to autogenerate cubes in SQL Server Analysis Services (SSAS) and the underlying relational database. It comes with a step-by-step example of how to build a tool, InstantCube, that could drastically reduce the development time of simple SSAS cubes. With a few lines of code, you can significantly reduce the effort of analyzing your data manually. InstantCube isn’t intended to be a full-featured tool but serves as an example of how to programmatically build cubes.

This chapter is divided into the following sections:

  • Background—usage scenarios and technology overview
  • Step-by-step example of how to implement a simple cube generator in C#
  • Results and conclusions

 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required