Additive or non-additive dimension depending on the measure group

Hi,

I have a dimension called [Year of Account]. For most of my measure groups all values are additive over this dimension - no problem there.

Unfortunately I have one measure group that is NOT additive over this dimension.

I wanted to deal with this by removing the [Year of Account].[All] member from the dimension but I only want to remove it for this one measure group. As far as I know that's not possible. (Or am I wrong?)

Any other ideas about how I should deal with this? Any suggestions welcome.

Thanks

Jamie

I think you are probably right, one possible work around would be to use an MDX script assignment to override the value in the relevant subcube so that the users did not see misleading information.

eg.

([Year of Account].[All] ,MEASUREGROUPMEASURES(MeasureGroupName)) = "NA";

OR

([Year of Account].[All] ,MEASUREGROUPMEASURES(MeasureGroupName)) = null;