One of our reports has been running extremely slow. Taking almost 5 minutes for 32 rows
By removing one of the metrics on the report, the execution time improved dramatically from 5 minutes to 45 seconds!
The metric I removed was just a count on an Attribute (Employee ID).
So, I created a Fact based on (Employee_id) and then created a metric to count on the fact instead (of the Attribute).
The report now runs in a decent 45 seconds.
I looked at the Report SQL of the two scenarios
(Using an Attribute in a Metric VS a Fact in a Metric)
I found:
- Using a fact total number of passess = 1
- Using an attribute total number of passess = 5
Does anyone have any insight on why this occurs?
Thanks
Aman
By removing one of the metrics on the report, the execution time improved dramatically from 5 minutes to 45 seconds!
The metric I removed was just a count on an Attribute (Employee ID).
So, I created a Fact based on (Employee_id) and then created a metric to count on the fact instead (of the Attribute).
The report now runs in a decent 45 seconds.
I looked at the Report SQL of the two scenarios
(Using an Attribute in a Metric VS a Fact in a Metric)
I found:
- Using a fact total number of passess = 1
- Using an attribute total number of passess = 5
Does anyone have any insight on why this occurs?
Thanks
Aman