The reason Best Method is not showing when run by a Job is because of the service account. Give the service account full access to all data in security, then try running the job again.
Delete Null Attribute Isolate a single override that is failing, preferably one at a very low level that affects very few rows in the fact table (a single record would be best), then capture the SQL queries made around processing that override. An ...