Set Aggregation Rules for a Measure Column

You need to specify aggregation rules for mapped logical columns that are measures.

If your measure has different aggregation rules for different dimensions, for semi-additive measures, then you choose Based on dimensions as the measure's aggregation rule. See Set an Aggregation Level Based on a Dimension for a Measure Column.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical Layer .
4. In the Logical Layer pane, browse for the table with the logical column that you want to add an aggregation rule to.
5. In the logical table, click the Columns tab.
6. In the column table, click the column to highlight it, and then click Detail view to view its properties.
7. In the logical column's Aggregation properties, click the Aggregation Rule field and select an aggregation rule.
8. Click Add Aggregation by Level and in the Dimension field select a table source.
9. Click the Logical Level field and select the level of aggregation. What you choose is the minimum level of aggregation, and the measure won't be aggregated below the level you choose.
10. Click Save.