It provides you with strategies for handling that-to-you to definitely model relationships

It provides you with strategies for handling that-to-you to definitely model relationships

This informative article aim you since the a document modeler working with Energy BI Desktop. A-one-to-one dating is going to be authored whenever both dining tables each incorporate a line out of prominent and you can book viewpoints.

An introduction to model relationship is not covered on this page. If you aren’t completely accustomed matchmaking, the attributes or tips arrange them, it is recommended that you initially browse the Design relationship for the Electricity BI Pc blog post.

Additionally it is essential that you have an understanding of superstar schema framework. To learn more, select Discover celebrity outline therefore the strengths getting Power BI.

Line study covers around the dining tables: One team organization otherwise subject try piled just like the a few (or even more) model dining tables, possibly since their info is acquired regarding some other data areas. It scenario are preferred to have aspect-type of dining tables. Such as, grasp product details is actually stored in a working conversion process program, and you can second device details was kept in yet another resource.

It’s unusual, however, that you’d relate one or two facts-sorts of dining tables with a-one-to-you to dating. It is because one another fact-sorts of dining tables will have to have a similar dimensionality and you can granularity. Along with, for each and every truth-particular table will want unique articles to let the fresh new design relationships to-be authored.

Degenerate size

When columns off an undeniable fact-method of desk can be used for selection or group, you can look at which makes them available in a separate desk. That way, your independent articles utilized for filter otherwise group, from those people columns regularly overview truth rows. Which separation is:

  • Reduce storage space
  • Simplify model calculations
  • Sign up for increased query abilities
  • Submit a more easy to use Areas pane experience on statement article authors

Regarding the after the model diagram, see that your order amount and buy range amount articles haven’t become stacked on the Conversion dining table. Rather, the viewpoints were used to produce an effective surrogate trick column named SalesOrderLineID. (The primary value try determined because of the multiplying the transaction number by one thousand, and then adding your order range amount.)

Product sales Buy dining table provides a rich experience for report writers with around three columns: Conversion Order, Transformation Order Line, and you will Line Matter. Moreover it has a ladder. This type of desk tips service report habits that need so you can filter out, group of the, or exercise down due to instructions and you may buy traces.

While the Sales Purchase table comes from the sales study, there should be equivalent quantity of rows inside for each desk. Next, there should be complimentary values between per SalesOrderLineID column.

Row data spans across the tables

Believe a good example connected with a few you to definitely-to-one to associated dimension-sorts of tables: Device, and Equipment Category. For each and every desk is short for imported investigation features an effective SKU (Stock-Remaining Device) column with which has unique values.

The original table is named Equipment, also it consists of about three columns: Color, Tool, and you can SKU. The following table is named Device Group, therefore contains several articles: Class, and you can SKU. A-one-to-one relationships relates both SKU columns. The partnership strain in directions, that is always the situation for example-to-you to matchmaking.

To simply help determine the way the relationships filter propagation works, the brand new model diagram could have been modified to reveal the newest desk rows. Most of the examples in this article are based on these records.

It’s not possible to monitor table rows regarding the Stamina BI Pc model drawing. It is done in this particular article to support the fresh talk having obvious advice.

  • The item desk enjoys three rows:
  • SKU CL-01, Tool T-clothing, Colour Environmentally friendly
  • SKU CL-02, Tool Pants, Colour Blue
  • SKU Air-conditioning-01, Equipment Hat, Colour Blue
  • SKU CL-01, Category Gowns
  • SKU Air cooling-01, Group Precious jewelry

Notice that the product Class dining table cannot are a row to possess this product SKU CL-02. We’ll talk about the consequences associated with forgotten row after within post.

Lämna ett svar

Din e-postadress kommer inte publiceras. Obligatoriska fält är märkta *