I have two Dimension Tables ( Company and Product) and two Fact Tables ( Budgets and Sales).
Product is joined to Company on Department Number, Budgets is joined to Company on Department No and Sales are joined to Product on product No.
I would prefer to have a single Company / Product dimension with a User Hierarchy of Company No > Department No > Product No.
Departments that do not have any Products are being ignored by the inner join and, as a consequence, Budgets associated with these Departments are being rejected.
Is there a way of including these Departments in the single Dimension?