Show TOC

Specifying a Data Source for CubesLocate this document in the navigation structure

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

Procedure

  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 Start of the navigation path New Next navigation step Data Source End of the navigation path 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.

Results

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