HowTo: Completing a join with filters

Unofficial Content

When we are defining our Queries we could end up having incomplete joins which lead us to make the wrong usage of the information. To correct this undesired behavior we should create filters on the Query in order to "instantiate" the missing attributes on the join.

Example

Lets supose we have the following Transactions:

Company{

CompanyID*
CompanyName
CompanyAddress
...
IndustryID
CountryID

}

Industry{

IndustryID*
IndustryLanguage*
IndustryName

}

Country{

CountryID*
CountryName

}

And we want the number of companies by country, but only for industries which are in English. To define this query we will need the following information:

  • Count(CompanyName) as Data Axis
  • CountryName as Row Axis

And the following filter:

  • IndustryLanguage = 'Eng'

Note that this filter is the one completing the join.

See also