Data section of relational tables

When you select a relational table in the tree, its contents are displayed in the data section. Relational tables are part of the Designer database and are used to create dimensions in the multidimensional OLAP database. The number of columns and the column types differ according to the purpose of the table. Columns that occur in many tables are ID, Description and Data Source ID, and English and German for English and German element names.

When you specify text in the Filter text box, you restrict the view to elements that contain the string in one of their column titles. Click Executes the Filter. Details regarding the contents of the selected table are shown on the Help tab of the data section.