Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Important While designing a many-to-many relationship, you must create a unidirectional relation from Fact > Bridge > Dimension or Dimension > Bridge > Fact. |
...
From the Toolbox, select Relationships.
Click the Action menu ( ⋮ ) at the top of the Relationships column and click Add Relationship.
Or type a name of a file or folder to search for in the Search box.In the File column, drag more than one file onto the relationships workspace.
In the file, click the field that you want to map.
Drag a field to map it to a field in a different node to create a relationship.
Click the Line to view the relationship details.
Specify the bridge node using the Node Type field in the Properties pane. Define the relationship between bridge and fact and bridge and dimension, as shown in the following figure.
...
| panelIconId | atlassian-note |
|---|---|
| panelIcon | :note: |
| bgColor | #DEEBFF |
Note
...
Adding bridge dimension for many-to-many relationships
To add a bridge
...
node for many-to-many relationships,
...
do the following
...
:
...
Add a third node where each record contains the primary keys of the two tables you will join.
Drag a field from each of the first two nodes to map them to a field in the third node to create the relationships.
Select that third node, then view its properties in the Properties panel.
Under Node Type, select Bridge.
Define the relationship between ‘bridge and fact’ and ‘bridge and dimension.’
Creating bridge dimension from Bridge node for many-to-many
...
semantic
...
models
| Anchor | ||||
|---|---|---|---|---|
|
To create a bridge dimension from Bridge node for many-to-many relationships while viewing a semantic model, perform the following steps.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note If processing a many-to-many semantic model, you must drag the bridge candidate dimension into the logical view, linking it from the Source fields to the Candidate dimension. |
...
Properties
Selecting a node shows its properties in the Properties panel. You can specify the node to be Fact, Dimension,or Bridge using the corresponding option from the Node Type area.
...