BW 7.5 SP 10 on HANA - BEx Variable Value help Error when using composite provider -
Anexceptionof type 'CX_SY_DYNAMIC_OSQL_SEMANTICS' occurred, that was not caught anywhere in the call hierarchy. It was not handled
Afieldname 'CM_HIEID', used in an SQL command, is unknown. It is possible that the field name in the SQL statement is too long or
Position in code >> Row: 218 Inc: IF_RSR_VARIABLE_F4_RESTRICT~GET_RESTRICT Prog: CL_RSBCT_RP_VAR_F4_CDT_STRUC Diagnosis En error has been triggered.
This message specifies where in the coding the error occurred.
This helps you to localize the error quickly.
System Response Procedure
Procedure for System Administration RS_EXCEPTION 301
We are running BW 7.5 SP10 on HANA 2.00.043.00.1569. As of now we are using BEx Analyzer for reporting. We are getting the error using Variable value help. Error comes when the Filter Value Selection is set to Only Posted Values for Navigation or Only posted values in Infoprovider. It works fine if we set this to Values in Master data table. BEx query is based on a composite provider which consumes HANA View as provider. Verified in RSRT also and the error appears there too.
In Analysis for Office as soon as we open the query it just disconnects the connection and do nothing.
Any help is appreciated.