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.
Avg, Count, DistinctCount, enumeration, Max, Min, Sum
|Modifier and Type||Method and Description|
Returns the expression to apply this aggregator to an operand.
aggregate, getNonDistinctAggregator, getRollup, isDistinct, supportsFastAggregates
equals, getDescription, getName, getOrdinal, toString, unexpected
public AvgFromAvg(String factCountExpr)
public boolean alwaysRequiresFactColumn()
Copyright © 2019 Hitachi Vantara. All rights reserved.