O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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