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
To
...
Adding bridge dimension for many-to-many relationships
...
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 add create a bridge dimension from Bridge node for many-to-many relationships while viewing a semantic model, perform the following steps.
From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Click the Refine tab, to confirm you are looking at the Physical View.
On the Dimensions column, click the + icon.
In the Dimension Properties, specify the Name for the dimension.
Select the Bridge option from the Type drop-down list.
Select the Bridge Node from the drop-down list.
Click Save. Drag a Bridge node candidate dimension from the list on the left into the dimension column.
Click Save.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note If processing a many-to-many semantic model, you must drag the bridge candidate dimension into the logical view. |
...
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.
...