Using BIDS to Build a Cube

In this section, you will use the Business Intelligence Development Studio (BIDS) to create SSAS cubes. This environment is also used to create SSAS data mining structures and models (which are covered in Chapter 14) and SQL Server Reporting Services reports and report models (covered in Chapter 10). To start your work, open BIDS, and select File Image New Image Project. Select the Analysis Services Project template under the “Visual Studio installed templates” heading, as shown in Figure 3–1.

Figure 3–1. The New Project dialog ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.