• if you are trying to find out which side I am on when it comes to the DW design approach dichotomy then I would say this is not the right forum. But if you are honestly seeking my opinion then that's OK.

    You mention the fact that Data modeled dimensionally, provides the best performance when aggregating large datasets. My opinion is that whatever is feeding your SSAS cube is best modelled dimensionally.

    Frank Banin
    BI and Advanced Analytics Professional.