Data Source Editor

The Data Source Editor links the cube elements to the data source.

1. In the Cubes list, select a cube.
2. In the Navigation Bar, click the Navigation drop-down list and select Data Sources.
   Note

   Data Sources are not accessible to Cubes when the In Production option is selected.

3. In the Data Sources list, select the Data Source you want to edit.
4. In the Navigation Bar, click Data Source and select Edit Data Source.

5. The Data Source Editor screen contains a visual SQL Designer on the main panel, the list of Table Fields for Measures and Dimensions in the cube, and a WHERE clause at the bottom that can be edited by clicking to open the Advanced Filters option.

   

   List of Dimensions and Measures:

   • Type: Measure or Dimension.

   • Name: Name of the table column.

   • Description: Description of the column.

   • Data Type: Type of field data.

6. Proceed to:

   • Adding a table

   • Selecting dimensions and measures

   • Editing fields

   • Adding tracking

   • Adding a stored procedure

   • Adding scripts