Take a Data Cube with all the fields and nest it inside another Data Cube. Set an int measure to DistinctCount. That int measure’s distinct count value is now always 1. For some reason the distinct count aggregator does not work with nested cubes, but the other aggregators do.
Here is the Process Result statistics of my final data cube testing example.
SUM – 237,555,426
AVG – 6,128.56
MIN – 5,978
MAX – 6,239
DISTINCT – 262
The DistinctCount aggregator itself must be bugged with the nested data cube, because when you use this Data Cube in a fresh metric set the distinctcount is not 262, it is 1.
Am I just missing a limitation that is known with nested data cubes, some sort of nested caching issue, or is this a bug?