• While I know it's theoretically possible to build your SSAS db from a normalized relational db, I've never done it (nor seen it). I've always used a star schema (with perhaps a little snow-flaking). I would say yes, this is the accepted best practice to base your SSAS db & cubes upon a star schema db.

    Just my opinion, YMMV.

    Rob