When you need so you can ask studies regarding a couple dining tables, and also the study of them several dining tables would be somehow linked, you might do a romance between the two (if these dining tables commonly relevant through other tables).
Which will make a love between one or two tables, you desire an area that may connect these dining tables along with her. I phone call that it career a romance profession. You can simply drag one to occupation from one of your dining tables (doesn’t matter provider otherwise interest), and lose it on the same occupation on the other table.
The partnership which is written might not be based in good method showing exactly of stor_id so you’re able to stor_id. Yet not, when you click the matchmaking range, then you can see that industries that are area of the relationship was highlighted.
Areas may have Different Names
The 2 areas from the several tables can have a comparable term or different names. Whether they have the same identity (otherwise let’s say comparable term pattern), Energy BI is also automatically detect you to definitely relationships. Just remember that , i switched off which feature before on this page to help make the reading techniques smoother. Automatically, the car-locate relationship is found on and you may could have understood a situation eg this we got stor_id both in sphere and might have created the relationships.
In the event the career labels are different, then you’ve to produce the connection manually. Like what we have done into the more than. Rather, there is a different way to create the dating too.
You will see the fresh Create Relationships window which will show all established relationships as well as their “from” and you will “to” columns. You may make another you to definitely from the clicking on new. You can also note that there clearly was a good “autodetect” alternative adjacent to “New”, for those who desire to use.
We can’t comprehend the relationship that we are creating on the early in the day step here, while the We got rid of it yourself which will make it once more this way and show your this due to the fact next form of starting they.
Immediately after hitting The brand new matchmaking, next regarding the Would Matchmaking windows, you are able setting the main cause dining table, the fresh appeal table, and you’ve got so you’re able to including click the relationship profession so you’re able to highlight it in for each dining table. Instance exactly what depicted on the below picture:
If you choose the stores table as source or Conversion desk just like the provider makes little difference, although not, this new cardinality makes the procedure different. Fuel BI constantly is smart adequate to see the cardinality. But not, Cardinality is an enormous point regarding the relationship, which i tend to discuss they later on an additional blog post.
There are many most other setup about Carry out Relationship window and you may every one of men and women demands the full post discussion for themselves. In this article, our company is just centering on a guide to relationships. Shortly after simply clicking Ok on setting significantly more than, you really need to get to the exact same dating diagram even as we performed within the the last action:
In case you must revise a relationship, you may either glance at the Do Relationship section according to the Family loss, find matchmaking, and you may Edit they;
Investigation Products Is to Fits
Both fields you are hooking up together, have to have an equivalent study type, otherwise a document variety of which are coordinated to one another (such as for example, text so you can number), otherwise, when you produce the dating, you have made a blunder.
Hooking up Industry Would be to Can be acquired in both Tables
If you don’t have the web link job in one of the dining tables, up coming naturally you simply cannot do a romance between them. On more than analogy, the stor_id try our connect occupation features So you can is available inside both dining tables.