It seems that I have no option for creating calculated fields when attached to SSAS and yet I know that SSAS can perform calculations on measures. I also apparently do not have any options for ad-hoc grouping on a dimension. What options/workarounds do I have for working with these limitations?