![]() Run Setup.exe from the installation media. To come up with this inventory list, follow these steps: SQL Server 2008 installation follows the minimum-installation paradigm, so you’ll probably want to verify which components you’ve installed before exploring the tools for SSAS. ![]() #DOWNLOAD ADVENTUREWORKS 2012 CUBE INSTALL#You’ll probably want to install SQL Server Database Engine Services, however, because some of the tools that install with it are useful with SSAS cubes. ![]() Also, an SSAS installation does not require that you install SQL Server Database Engine Services. When you install SSAS, several tools are installed with the SSAS engine and data storage mechanisms. SQL Server 2008 does not install SSAS by default. We share this information so that you can choose the tools that best fit your style, background, and expectations. Before we list our inventory, we’ll talk a bit about the target audience-that is, who Microsoft thinks will use these tools. We mention these because we’ve found them to be useful for production work. #DOWNLOAD ADVENTUREWORKS 2012 CUBE FOR FREE#Later in this chapter, we’ll look at useful utilities and other tools you can get for free or at low cost that are not included with SQL Server 2008. That is, we’ll first list all the tools that are part of SQL Server 2008. We’ll begin this discussion of the tools you’ll use to design, create, populate, secure, and manage OLAP cubes by taking an inventory. Core Tools in SQL Server Analysis Services ![]() If you’re wondering when we’re going to get around to discussing BIDS, we’ll start that in Chapter 7. We aim to provide valuable information in this chapter for all SSAS developers-from those of you who are new to the tools to those who have some experience. After reading this chapter, you’ll be an expert in not only SQL Server Profiler but also SQL Server Management Studio (SSMS) and other tools that will make your work in SSAS very productive. In this chapter, we’ll explore the ins and outs of some tools you’ll use when working with Microsoft SQL Server Analysis Services (SSAS) objects. Before you start, though, we have one more chapter’s worth of information. By now, we’re sure you’re quite ready to roll up your sleeves and get to work in the Business Intelligence Development Studio (BIDS) interface. We covered quite a bit of ground in the preceding five chapters-everything from the key concepts of business intelligence to concepts, languages, processes, and modeling methodologies. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |