I am getting error when using SQL Server Connection and trying to create an expression using [custom measure1]/[measure2].
[custom measure1] is created at dataset level. [measure2] can be a regular measure column or another custom measure created at dataset level.
’Accepted’ custom measure at dataset level:
CASE WHEN [session_disposition_type_id] IN (1,2,16) THEN session_history_id END
’session_history_id’ is a regular measure.
Expression at visual level:
Validation Error: (103, b"The identifier that starts with ‘(count(distinct ((CASE WHEN (TA_0.[session_disposition_type_id]) IN (1,2,16) THEN (TA_0.[session_history_id]) END)))/count(distinct (((TA_0.[session_history_id])))))*100’ is too long. Maximum length is 128.DB-Lib error message 103, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")
This similar scenario works fine when using ArcEngine connection. Please suggest.