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.