When i preview my calculation view, am getting following error.
Generated Data Preview Query: SELECT TOP 5000 sum("RFID_MATCHED") AS "RFID_MATCHED", sum("RFID_SCANNED") AS "RFID_SCANNED", sum("RFID_SHIPPED") AS "RFID_SHIPPED", "SHIP_TO_PARTY1", "REGION", "PRODUCT", "COUNTRY", "PRODUCT_LINE", "PRODUCT_GROUP", "DELIVERY_DOCUMENT_NO", "SHIP_TO_PARTY", "LAST_RECORDED_DATE", "LAST_RECORDED_LOCATION", "DELIVERY_LOCATION", "STATUS" FROM "_SYS_BIC"."rfid-enabled-scvisibility/CA_DISCREPANCY_ANALYSIS" GROUP BY "SHIP_TO_PARTY1", "REGION", "PRODUCT", "COUNTRY", "PRODUCT_LINE", "PRODUCT_GROUP", "DELIVERY_DOCUMENT_NO", "SHIP_TO_PARTY", "LAST_RECORDED_DATE", "LAST_RECORDED_LOCATION", "DELIVERY_LOCATION", "STATUS"
Error Executing Query: SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;column store error: logical index creation error: [2052] attribute type is invalid at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_joinindex.cc:1131
And i came to know that it is due to "STATUS" field which i have added as,
CASE WHEN B."RFCNT"="RFID_SHIPPED" AND J."RFID_MATCHED" < B."RFCNT" THEN 'POTENTIAL_COUNTERFEIT' when
(B."RFCNT" < "RFID_SHIPPED") THEN 'LOSS' END AS "STATUS"
Here RFID_SHIPPED AND RFID_MATCHED are coming from innner query. If i remove this STATUS field then am getting output, only if i addthis STATUS field am getting error. Please help me in solving this.