refresh reference tables

I have a single query which I then break up into the facts and tables using m language.  for each dimension I create a reference then remove columns and reduce to distinct rows.  finally, I remove th...