• if you don't have a choice but to pull data directly from an OLTP system or a non multi dimensional data source to the cube then that's OK to model data in SSAS. The best practice is model your business dimensionally in a database before SSAS.

    Frank Banin
    BI and Advanced Analytics Professional.