First Look at Analysis Services 2005 - Professional SQL Server Analysis Services 2005 with MDX - page 50

an assembly has been added within a specific database it can only
be accessed within the context of that database. Within BIDS you
can only add dot Net assembly references. You learn more about as-
semblies in Chapter 10 .
▪ Miscellaneous. This object is used for adding any miscellaneous
objects (design or meeting notes, queries, temporary deleted ob-
jects, and so on) that are relevant to the database project. These ob-
jects are stored in the project and are not sent to the Analysis Ser-
vices instance when the database definition is created as a database
on the Analysis Services instance.
Properties Pane
If you click an object in the Solution Explorer, the properties for that object ap-
pear in the Properties pane. Items that cannot be edited are grayed out. If you
click a particular property, the description of that property appears in the De-
scription pane at the bottom of the Properties pane.
Output Pane
The Output pane (to be seen later in this chapter) is used to report warnings
and errors during builds. When a project is deployed to the server, progress
reporting and error messages are displayed in this pane.
Creating an Analysis Services Database Using the
Business Intelligence Development Studio
You are now ready to create a cube. The cube you create in this chapter is
based on the relational database Adventure Works DW that ships with Mi-
crosoft SQL Server 2005. If SQL Server 2005 is installed on your machine
with the sample databases, you will find the Adventure Works DW database
on your machine. If you don't have SQL Server sample databases installed
on your machine you can restore the database files (AdventureWork-
sDW.mdb, AdventureWorksDW.ldb). The Adventure Works DW files can be
downloaded from the companion web site for this topic.