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

 

Get SQL Server MVP Deep Dives, Volume 2 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.

Start your free trial