About Measures in Multidimensional Data Sources

Always verify aggregation rules after importing a cube. In most cases Semantic Modeler assigns aggregation rules correctly when you import a cube.

However, if a measure is a calculated measure, then during import Semantic Modeler sets the aggregation rule to None. Therefore it's important that you examine the aggregation rule for all measures after importing a cube to verify that Semantic Modeler assigned the aggregation rules correctly.

For all measures with None assigned as the aggregation rule, contact the data source's administrator to verify that the value is accurate.

When you need to select the aggregation rule for a physical cube column, be sure to select the aggregation rule carefully so that the measures are correct. Setting the aggregation rule correctly might improve performance.

For more information about how to set the measure's aggregation rule, see Change a Multidimensional Measure's Aggregation Rule.