Thanks Craig,

I'm a bit new to dimensional modeling and misunderstood a best practice. Rather than using views as source for dims and fact tables... use views of dims and facts to support a cube. This seems to be fairly common with the primary advantage of easy maintenance if you're used to TSQL...

That said... I am working through creation of my dim / facts with intention of building some indexes focused on reads.

I suppose my question now is can I (should I) use the same dim / facts and subsequent views to support reporting as well as ssas?

Thanks again...