Select for values where NO entries in a dimension

[Anonymous]

Hi Folks,

there are three Tables:

Dim_Customer    &CustomerID, CustDetail1, ....

Dim_Budget        &CustomerID, BudgetDetail1, BudgetYear, ....

Fact_Orders        &CustomerID, Fact1, Fact2, ....

Not all of the customers do have a Budget.

I can easily calculate Budget against Fact in a given Time Range.

I want to calculate all Facts against those customers which have no data in Dim_Budget.

Please see attached Picture Q_Dimension. The right coloumn Shows all Customers with Budget, The left Shows all customers with and without Budget,

and I want to calculate Facts only for those customers which have NO Budget.

Always difficult to explain:-)

Hope you can help. Thanks beforehand.

Wolfgang