SYMPTOM:
The following error is encountered when using a custom metric formula in SAP BW 7.0 to filter on an attribute in Strategy 9.x: and 10.x
Error: SQL Generation Complete
QueryEngine encountered error: ExecQuery failed. MDX Execution failed.
Error type: JCO layer error. JCOStatement.executeQuery failed. java.lang.Exception: Error during MDX Query Execution
Error during Bapi Execution: Invalid MDX command with
at com.Strategy.Database.JCO.JCOStatement3.executeQuery(Unknown Source)
. Connection String: N/A;. Connection String: N/A;. SQL Statement: with member . as 'IIf(.CurrentMember.Name = ..Name; .; NULL)'
set as '{..members}'
select {.} on columns,
non empty on rows
from
cell properties CELL_ORDINAL, FORMATTED_VALUE, VALUE, FORMAT_STRING
..
Error in Process method of Component: QueryEngineServer, Project_SAP_BW, Job 90215, Error Code= -2147212544.
IIf(.CurrentMember.Name = ..Name; .; NULL)
IIf(.CurrentMember.Name = ..Name, ., NULL)