Carrying out a romance with the Create Matchmaking Selection Alternative

Carrying out a romance with the Create Matchmaking Selection Alternative

When you need to help you ask research from several dining tables, in addition to study of them a couple of tables shall be in some way linked, then you can manage a love among them (when the these two dining tables commonly associated through other tables).

To make a love ranging from a couple of tables, you would like an area which can hook up those two tables together with her. I call that it industry a love community. You can simply drag one community in one of dining tables (does not matter supply or appeal), and drop they for a passing fancy community on the other side desk.

The partnership which is written may not be based in good means showing exactly from stor_id to stor_id. Although not, when you click the dating range, then you can see that sphere that will be part of the dating was highlighted.

Fields may have Additional Labels

The two areas regarding the a couple tables may have an equivalent identity or different labels. If they have a comparable identity (otherwise imagine if similar title trend), Energy BI can be automatically detect one relationships. Remember that i deterred that feature prior to in this post to really make the understanding techniques smoother. Automatically, the auto-place dating is found on and you will could have observed a situation such as it that we had stor_id both in sphere and would have created the dating.

If the job brands vary, then you’ve to create the relationship by hand. Instance that which we have inked inside the a lot more than. Instead, there is certainly another way to produce the relationship as well.

You will notice this new Do Relationships window which ultimately shows the established matchmaking and their “from” and you may “to” columns. You may make a new you to definitely from the hitting brand new. You can also notice that there clearly was good “autodetect” alternative right beside “New”, in the event you want to use.

We can not comprehend the dating which i have created regarding prior step here, since I eliminated it by hand to make it again by doing this and show you so it as the second style of creating it.

Shortly after hitting New relationships, then in the Perform Dating windows, it will be possible to put the main cause dining table, the brand new interest desk, along with so you’re able to together with click the relationships profession in order to focus on it during the each table. Such as for instance just what represented regarding less than image:

If you choose the businesses desk due to the fact source otherwise Transformation desk because the origin makes no difference, yet not, the cardinality makes the procedure more. Energy BI always makes sense adequate to see the cardinality. However, Cardinality is actually a huge thing throughout the dating, that we often talk about they later in another article.

There are numerous almost every other setup from the Carry out Relationships windows and you can each of those requires the full article conversation on their own. In this article, our company is merely centering on the basics of matchmaking. After clicking on Okay to your setup a lot more than, you need to reach the same matchmaking diagram once we did inside the last action:

Change Relationship

Should you need certainly to modify a relationship, you may either go through the Manage Dating section under the Home tab, discover that relationships, and you may Revise it;

Studies Versions Is to Suits

The two sphere that you are linking to one another, should have the same study particular, or a document type of which can be paired together (particularly, text message to help you matter), otherwise, after you produce the relationship, you get a blunder.

Hooking up Industry Should Can be acquired in both Dining tables

If you don’t have the hyperlink job in one of the dining tables, following without a doubt you can’t do a romance between the two. In the above analogy, the brand new stor_id is our hook community features To exists inside one another dining tables.

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan.