4.7.2 Editing Dimension and Measure Properties

You can change the names of dimensions and measures from the 'Properties' panel of the Hierarchy tab. Additionally, the aggregation method for each measure can be specified using the 'Aggregate' menu.

 

The aggregation method determines how a particular measure is summarized at the different levels of dimensional granularity. For example, consider the case where you have the hierarchically-related dimensions 'Month' and 'Day', and a measure 'Cost'. If you aggregate the measure by 'AVG', then the value of the measure when viewed along the 'Month' dimension will be “average cost per month,” while the value of the measure when viewed along the 'Day' dimension will be “average cost per day.” Likewise, if you aggregate the measure by 'MIN', then the value of the measure when viewed along the 'Month' dimension will be “minimum cost per month,” while the value of the measure when viewed along the 'Day' dimension will be “minimum cost per day.”

<< 4.7.1 Creating a Hierarchical OLAP Overlay © 1996-2013 InetSoft Technology Corporation (v11.4) 4.7.3 Creating Derived Measures >>