Query Generation error

[Former Member]

Hi, SDNs

We have a InfoCube with non-cumulative key figure:HTMMKCX

Step1: When create a query on this cube

Step2: select any Characteristic into Rows and select the non-cumulative key figure into Columns

Step3: Check the query

Error Display: Unable to generate query RSR_BAD_CODING2 without errors

Check in SE38 run the program: RSR_BAD_CODING

IF i_last_aggr EQ rs_c_true AND

c_s_req_time-S____201

= i_s_valid- .

Syntax Error: The data object "I_S_VALID" does not have a component called "".

[former_member182152]

Hello Shiqing,

Do you have a infoset in your multiprovider on which query is designed?

In that case, SAP note # 796559 or SAP Note # 917820 may help.

Please check it.

Regards,

Sheik Bilal

[Former Member]

HI, Bilal

There's no infoset

I think it's related to the non-cumulative key figure in this cube

[Former Member]

Hello Bilal,

Did u find a solution to this error. we are also facing the same problem, but are unable to solve. kindly guide if u have found a solution