How can I turn JAQL query into a SQL query?
currently we are using JAQL to query data that we use to create some reports.. but now we want to get the same data by using SQL so I looking for a way to convert our JAQL queries into an equivalent ...
Forum Discussion
It's the following api: POST /datasources/{cubeName}/jaql/sql
I tested that endpoint and actually it returned a SQL query based on my JAQL query but that sql query was generated with the table names modified.. I meat that the it added other letters to my table names...
and when I tried to execute those SQL queries on this api : /api/datasources/{cubeName}/sql?query=
it returns error:
in some sql queries return this error
"status": 401,
"httpMessage": "Unauthorized"
in other returns :
"error": true,
"details": "{\"error\":\"Query could not be compiled.\\nFound '.' but expected ')'.\\nFound '.' but expected '<Identifier>'.\\nFound '.' but expected ')'.\\nFound '.' but expected '<Identifier>'.\\nFound '.' but expected '<End of Expression>'.\"}",
"type": "500",
do you know if do i need to take into account something that i did not be aware
