Whenever you can, you are able to TREATAS to make usage of the latest digital relationship to possess show grounds
Update 2018-08-15: An additional strategy to propagate a virtual relationships is available having TREATAS, discussed from the post Propagate strain using TREATAS inside the DAX.
Including, you could have a relationship anywhere between Conversion and you can Product by using the ProductKey column, such as next schema.
In order to create a love Dating für Uniform Erwachsene during the a document design when you look at the Stamina Rotate, Electricity BI, otherwise Studies Properties Tabular, at least one side of the relationship must be tied to a column that’s unique regarding the dining table. In this instance, we hook up the ProductKey column of one’s Device table (and that is an important trick) on the ProductKey line of the Transformation table. This is basically the classical that-to-many matchmaking or a relational design.
With this specific matchmaking, people filter out over columns of the Unit desk is reflected inside the a filtration of the Sales desk. Simply put, the partnership transmits the list of viewpoints filtered about ProductKey column of Product table, to a beneficial correspondent filter out placed on the ProductKey line of your Sales dining table. This is done in a really efficient way in the storage engine height, and you may make best results.
Deja un comentario