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.
your aggregate table will only be used when all of the measures present in whatever analysis are also present in the aggregation table and the mapping in the business model - try running the sum measure in isolation (without any other measures present) - does that then hit the aggregation table?