SYMPTOM:
When running reports with element prompts in metric definitions in Strategy Developer 9.x and 10.x, following error message appears:
Error(s) occured while loading report: DSSSQLEngine: Schema loading error: Template(Local Template). -Template Unit Metrics-Template Metrics-Dimensional Metric (M1). -Dimensional Metric-Unsupported object in Metric.
The metric definition contains an element prompt:
ApplySimple("datepart(yy, #E0)", ?[Elements of Day])
CAUSE:
This is because element prompt is not supported in metric definition in Strategy 9.x and 10.x.
WORKAROUND:
Value prompt can be used in metric definitions or users need to add element prompts in report level.
