Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

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 New 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 ...