Expected something like an 'AS' keyword or '(' between the word abc and the word 'nologging'

Connectivity
New Member

Expected something like an 'AS' keyword or '(' between the word abc and the word 'nologging'

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

 

SQL Statements:

create table ZZMD00 nologging as
select Geo_name,
sum(sales) 
from Table_market

 

create table ZZMD01 nologging as
select Cust_name, Cust_add
from Table_customer

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

 

 

Cube errorCube error

  • microstrategy 10.1
  • mstr
  • Teradata
1 REPLY
Junior Contributor

Re: Expected something like an 'AS' keyword or '(' between the word abc and the word 'nologging'

Seems like MicroStrategy still submits Oracle SQL (nologging option).