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
Standard Deviation Invalid
Moderators: chulett, rschirm, roy
Off-hand, this part of the message gives me concern:
Just for giggles, did you try redoing the derivation after playing with the metadata?
The blank object type makes me think maybe some internal metadata is screwed up. This stage historically had some issues where derivations were lost. Also, the metadata is important.While creating "DSColumnC" object of type ""
Just for giggles, did you try redoing the derivation after playing with the metadata?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 23
- Joined: Thu Oct 27, 2005 12:51 am