This is a master-detail list. The left-side table shows one row for each dimension table you have defined. The right-side table shows one row for each column in the selected left-side table.
The list context menu shows actions you can take that affect the row table.
Master List Columns
|Table Name||The name of the table you assigned when creating this dimension table.|
|Business Name||The business-friendly name of the table that will be used in metadata generation, for display on reports, visualisations, etc.|
Detail List Columns
|Column Name||The name of the each column in the selected table.|
|Data Type||The Ajilius data type which will be used to store data for this column.|
|Role||Role that this column plays in defining database structure and processing. See Column Roles.|
|Change Table||Change the table name, description, documentation, etc. using the Table Edit form.|
|Delete Table||Delete the table definition using the Table Edit form.|
|Columns||Show the Column List for the selected table, to support column editing.|
|Scripts||Show the Table Scripts form for the selected table, to review and test generated ELT scripts.|
|Create Role||Create a role-playing dimension that will be implemented as a view over the base dimension. For example, an “Invoice Date” dimension may be created as a role over the “Date” dimension.|
|Create Rollup||Create a roll-up dimension that will summarise the dimension at a higher level. For example, a “Month” dimension may be created as a rollup from the “Date” dimension.|
|View Data||View a sample of data from the selected table, using the Table View form.|