15.00 - 5521 The RANDOM function can not be used in Aggregates or Ordered Analytical Functions. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5521 The RANDOM function can not be used in Aggregates or Ordered Analytical Functions.

Explanation:

SUM(Random(X,Y)) and CSUM(Random(X,Y),date) like usage is not allowed for semantic simplicity.

Generated By:

ParFdRan

For Whom:

End User.

Remedy:

Do it as a two step process: aggregate or Ordered Analytical Function on a derived table with Random values