Custom tables

Custom tables are created from other tables in the data module.

By adding custom tables, you create a more abstract, business-oriented view of data in your data module.

The user interface options for creating custom tables are based on the SQL operations, such as copy, view, union, intersect, and except. For more information, see Creating custom tables.

Custom tables function in the same way as other tables in the data module. You can use them to create relationships, calculations, filters, and other custom tables.

The Custom tables tab is used for creating, viewing, and managing custom tables in a data module. The tab is displayed even if the module doesn't contain any custom tables. To start creating a new table, click Create custom table.

If the data module already contains custom tables, the table names are listed when you open the tab. In the following example, the data module contains two custom tables: Product Sales and Product Returns.

This image needs alternate text.

The different types of custom tables are identified by different icons. The following table specifies the icons associated with custom tables:

Icon

Table type

view type of table View
join type of table Join
union type of table Union
view type of table Except
Intersect type of table Intersect

From the table context menu Context menu icon, you can access the standard table options for creating a relationship, calculation, filters, and so on. Clicking the View definition option or the table name opens the table query flow diagram where you can view the tables that the custom table is built from. For example, the following diagram of a custom table named Product Sales shows that the table is created as a view of three tables: Sales Targets, Customer, and Product.

diagram of a custom table

The diagram is synchronized with the data tree. You can perform the same actions from the table context menu in the diagram and in the data tree.