0

I was working on Looker and I have to copy this Cognos query to Looker but apparently the SQL parameter on Looker did not work. I am not familiar with Cognos so I don't know how to solve this problem.enter image description here

I tried PARTITION function instead of FOR but still does not work. I expect it to run without errors

Nhật Phi Trần
  • 1
  • 1
    Please don’t link to images, add all relevant information directly to your question preferably as editable text – NickW Nov 27 '22 at 10:09

1 Answers1

0

A Cognos query will have both Cognos SQL and Native SQL. Native SQL is what goes down to the database, so that is probably what you want to grab.

Go to the query in question, using the properties pane, select generate SQL/MDX. Once the SQL is generated, grab the SQL from that window and try to send that to GBQ.

Daniel Wagemann
  • 741
  • 4
  • 6