Standard Deviation Invalid
Posted: Tue Nov 01, 2005 12:24 pm
Hello,
According to DS documentation the Standard Deviation functionality on the Aggegator should work for all numeric types. I switched my input and output column data type from a integer (working) to decimal(15,2). It is now not working. The warning message received is:
WorkDW00QL_TrendTest..CntrCalcLimits.AggrAvgStdDev: While creating "DSColumnC" object of type ""
While parsing derivation expression for column "FromAggregate.standard_deviation"
Syntax error at line 1, column 8, token "amount"
Invalid argument type
Followed by a fatal message:
WorkDW00QL_TrendTest..CntrCalcLimits.AggrAvgStdDev: |-100|
I have also tried numeric(15,2) but this gave the same error. Both sum and average functions are working on the same input.
Is this a known bug? Is there a workaround (other than rounding input to integer), or calculating standard deviation myself in a transform?
Thanks,
Greg
According to DS documentation the Standard Deviation functionality on the Aggegator should work for all numeric types. I switched my input and output column data type from a integer (working) to decimal(15,2). It is now not working. The warning message received is:
WorkDW00QL_TrendTest..CntrCalcLimits.AggrAvgStdDev: While creating "DSColumnC" object of type ""
While parsing derivation expression for column "FromAggregate.standard_deviation"
Syntax error at line 1, column 8, token "amount"
Invalid argument type
Followed by a fatal message:
WorkDW00QL_TrendTest..CntrCalcLimits.AggrAvgStdDev: |-100|
I have also tried numeric(15,2) but this gave the same error. Both sum and average functions are working on the same input.
Is this a known bug? Is there a workaround (other than rounding input to integer), or calculating standard deviation myself in a transform?
Thanks,
Greg