Change a Multidimensional Measure's Aggregation Rule

A measure's aggregation rule determines how the Oracle Analytics query engine aggregates the measure in relation to the cube table's dimensions.

In most cases when you import a cube into the physical layer, Semantic Modeler assigns the aggregation rules correctly. In some cases you might need to reassign a measure's aggregation rule.

See About Measures in Multidimensional Data Sources.

Use the following guidelines to assign a measure's aggregation rule in the physical layer:

• If the generated physical queries to the database should send an aggregation function, then set that function as the aggregation rule. For example, if the aggregation function is SUM(revenue), set the aggregation rule to Sum.

  With this setting, the Oracle Analytics query engine typically sends the aggregation to the database in the query, but might also perform aggregations itself in certain situations.

• If the data for this measure shouldn't be aggregated in the query or by the Oracle Analytics query engine, use the External Aggregation rule. It's important to choose this setting when the measure uses a more complex calculation inside the data source than the Oracle Analytics query engine can replicate with a simple aggregation rule such as calculations for ratios, consolidations, and allocations. This option is also useful when the cube persists a full set of pre-aggregated results.

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 Physical Layer .
4. In the Physical Layer pane, browse for and double click the measure that you want to change the aggregation rule for.
5. Click the Measures tab and in the measures table locate and double click to select the measure. Click Detail view to view its properties.
6. Click the Aggregation Rule field and select an aggregation rule.
7. Click Save.