I have created a measure in a dimension of different interest rates. The 'Semi-Aggregate' and 'Regular Aggregate' properties in FM for this measure are 'Sum' (these properties do not seem to be editable).
What happens is...in Report Studio, when I want to create a report that lists these different interest rates, it sums them up, instead of listing each one.
In other words...I want this:
1%
2%
3%
But what I get is...
6%
How can I override this Sum function? Or at least somehow change it in the framework?
Change the RegularAggregate property to 'Unsupported'
MF.