Skip to Main Content

Aggregation based on Dimensional Hierarchies

737665Dec 23 2009 — edited Dec 23 2009

I have a fact table with a population measure,I need to set the aggregation for the population to average for the time dimension and sum for others. (the report required to measure the population during a period of time in two different years).

when i am trying to do this using the based on dimension check box in the aggregation tab the measure values does not shown in the answers.

if i set the aggregation to sum and uncheck the based on dimension i receive results but not the one i am looking for.

Thanks in advance.