Specifying a Data Source for Cubes

Before generating cubes, you must define a data source with an OLE DB connection that will specify from where the cubes will be populated.

  1. Create a data source in your PDM from the List of data sources or by right-clicking the model in the browser and selecting New > Data Source from the contextual menu.
  2. Select the OLE DB tab and specify the kind of data provider.


  3. Click the ellipsis tool to the right of the connection string field to open the provider-specific configuration dialog.


  4. Complete the parameters appropriately, click Apply to Connection String, and then Test Connection. Then click Ok to return to the data source property sheet.
  5. Click OK to return to your model.

When you have created the appropriate data sources, you can proceed with generating your cubes.

Parent topic: Analysis Services (SQL Server 2005)