|
Style Intelligence v12.0 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectinetsoft.uql.asset.AggregateFormula
public abstract class AggregateFormula
Aggregate formula represents an aggregate formula in SQL.
| Field Summary | |
|---|---|
static AggregateFormula |
AGGREGATE
Aggregate formula for cube. |
static AggregateFormula |
AVG
AVG formula. |
static AggregateFormula |
CORRELATION
Correlation formula. |
static AggregateFormula |
COUNT_ALL
Count all formula. |
static AggregateFormula |
COUNT_DISTINCT
Count distinct formula. |
static AggregateFormula |
COVARIANCE
Covariance formula. |
static AggregateFormula |
FIRST
Sum formula. |
static AggregateFormula |
LAST
Sum formula. |
static AggregateFormula |
MAX
Max formula. |
static AggregateFormula |
MEDIAN
Median formula. |
static AggregateFormula |
MIN
Min formula. |
static AggregateFormula |
MODE
Mode formula. |
static AggregateFormula |
NONE
None formula. |
static AggregateFormula |
POPULATION_STANDARD_DEVIATION
Population standard deviation formula. |
static AggregateFormula |
POPULATION_VARIANCE
Population Variance formula. |
static AggregateFormula |
STANDARD_DEVIATION
Standard deviation formula. |
static AggregateFormula |
SUM
Sum formula. |
static AggregateFormula |
SUMSQ
Sum of square. |
static AggregateFormula |
SUMWT
Weighted sum. |
static AggregateFormula |
VARIANCE
Variance formula. |
static AggregateFormula |
WEIGHTED_AVG
Weighted average formula. |
| Constructor Summary | |
|---|---|
AggregateFormula()
|
|
| Method Summary | |
|---|---|
Object |
clone()
|
boolean |
equals(Object obj)
Check if equals another object. |
String |
getCubeExpression(String set,
String measure)
Get the expression of the formula used for mdx. |
String |
getCubeFormulaName()
Get formula name used for mdx. |
String |
getDataType()
Get the type of the formula result. |
static AggregateFormula |
getDefaultFormula(String type)
Get the default formula for the data ref. |
abstract String |
getExpression(String column,
String col2,
AggregateHelper helper)
Get the SQL expression of the formula. |
abstract String |
getExpressionSub(String column,
String col2,
AggregateHelper helper)
Get the SQL expression using sub-aggregates. |
static AggregateFormula |
getFormula(String name)
Get the aggregate formula. |
abstract String |
getFormulaName()
Get a formula that can be used to create a formula calculation object. |
static AggregateFormula[] |
getFormulas()
Get all the available formulas. |
static String |
getIdentifier(AggregateFormula formula)
Get the identifier. |
static String[] |
getIdentifiers(boolean none)
Get all the available identifiers. |
String |
getLabel()
Get the label of the agggregate formula. |
abstract String |
getName()
Get the display name. |
AggregateFormula |
getParentFormula()
Get the parent formula. |
String |
getUID(String column,
String col2)
Get an unique id for the formula that can be used to identify an aggregate column. |
String |
getUID(String column,
String col2,
String formula)
Get an unique id for the formula that can be used to identify an aggregate column. |
protected String |
getUIDName(DataRef ref)
Get the uid name of a data ref. |
int |
hashCode()
Get the hash code. |
boolean |
isCombinable()
Check if this formula can be calculated from the result of sub-groups, or the sub aggregate of the sub-groups. |
boolean |
isComposite()
Check if this is a composite formula. |
boolean |
isTwoColumns()
Check if the formula requires two columns. |
void |
setComposite(boolean composite)
Set whether the calculation should be done by composing results from sub-aggregates. |
String |
toString()
Get string representation. |
| Methods inherited from class java.lang.Object |
|---|
finalize, getClass, notify, notifyAll, wait, wait, wait |
| Field Detail |
|---|
public static final AggregateFormula NONE
public static final AggregateFormula AVG
public static final AggregateFormula COUNT_ALL
public static final AggregateFormula COUNT_DISTINCT
public static final AggregateFormula MAX
public static final AggregateFormula MIN
public static final AggregateFormula SUM
public static final AggregateFormula FIRST
public static final AggregateFormula LAST
public static final AggregateFormula MEDIAN
public static final AggregateFormula MODE
public static final AggregateFormula CORRELATION
public static final AggregateFormula COVARIANCE
public static final AggregateFormula VARIANCE
public static final AggregateFormula STANDARD_DEVIATION
public static final AggregateFormula POPULATION_VARIANCE
public static final AggregateFormula POPULATION_STANDARD_DEVIATION
public static final AggregateFormula WEIGHTED_AVG
public static final AggregateFormula SUMSQ
public static final AggregateFormula SUMWT
public static final AggregateFormula AGGREGATE
| Constructor Detail |
|---|
public AggregateFormula()
| Method Detail |
|---|
public static AggregateFormula[] getFormulas()
public static String[] getIdentifiers(boolean none)
none - true to include none, false otherwise.public static String getIdentifier(AggregateFormula formula)
formula - the specified aggregate formula.
public static AggregateFormula getFormula(String name)
name - the specified formula name or identifier.
public static AggregateFormula getDefaultFormula(String type)
data - type.public abstract String getName()
public abstract String getExpression(String column,
String col2,
AggregateHelper helper)
column - the specified column used in the expression.col2 - the secondary column for formulas that perform calculation
on two columns, such as correlation and weighted average. This parameter
is ignored for formulas that don't require a secondary column.helper - the helper for the target database.
public abstract String getExpressionSub(String column,
String col2,
AggregateHelper helper)
column - the specified column used in the expression.col2 - the secondary column for formulas that perform calculation
on two columns, such as correlation and weighted average. This parameter
is ignored for formulas that don't require a secondary column.helper - the helper for the target database.
public abstract String getFormulaName()
public String getCubeFormulaName()
public String getCubeExpression(String set,
String measure)
public boolean isCombinable()
public void setComposite(boolean composite)
public boolean isComposite()
public String getUID(String column,
String col2)
protected String getUIDName(DataRef ref)
ref - the specified data ref.
public String getUID(String column,
String col2,
String formula)
public String getDataType()
public boolean isTwoColumns()
public String getLabel()
public String toString()
toString in class Objectpublic int hashCode()
hashCode in class Objectpublic boolean equals(Object obj)
equals in class Objectpublic AggregateFormula getParentFormula()
public Object clone()
clone in class Object
|
Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved. | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||