Friday, March 23, 2012

Forcing Calculated Measure to be calculated at processing

When is a calculated measure calculated? My understanding is that it depends on the aggregation level and can be pre-calculated if the aggregation level is high enough in the aggregation design.

I have a calculated measure that is core to all my processing and is the main reason for building a particular cube, Is there anyway I can force a calculated measure to always be calculated as part of the processing?

Only real measures and measures expressions are precomputed during processing. Calculated measures cannot be forced to be computed during processing.

|||

So how can I get a pre-calculated measure without having to do all the work in SQL as part of the DSV?

Can I create a real measure which is calculated via a MeasureExpression or something?

|||

You cannot.

P.S. Measure expressions only allow multiplication or division of two real measures, and it is just a way to do a join between measure groups.

No comments:

Post a Comment