Page 92 - DCAP606_BUSINESS_INTELLIGENCE

Unit 6: Business Intelligence Project

Notes
Teradata Teradata V2R6, V12 (not TDOLEDB OLE DB provider
relational applicable) .Net Data Provider for Teradata
databases
Informix V11.10 (not Informix OLE DB provider
relational applicable)
databases
IBM DB2 8.1 (not DB2OLEDB
relational applicable)
databases
Sybase V15.0.2 (not Sybase OLE DB provider
relational applicable)
databases
Other (not applicable) (not OLE DB provider or ODBC driver
relational applicable)
databases

Source: http://msdn.microsoft.com/en-us/library/ms175608.aspx
Self Assessment

State whether the following statements are true or false:
1. Multidimensional model must contain at least one data source object.
2. A data source connection can occasionally use Windows authentication or an authentication
service provided by the database administration scheme.
3. When retrieving data, the client library making the connection formulates a connection
request that includes the credentials in the connection string.
4. In completing the Wizard, the new data source appears in the Data Sources folder.
5. In Data Source View Designer, using the data source view just created right-click anywhere
in the work area and select Add/Remove Tables.

6.2 Creating a Data Source View

After you have defined the data sources that you will use in an Analysis Services project, the next
step is generally to define a data source view for the project. To define a new data source view
1. In Solution Explorer, right-click Data Source Views, and then click New Data Source View.

2. On the Data Source View Wizard page, click Next. Then a page appears to select a Data
Source.

3. Under Relational data sources, one of the data source will be selected. Click Next.
4. On the Select Tables and Views page, you have to select tables and views from the list of
objects that are available from the selected data source. Click > to add the selected tables
to the Included objects list. Finally, Click Next and Finish.

LOVELY PROFESSIONAL UNIVERSITY 87