Our Fact table has a EMPLOYEE_ID column that references a EMPLOYEE dimension table. We need a measure that is a distinct count of the Employees. The Analysis Manager Cube Editor UI does not have a “disctinct count� rollup which could be applied to a text EMPLOYEE_ID column in the fact table. How can I create such a measure

Analysis manager will not allow Distinct Count Measure
Aggregate on a Text Column. You will need to probably have
a Integer Column associated with each EMPLOYEE_ID Text
Field.


distinct count of the Employees. The Analysis Manager Cube
Editor UI does not have a â?odisctinct countâ?� rollup
which could be applied to a text EMPLOYEE_ID column in the
fact table. How can I create such a measure?

I have converted the text column into a Number column. I am getting the error "Processing error [Column type for distinct count measure column not supported] ''. I am getting this error even when the column type is Number or Float.
There are a some rows that have NULLs in the Numeric column on which the Distinct count measure is based. Is that the source of the error?