If you want to ask study out of a couple tables, and research of them several tables shall be in some way linked, then you may would a relationship among them (when the those two dining tables commonly associated through-other dining tables).
To create a love between several dining tables, need a field that hook those two dining tables together. I call so it occupation a romance field. You can just pull that career in one of your own tables (does not matter provider or destination), and you will miss it on a single career on the other side desk.
The partnership that’s created may not be based in a way appearing precisely out of stor_id in order to stor_id. Although not, after you click the relationship line, you might notice that areas which can be part of the matchmaking is actually showcased.
Industries have Other Brands
Both fields from the one or two tables have the same name or more labels. If they have the same title (or let’s say comparable label trend), Stamina BI is also automatically select one matchmaking. Remember that i turned off which feature prior to in this post to help make the understanding procedure convenient. Automatically, the auto-locate dating is on and would have thought a situation such that it that we had stor_id in industries and you may might have developed the relationship.
When the community names are very different, then you’ve got to manufacture the connection manually. Including everything we have inked inside the more than. As an alternative, there is a different way to produce the matchmaking also.
You will notice brand new Would Relationship windows which shows most of the established relationship in addition to their “from” and “to” columns. You can create yet another you to of the simply clicking the newest. You can even observe that there’s a beneficial “autodetect” alternative right beside “New”, in the event you want to use.
We can not understand the dating which i have created from the past action here, because We got rid of it by hand to manufacture it again by doing this and have you this since the next kind of carrying out it.
Just after simply clicking The newest dating, then in the Would Relationships windows, it’s possible to put the cause table, the latest interest dining table, and you’ve got in order to in addition to click on the matchmaking community to emphasize they for the for every table. For example exactly what depicted in the below photo:
If you choose the businesses dining table since the rencontre avec un homme hindou provider or Conversion dining table since the supply makes no difference, not, this new cardinality make the method other. Fuel BI always is smart sufficient to see the cardinality. But not, Cardinality is a huge issue about matchmaking, that we usually talk about they afterwards in another article.
There are many other settings on the Carry out Dating windows and you can each of those people need an entire blog post discussion for themselves. In this post, our company is only centering on a guide to dating. Immediately following hitting Okay towards the arrangement a lot more than, you need to reach the same matchmaking drawing even as we did inside the the previous step:
Revise Relationships
In the event you want to modify a romance, you can either glance at the Manage Dating area beneath the Home loss, find matchmaking, and you can Modify they;
Data Products Is to Meets
Both areas your linking to each other, need an identical studies type of, or a data particular that may be matched together (such as for instance, text to number), or even, once you create the matchmaking, you get a blunder.
Connecting Field Will be Is present both in Tables
Without having the hyperlink industry in one of the tables, up coming obviously you cannot would a love among them. In the over analogy, this new stor_id is actually our very own link career and has In order to is available into the each other tables.
Commentaires récents