public static class RolapAggregator.AvgFromAvg extends RolapAggregator.BaseAggor
It uses the aggregate table fact_count column and an average measure to create the query used to generate an average:
 
    avg == sum(column_sum * factcount) / sum(factcount).
 
 
 If the fact table has both a sum and average over the same column and the aggregate table only has a average and fact count column, then the average aggregator can be generated using this aggregator.
RolapAggregator.AvgFromAvg, RolapAggregator.AvgFromSum, RolapAggregator.BaseAggor, RolapAggregator.SumFromAvgfactCountExprAvg, Count, DistinctCount, enumeration, Max, Min, Sumdescription, name, ordinal| Constructor and Description | 
|---|
AvgFromAvg(String factCountExpr)  | 
| Modifier and Type | Method and Description | 
|---|---|
boolean | 
alwaysRequiresFactColumn()  | 
String | 
getExpression(String operand)
Returns the expression to apply this aggregator to an operand. 
 | 
String | 
getScalarExpression(String operand)  | 
aggregateaggregate, getNonDistinctAggregator, getRollup, isDistinct, supportsFastAggregatesequals, getDescription, getName, getOrdinal, toString, unexpectedpublic AvgFromAvg(String factCountExpr)
public String getExpression(String operand)
RolapAggregatorgetExpression("emp.sal") returns
 "sum(emp.sal)".getExpression in class RolapAggregatorpublic boolean alwaysRequiresFactColumn()
alwaysRequiresFactColumn in class RolapAggregator.BaseAggorpublic String getScalarExpression(String operand)
getScalarExpression in class RolapAggregator.BaseAggorCopyright © 2017 Hitachi Vantara. All rights reserved.