KPI Preview produces results but does not work when analyzed. Why?
One of the reasons could be: The KPI might have been published using a Force aggregate option (opting for the aggregate table which the KPI has to refer to). The pre-requisite is all the measures used in the KPI must be available in the aggregate table which the KPI is referring to. The 'Force aggregate' option will not be considered in the preview mode and hence the KPI might be producing results in preview. Re-configure the KPI by ensuring that all the measures used in the KPI are available in the force aggregate.