Tables and Relationships
Pyramid automatically assigns relationships between the tables. Table metadata can be edited, and tables duplicated or hidden.
- Click here to learn more about tables.
By default, 'auto-relationships' are used to create joins via a heuristic model that matches primary key columns to foreign key columns. This model can be changed to match tables by table name or column name, or auto-relationships can be disabled.
Regardless of whether or not auto-relationships are enabled, and which heuristic model is selected, you can add new joins, and delete or edit existing ones.
- Click here to learn more about joins.
Pyramid uses heuristics to determine things like column visibility, data type, measure formatting, and to organize columns into logical folder groupings. All of these things can be edited if required.
Columns can be edited from both the Tables panel and the Columns panel. Where you choose to edit columns depends largely on personal preference, but there are 2 main differences between the 2 panels:
- The Tables panel shows joins between the tables, while the Columns panel does not.
- The Tables panel presents a graphical representation of the tables and columns, while the Columns panel presents a tabular display.
- Click here to learn more about columns.
Automatic Column Handling
Users can schedule Tables to be refreshed with new columns as a new semantic model is created. Users can select individual Tables and select Sync table columns. When the model scheduled to run, the columns will be added or removed according to the new table view,
Additionally, when the Job runs, users can determine how to refresh the columns. Users can select the synchronization and the column settings handling.
- Click here to learn more about automatic column handling
- Click here to learn more about sync column settings
Using heuristics, Pyramid determines which columns in the model are measures, and assigns them a format and folder. You can manually define columns as measures, and you can edit measures by changing the measure type, the folder, and format.
- Click here to learn more about measures.