I'm designing an SSAS cube with 2 measure groups, each representing a business process related to Orders. The fact table for the first measure group (Order Fact) is loaded when an Order is placed, and the fact table for the 2nd measure group (Order
Check Fact) is loaded when a Check is cut to pay for the Order. In addition, a third measure group (using Order Fact) has been created to calculate a Distinct Count of Orders (the measure name is [Number of Orders]).
Here is what the Dimension Usage tab looks like (all Regular relationships):