I am facing this issue (Expected something like an 'AS' keyword or '(' between the word abc and the word 'nologging') when my microstrategy cube query tries to create multiple passes. Query with only one pass works fine. Please refer the exact error screenshot.
We are using Microstrategy 10.1 for frontend and Teradata 14 for backend database. We have migrated the project from MSTR 9.4 to MSTR 10.1 also we have migrated our backend database from Oracle to Teradata 14.
Here is the query-- please find simplified query as below
create table ZZMD00 nologging as
create table ZZMD01 nologging as
select Cust_name, Cust_add
select pa12.Cust_name , sum(pa11.Sales)
from ZZMD00 pa11
left outer join ZZMD01 pa12
on (pa11.cust_id = pa12_cust_id)
drop table ZZMD00 purge
drop table ZZMD01 purge
Seems like MicroStrategy still submits Oracle SQL (nologging option).