Data Source Editor
The Data Source Editor is where you link cube elements — dimensions, measures, and other metadata — to the tables and fields in a data source. It provides tools to visually design the query structure, define which fields become cube dimensions or measures, and apply filters to control the data loaded into the cube.
The editor screen consists of three main areas:
| Section | Description |
|---|---|
| Visual Query Workspace | Graphical area displaying the tables and their relationships. Used to add tables, join tables, and manage their connections. |
| Dimension and Measure Fields List | List of fields from the data source that are flagged as dimensions or measures for inclusion in the cube. |
| WHERE Clause Editor | SQL editor section at the bottom of the screen for defining filters that limit cube data based on specified conditions. |
Access the editor
- In the Administration page, select OLAP Manager from the sidebar.
- In the cube list, select the cube you want to work with.
- In the Options panel on the right, click the Navigation icon.
- Select Data Sources.
- From the data source list, select the source you want to edit. The Data Source Selection panel opens.
- Click Save and Edit to open the Data Source Editor.
Related tasks
| Task | Description |
|---|---|
| Add tables | Add tables to the Visual Query Workspace and manage their joins. |
| Select dimensions and measures | Flag fields as dimensions or measures for inclusion in the cube. |
| Edit fields | Modify existing fields or create calculated fields. |
| Add tracking | (Optional) Configure tracking to process only changed data during cube refreshes. |
| Configure a stored procedure | (Optional) Run a predefined SQL procedure before each cube job. |
| Manage scripts | View and execute global scripts related to cube preparation and maintenance. |
| Build a WHERE Clause | Define SQL conditions to filter data before loading it into the cube. |