Vizubi now treats relationships between tables as outer joins while previously relationships were treated as inner joins. That means that you will now see all the values for all fields in the database. Products which have never been sold will be shown in reports with the product field and Countries where you have never made a sale will be shown in reports with the Country field. This may lead to unexpected results and in particular some reports may have columns with blank column headers and with zero values.
Vizubi creates an “unknown member” to handle all non-matching rows in relationships. If there are products with no product category assigned to them, a sales report by product category will include an unnamed column with the statistics for those products summed together.
Reports before the outer join
For this sample we used the Vizubi database called “Vizubi AdventureWorksDW.ndb” used in several tutorials:
Create a straight table report with ProductLine, EnglishProductCategoryName and EnglishProductSubCategoryName in the Row labels pane and SalesAmout in the Values pane.
The result with the previous version (and therefore using inner joins) is shown above. The same report using the new version of Vizubi with outer joins is shown below.
The same report with outer joins
The same report with the new version shows all values for all fields, including subcategories which have never been sold.
In the light blue rows you can see several fields previously excluded when using the inner join – these are product sub-categories whose products have never been sold (for instance in row 8, the Socks sub-category has never been sold): several subcategories and the Components category now appear in the report.
In the green rows you can see subcategories with no product line; this makes sense as these are all components and therefore we would not expect them to necessarily be associated with a single product line (Vizubi has created an unknown member to contain these values).
The zero value in the yellow row means that there are other fields not present in the report that could produce sales. In this case the yellow line represents products that aren’t associated with a sub-category, a category or a product line. If you add the product name column to this report, you will see a series of products with these characteristics.
Vizubi now treats relationships between tables as outer joins while previously relationships were treated as inner joins. That means that you will now see all the values for all fields in the database. Products which have never been sold will be shown in reports with the product field and Countries where you have never made a sale will be shown in reports with the Country field. This may lead to unexpected results and in particular some reports may have columns with blank column headers and with zero values.
Vizubi creates an “unknown member” to handle all non-matching rows in relationships. If there are products with no product category assigned to them, a sales report by product category will include an unnamed column with the statistics for those products summed together.
Reports before the outer join
For this sample we used the Vizubi database called “Vizubi AdventureWorksDW.ndb” used in several tutorials:
Create a straight table report with ProductLine, EnglishProductCategoryName and EnglishProductSubCategoryName in the Row labels pane and SalesAmout in the Values pane.
The result with the previous version (and therefore using inner joins) is shown above. The same report using the new version of Vizubi with outer joins is shown below.
The same report with outer joins
The same report with the new version shows all values for all fields, including subcategories which have never been sold.
In the light blue rows you can see several fields previously excluded when using the inner join – these are product sub-categories whose products have never been sold (for instance in row 8, the Socks sub-category has never been sold): several subcategories and the Components category now appear in the report.
In the green rows you can see subcategories with no product line; this makes sense as these are all components and therefore we would not expect them to necessarily be associated with a single product line (Vizubi has created an unknown member to contain these values).
The zero value in the yellow row means that there are other fields not present in the report that could produce sales. In this case the yellow line represents products that aren’t associated with a sub-category, a category or a product line. If you add the product name column to this report, you will see a series of products with these characteristics.