KB485664: How to solve executing SQL fail when parameterized queries on in MicroStrategy 2021 Update 7

Symptom

Example hit error SQL with parameterized queries on: 

create view T9WM4D752MD000 ("QUARTER_ID", "CATEGORY_ID", "WJXBFS1") as select "a12"."QUARTER_ID" "QUARTER_ID", "a14"."CATEGORY_ID" "CATEGORY_ID", sum("a11"."TOT_COST") "WJXBFS1" from "ITEM_MNTH_SLS" "a11","LU_MONTH" "a12", "LU_ITEM" "a13", "LU_SUBCATEG" "a14" where "a11"."MONTH_ID" = "a12"."MONTH_ID" and "a11"."ITEM_ID" = "a13"."ITEM_ID" and "a13"."SUBCAT_ID" = "a14"."SUBCAT_ID" and "a14"."SUBCAT_DESC" in (?, ?, ?) group by "a12"."QUARTER_ID", "a14"."CATEGORY_ID" with parameters: TV's Sports & Health Soul / R&B 

 

Action

If you hit error when executing SQL, please follow up https://community.Strategy.com/s/article/KB5544-What-is-a-parameterized-query-in-Strategy-Query?language=en_US  to turn off parameterized queries