Length of Expressions
When creating layout calculations that use complex
expressions, limit the length of the expression to less than 1,000
tokens. A token is a keyword, identifier, constant, or special character
symbol that the server identifies when it parses the SQL. For example,
the expression 1+1+1+1+1+1+1+1+1+1 contains approximately 28 tokens,
whereas the expression 1+1+1...+1 (400 times) contains more than 1000
tokens.
Tip: The Sales Commissions for Central Europe sample report in the GO Data Warehouse
(analysis) package includes expressions.