Count Distinct Measure wrong result
My DB version is 11.2.0.4 on Oracle Linux 5 64 bit
We want to count the distinct values of the leaf level of one dimension in our cube. We need to be able to count distinct values against all levels of all other available dimensions.
The technique we followed was the one stated in the beginning of this thread.
- Create a new attribute that has 1 for all records in the fact cube.
- Set aggregation to MAX for all other dimensions.
- Set aggregation to SUM for the dimension we want to count distinct values for.
- The order for the aggregation is all MAX are first and SUM is last.