AS2000 SP4

I have a production cube that lists number of units sold by employees. The
fact table is on the account level, i.e. it lists the employee id, the sale
number, and other attributes associated with the sale. There are employees
that have no units sold; therefore, they are not in the fact table. I am
able to list these employees by substituting null values with 0's:

iif(isempty([Measures].[Units]),0,[Measures].[Units])

There are multiple positions of employees, i.e. Personal Banker, Customer
Service Rep, etc. This Position dimension becomes obsolete with the above
substitution - there are multiple empty crossjoins associated with the above
calc member.

Is there any way to include a filter in the above calc member to filter by
the position dimension?

BUMP

"Pasha" wrote: