If a query includes tables with rows without assignment to rows in other tables of the query, these rows are not included in the record queried, i.e., its values will not be included in the query result.
Example
If the criteria Administrators and Application were queried in this example, the values Cognos and Berlin would not be included in the result. This is due to the fact that the value Cognos in the table Application and the value Berlin in the table City do not have any assignments to other rows of the tables queried. (See illustration below.)
However, if the table of the query contains a value without assignment, and the table in which the assigned value is missing is not part of the query, the values of the table queried will be included in the result.
Example
If only the application criterion is iterated and the licence criterion is aggregated in the query, the iteration step Cognos and the license costs 30 would be included in the query result because the other linked tables would not be part of the query. As soon as another table is added to the query, for example because of a filter, iteration, or aggregation, the values Cognos and 30 would no longer be displayed in the result.