This discussion is archived
1 Reply Latest reply: Jan 24, 2013 3:01 AM by Robert Angel RSS

AVG aggregation not hitting the Aggregate table.

944747 Newbie
Currently Being Moderated
Hi All,

I have created two measures in which measure 1 has aggregation rule set to AVG and measure 2 has the aggregation level set to SUM. I have mapped this column to both base fact and Aggregate table.I have also set the level at for the table in Source folder. Measure 2 which has SUM as aggregation rule is hitting the Aggregate table but measure 1 which has AVG as the Aggregation rule is not hitting the Aggregate table,it always hit the base fact.

Any suggestion or solution on resolve this problem.

Any help is reallly appreciated.

Thanks,
Mohit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points