Tabular Reference
The References section is used to establish relationships between tables in your data model. This section defines the main table and lists all the associated tables it connects to.
Reference
Name | Description |
---|---|
References* | Names of the related tables |
MultiDirectionalFilter | Is this both way relation? Use with caution. (default=false) |
References
- Table:
Name: CallLog
SourceTable: F_CallLog
TableType: Fact
References:
- Table: Company
- Table: Date
- Table: Employee
- Table: Time
- Table: CallStatus
Columns:
- SourceColumn: StartTime
Type: varchar(50)
- SourceColumn: EindTime
Type: varchar(50)
- SourceColumn: Caller
Type: int
- SourceColumn: Phonenumber
Type: int
- References: The References section lists the tables that the current table is linked to within the model. Each entry should include the name of a related table, establishing relationships across the model.
MultiDirectionalFilter
- Table:
Name: CallLog
References:
- Table: Company
MultiDirectionalFilter: true
- Table: Date
- Table: Employee
- Table: Time
- Table: CallStatus
Columns:
- SourceColumn: StartTime
Type: varchar(50)
- SourceColumn: EindTime
Type: varchar(50)
- SourceColumn: Caller
Type: int
- SourceColumn: Phonenumber
Type: int
MultiDirectionalFilter: The MultiDirectionalFilter property specifies if the relationship between tables is bidirectional. When set to true, filters can flow in both directions. This property should be used cautiously as it can complicate the data model and affect performance.