• No, I didn't find a way to make this work. As an alternative, I created physical tables rather than views, and populate them as part of my DW ETL. It's a few extra steps and costs more disk space, but it works.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices