Add Tables

In the Data Source Editor, tables represent the sources of fields that become cube dimensions and measures. The first table added is designated as the Fact Table — this is the central table that contains the cube’s measures and primary keys used to join other tables. The Fact Table determines the aggregation context for measures in your cube. You can change the Fact Table at any time, and all existing joins will be adjusted automatically.

Tables can be base tables or views, and you can join them to enrich cube data with related fields.

Add a table

1. In the Options panel on the right, click the General icon.
2. Click + Add Table.
   Or right-click on the Workspace and select + Add Table.
3. In the Available Tables dialog, double-click a table to add it. Use the search bar to quickly locate tables.
4. (Optional) Select additional tables as needed.
5. Close the dialog when you finish adding tables. The selected tables will appear in the Workspace.
6. In the Options panel, select Save Data Source.

Table column

Column	Description
Field	Name of the field in the table.
Description	Text label describing the field.
Type	Data type of the field (for example, String, Decimal, Int).
Dimensions	Indicator showing whether the field is used as a dimension in the cube.
Measures	Indicator showing whether the field is used as a measure in the cube.

Link tables

Joining tables allows you to combine related data across sources. Each join connects one table’s field to a matching field in another table. If a table is already the target of a join from another table, it cannot be joined again from a third source — joins in the Workspace are strictly one-to-one between two tables.

Join two tables

1. In the Workspace, select the two tables you want to join.
2. Expand each table by clicking the window icon in its top-right corner.
3. Click and hold a field in the first table.
4. Drag the field onto the matching field in the second table.

note

You cannot create joins directly on the Fact Table.

Change the join type

1. In the Workspace, click the arrow representing the join between two tables.
2. In the Options panel on the right, click the Table Join icon.
3. Select a join option between Left Join andInner Join.
4. In the Options panel, select Save Data Source.

Delete a join

1. In the Workspace, click the arrow representing the join between two tables.
2. In the Options panel on the right, click the Table Join icon.
3. Select Remove Join.

Manage tables

1. In the Workspace, select the table you want to manage.
2. In the Options panel on the right, click the Table icon.
3. Select an option.
4. In the Options panel, select Save Data Source.

Table options

	Option	Description
	Set Fact Table	Sets the selected table as the Fact Table and redirects all existing joins appropriately.
	Preview Data	Shows the first 1,000 rows of the table.
	Show Columns Only	Displays only the columns that have been selected as dimensions or measures.
	Show All Fields	Displays all available columns in the table.
	Join Specific Value	Adds a specific selection condition to the join’s ON clause when the table has a join. Allows selecting available global variables from the drop-down list.
	Remove Table	Deletes the selected table from the data source workspace.