How to implement a right outer join between fact-dimension joins

Symptom

In AtScale, when the user makes a fact-to-dimension join, AtScale enforces inner joins by default.  This article details a method of changing the join to be a right outer join (all matching rows from the fact table and all the rows from the dimension tables).

Procedure

Step 1.  In the Design Canvas, navigate to a dimension

Step 2.  Double click on the hierarchy name

Note: the right outer joins will be placed on all hierarchy levels.

Step 3.  Confirm that the 'edit a hierarchy' dialog box opens up

Step 4.  Edit the property "EXCLUDE VALUES WITH NO FACT DATA" and select "No"

Step 5.  Publish the cube

Result

Now when the user queries for Product Category and Measure from the fact table, all Product Categories will appear in the query results (even those which do not have a matching measure value from the fact table).