SYMPTOM:
In Strategy 9.x-10.x, a report containing several attributes and one metric displays repeated result rows in both Developer and Web as shown below:
Attribute A Attribute B Attribute C Metric
1 X 2 Z 3 Y W
1 X 2 Z 3 Y W
1 X 2 Z 3 Y W
(1, 2, 3 stands for Attribute ID form, X,Y,Z etc. stands for Attribute DESC form)
Running the report SQL directly in Strategy DB Query tool gets correct result. Notice different metric value is expected.
CAUSE:
Each row has exactly the same ID form value of all attributes, one example shown below:
Attribute A Attribute B Attribute C Metric
1 X 2 Z 3 Y W
1 Y 2 Y 3 Q K
1 Z 2 X 3 C J
ID form is a form that can uniquely identify a record. When they’re the same, Analytical Engine takes them as the same and shows repetition.
ACTION:
Re-define a ID form that can uniquely identify a record. It could be another form or a compound form with several base forms.
