KB442266 Receiving Error: "AnalysisException: all DISTINCT aggregate functions need to have the same set of parameters" when multiple count(distinct) metrics exist on a template.

Symptom:
The error is observed in all versions of the Strategy 10 Platform. This issue is specific to Impala. Impala does not support multiple count(distinct) calculations in a single query). More information on this can be found here. The VLDB Property, ‘Separate COUNT DISTINCTs’ is not being implemented as expected causing this error to occur.

"AnalysisException: all DISTINCT aggregate functions need to have the same set of parameters as count(DISTINCT ..."

1. Place two metrics on a Report using Count distinct that are from the same fact table

Cause:
This is an identifed defect in Strategy 10.x.
Action:
Upgrade to Strategy 11.x to take advantage of this defect resolution
 
Strategy reference numbers for this technical note are KB442266 and DE105342.