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
the sql generated is doing a INNER JOIN with a table that does not exist (i do not have any table in our cube with that name)
Only admins can run sql?query= if I am not mistaken. That jaql/sql endpoint is the only endpoint that translates jaql to sql. If it isnt usable, then I am afraid there is no way to translate a jaql to sql within Sisense itself. You would have to translate it somehow yourself unfortunately.
