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.SumFromAvg
factCountExpr
Avg, Count, DistinctCount, enumeration, Max, Min, Sum
description, 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) |
aggregate
aggregate, getNonDistinctAggregator, getRollup, isDistinct, supportsFastAggregates
equals, getDescription, getName, getOrdinal, toString, unexpected
public AvgFromAvg(String factCountExpr)
public String getExpression(String operand)
RolapAggregator
getExpression("emp.sal")
returns
"sum(emp.sal)"
.getExpression
in class RolapAggregator
public boolean alwaysRequiresFactColumn()
alwaysRequiresFactColumn
in class RolapAggregator.BaseAggor
public String getScalarExpression(String operand)
getScalarExpression
in class RolapAggregator.BaseAggor
Copyright © 2020 Hitachi Vantara. All rights reserved.