Exercise 26
We use the metric to force the SQL generator to use the fact table FactResellerSales
; otherwise, MicroStrategy would use the lookup (DimEmployee
), which is smaller and faster, but, in that case, we won't have the correct result.
We use the metric to force the SQL generator to use the fact table FactResellerSales
; otherwise, MicroStrategy would use the lookup (DimEmployee
), which is smaller and faster, but, in that case, we won't have the correct result.