Databases Reference
In-Depth Information
Services 2005 to SQL Server 2005 to query data then all the queries will be
seeing consistent data seen by the first query. Any new data that arrived
between the results of first query and Nth query sent over a specific connec-
tion will not be included in the results of the Nth query. All these connection
properties will be stored and applied whenever a connection is established to
that specific data source. The data source wizard also allows you to create
data sources based on an existing data source connection already created so
that a single connection is shared by Analysis Services for multiple data-
bases. The wizard also allows you to establish connections to objects within
the current Analysis Services project such as establishing an OLE DB con-
nection to the cube being created in the project. Such a connection is typically
useful while creating mining models (to be seen in Chapter 13 ) from cubes.
Figure 4-4
 
 
Search WWH ::




Custom Search