...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
...
A many-to-many relationship occurs when multiple records in one table are associated with various records in another table. For example, a many-to-many relationship exists between customers and accounts when customers have multiple accounts, and accounts can be opened jointly by many customers.
...
- 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.
...
| Info | ||
|---|---|---|
| ||
To use any of the facts or dimensions from a many-to-many dataset, you must create a bridge dimension in the cube Physical view. |
Adding bridge dimension for many-to-many relationships
...