Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I) - Page 4
January 6, 2003
We now need to connect to the data source from which we wish to draw values.
The Data Link Properties dialog box appears, with its Provider, Connection, Advanced and All tabs, as shown in Illustration 4 below. Beginning with the Provider tab (where the dialog opens by default):
Note: For more on this, review the on-line documentation for OLE DB Providers, and data sources in general.
The focus moves to the Connection tab.
FoodMart 2000.mdb is located, by default (as we have noted) in the [Install Directory]:\Program Files\Microsoft Analysis Services\Samples directory; Click on the ellipses (...) button, to navigate to the .mdb as shown in Illustration 5 below.