施工実績
Carrying out a relationship utilising the Carry out Dating Menu Alternative
2022.06.24When you wish so you can inquire analysis out of a couple dining tables, in addition to analysis of those a few dining tables is going to be somehow linked, you might perform a romance between them (if the those two dining tables aren’t associated through-other tables).
In order to make a love between a few tables, you want an area that may hook up those two dining tables together. I label which community a relationship community. You can just drag you to definitely field in one of one’s dining tables (does not matter provider or interest), and drop they on the same field on the other side desk.
The connection that’s composed might not be situated in a beneficial means demonstrating exactly from stor_id so you’re able to stor_id. Yet not, after you click the relationships line, you might observe that industries that will be the main relationship are showcased.
Fields may have Various other Labels
The 2 industries about a few tables might have an equivalent title otherwise some other names. If they have the same identity (or imagine if similar https://datingranking.net/fr/se-faire-des-amis/ term development), Electricity BI can also be instantly locate one to matchmaking. Understand that i turned off that feature prior to in this post to make the understanding techniques much easier. By default, the car-discover relationship is found on and you will could have identified a scenario such which that people got stor_id in both fields and you can will have developed the dating.
In the event the career labels are very different, then you’ve to help make the relationship yourself. Instance what we have done inside the significantly more than. Rather, there is another way to create the dating too.
You will see brand new Carry out Matchmaking windows which will show all the present relationships as well as their “from” and you can “to” articles. You possibly can make another you to from the clicking on the fresh new. You are able to notice that there was an effective “autodetect” choice right beside “New”, in the event you want to use.
We can not see the relationships that i have created about earlier action here, while the I eliminated they by hand to help make it once more by doing this and have you this as the next type starting they.
Just after clicking on The fresh dating, following throughout the Create Relationships screen, it will be possible setting the source dining table, the new appeal desk, and you have so you’re able to also click the relationships industry to focus on it into the for each and every dining table. For example just what illustrated from the less than visualize:
If you undertake the businesses desk as the provider otherwise Conversion desk given that source makes no difference, however, the cardinality will make the process additional. Fuel BI constantly is sensible sufficient to understand the cardinality. not, Cardinality is actually a massive matter regarding relationship, that i often speak about they later on in another article.
There are many almost every other settings on the Would Relationship window and you can each of those needs a complete blog post talk on their own. In this post, the audience is just focusing on a guide to relationships. Once simply clicking Okay to the setup over, you ought to reach the same relationship diagram once we did when you look at the the prior step:
Revise Matchmaking
In case you have to revise a romance, you may either look at the Carry out Relationships part beneath the Family loss, realize that relationship, and you can Revise they;
Studies Versions Is to Suits
The two sphere that you are hooking up together, have to have an equivalent study method of, otherwise a data method of which are matched together (instance, text to number), or even, once you produce the relationship, you get a blunder.
Linking Field Would be to Is obtainable in Tables
Without having the web link occupation within the dining tables, after that however you simply cannot perform a relationship between them. Regarding significantly more than analogy, this new stor_id try the connect community possesses To help you is available into the both tables.