Skip to main content

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

NameDescription
References*Names of the related tables
MultiDirectionalFilterIs this both way relation? Use with caution. (default=false)
* Indicates that the field is mandatory and must be used.

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.