Chapter 4: Building a Multidimensional Cube in SSAS 2019
In this chapter, we will create and deploy a multidimensional cube in SQL Server 2019. We will use the existing data in the WideWorldImportersDW database that we uploaded in Chapter 1, Analysis Services in SQL Server 2019. This data has already been organized using dimensional modeling techniques. As you work through this chapter, you will learn how to create the Analysis Services project and build out a functional cube. Once it has been built out, we will deploy it and review more advanced techniques that will automate cube processing.
In this chapter, we're going to cover the following main topics:
- Creating an Analysis Services project in Visual Studio
- Adding dimensions and hierarchies ...
Get Hands-On SQL Server 2019 Analysis Services 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.
