Working with Data Sources and Data Source Views - Professional SQL Server Analysis Services 2005 with MDX - page 136

Figure 4-3
In Chapter 2 you used the data source wizard to create a data source which
included impersonation information. In addition to providing impersonation in-
formation you can optionally specify additional connection properties such as
query time out for connection, isolation level, and maximum number of con-
nections as shown in Figure 4-4 . The isolation level property has two modes:
Read Committed and Snapshot. By default the Read Committed is used for
all the data sources. The Snapshot isolation mode which is supported by the
relational data source SQL Server 2005 and Oracle are used to ensure that
the data read by Analysis Services 2005 is consistent across multiple queries
sent over a single connection. What this means is that if the data on the rela-
tional data source keeps changing and if multiple queries are sent by Analysis