I have the following problem. I have a cube where I want some measures aggregated across all dimensions, but one set of measures should exclude one non-time dimension from aggregation. Specifically I have the following case: A consolidated Premium / Claim fact table containing [Written Premium] and [Loss Incurred]. There are Policy and Claim dimensions. [Loss Incurred] should aggregate across both dimensions, however [Written Premium] should not aggregate over Claims.
Is there a good way to do this with MDX? All of my research has come up blank, only telling me how to set up parent-child hierarchies and Account types. Am I just attempting something that SSAS is not well suited to handle?