For the Measure C170 the DB_COLUMN_NAME (date_key) was mentioned in lower case. whereas in DB the column name (DATE_KEY) is upper case. Change the Measure "C170" DB_COLUMN_NAME to upper case, the KPI should work fine.
Modifying the 'From' email ID in arc.properties and re-caching changes will enable you to view the altered 'From' email ID only in case of Report Subscriptions and Alerts. However, in case of Schedule Email and Export Email, the email ID of the user ...