When you need to query investigation of two tables, while the analysis of those a few dining tables will be somehow linked, then you may create a romance between the two (if the these two tables commonly relevant through other dining tables).
To make a relationship between several tables, you need a field that may connect both of these tables with her. We phone call which field a relationship career. You can just drag you to definitely industry from of tables (does not matter origin or attraction), and you can shed it on the same job on the other table.
The partnership which is authored may not be located in an effective way exhibiting just from stor_id to stor_id. Yet not, after you click the relationship line, you might notice that fields that are area of the relationships are emphasized.
Industries have Additional Names
The 2 sphere about several tables might have an equivalent term otherwise different brands. Whether they have the same term (or what if similar name trend), Stamina BI can automatically locate one to relationships. Understand that we turned off that feature before in this post to really make the discovering process easier. Automatically, the vehicle-find dating is found on and you will would have identified a scenario such which we had stor_id both in areas and you can will have developed the relationships.
In the event the industry names are very different, then you have in order to make the partnership manually. Such everything we did from inside the significantly more than. Rather, there is certainly a different way to produce the dating as well.
You will observe the newest Carry out Matchmaking windows which will show every established relationships as well as their “from” and you may “to” columns. You possibly can make another you to by hitting the new. You may want to see that discover a good “autodetect” solution adjacent to “New”, just in case you want to make use of.
We can’t comprehend the relationship that we are creating about earlier action here, since the We got rid of they by hand to create they again by doing this and have you this as next variety of starting they.
Shortly after simply clicking The fresh relationship, then on Carry out Matchmaking windows, it is possible to create the source dining table, the latest attraction desk, along with in order to along with click on the relationships industry so you’re able to focus on it from inside the for each and every dining table. Such as for example just what illustrated regarding below picture:
Should you choose the stores desk as the provider otherwise Conversion desk because source makes no difference, but not, the new cardinality can make the process some other. Stamina BI always is smart sufficient to understand the cardinality. Although not, Cardinality is actually an enormous topic regarding relationship, which i tend to talk about it after in another blog post.
There are numerous almost every other settings throughout the Carry out Relationship screen and every one of men and women needs an entire blog post discussion for themselves. On this page, the audience is only focusing on a guide to matchmaking. Immediately following clicking on Ok toward setup a lot more than, you really need to get to the same matchmaking drawing as we did for the the prior step:
Revise Relationship
Should you need certainly to modify a romance, you can either glance at the Perform Relationships point within the House tab, discover that relationships, and you may Revise they;
Analysis Models Is to Match
The 2 sphere that you’re linking to each other, must have a comparable studies particular, or a document method of which might be matched to one another (instance, text to amount), otherwise, once you produce the relationship, you get a mistake.
Hooking up Job Is always to Can be found in both Dining tables
If you don’t have the web link profession in one of the dining tables, after that of course you simply cannot manage a love between the two. On the above analogy, the newest stor_id was all of our link occupation and has now To can be found for the one datingranking.net/fr/rencontres-au-choix-des-femmes another tables.