Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
Once you have datasets, you can create relationships among the different datasets.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note To use any of the facts or dimensions from a many-to-many dataset, you must create a bridge dimension in the semantic model Physical view. |
Properties
In the Properties pane, you can do the following:
...
In the Relationships pane, you can view or change the relation type. For example, you can change from one-to-many to many-to-many by clicking the blue icon next to the Actions menu ( ⋮ ), then clicking Yes to confirm the change.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note: From Kyvos 2025.2 onwards, enhancements in adding relationships now allow you to easily create joins using both the 'is equal to' and 'is between' operators. Additionally, you can edit existing joins and view their details by hovering over them. |
To add a relation, perform the following steps:
Click the Actions menu ( ⋮ ) > Add relation and specify a source and target for an outgoing relationship, and then click Apply.
To change the incoming or outgoing relationship to one-to-many, click the blue icon next to the Actions menu ( ⋮ ), and then click Change.
To change the operator between a source and a target, click the operator (the blue equal sign in the screenshot shown here) and choose
equal toorbetween. If you choosebetweenyou must select a target.To delete a relationship, click the Actions menu ( ⋮ ), and then click Delete to confirm the deletion.
...
Relationships pane
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note You cannot rename the datasets or fields used in the Relationships Designer. |
...
Click either the Collapse or Expand All Tables in a Relationship icon at the top of the workspace next to Tips to expand or collapse all nodes.
Tabular view
For complex relationships, you can also view and edit the nodes in a table format. The table format is best used when you have a larger number of nodes, for example, 25. It helps you avoid additional scrolling and moving relationship lines. You can see all of the information more easily in table format. The table view allows you to more easily search, sort, and filter relationships.
Once you have made changes using the tabular view, you can't switch back to the graphical view.
To switch to the tabular view, click the Actions menu (...) and click Switch to Tabular View.
Raw data
You can create relationships using data that hasn't been processed into a semantic model. Select the file you want to use and create relationships using it. See Working with non-materialized or raw data semantic models
...