If a CaseV statement is used within an attribute form, an error is encountered when a report containing the Attribute is executed in Strategy.
For example, an attribute may be created using a the CaseV function:
A report containing this attribute produces the following error:
Status: Execution failed Error: SQL Engine got an Exception from DFC: [DFCENGINE]Engine Logic: Generate SQL for attribute form expression failed, please check if the expression is valid.Error in Process method of Component: SQLEngineServer, Project1, Job 1527, Error Code= -2147212800.
The Strategy CASE and CASEV functions are designed to evaluate in the Analytical Engine over metric result data. Attribute form expressions must be rendered into SQL and cannot use any Strategy functions specific to the Analytical Engine.
If the CASE expression has only one branch -- i.e., one condition, a true expression and a false expression -- the Strategy IF function may be used instead.
IF(condition, true- expression, false-expression)
Note that the IF function cannot be nested. If multiple branches are required, users should write the exact CASE statement syntax for the database platform using ApplySimple.
For more information regarding Case statements, refer to the following Strategy Knowledge Base document:
KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine
