I am attempting to recreate a stored procedure in a Sisense EC. The stored procedure uses Cross Apply. How is this accomplished in Sisense?
Sisense does not currently support the Cross Apply operator, so the easiest way to implement this would be to import the data returned from a stored procedure directly into an ElastiCube table. You can do this by editing the manual query input for a table to call the stored procedue. Instead of the SELECT statement, you would put in a EXEC stored_proc statement.
The APPLY operator was introduced into SQL server to allow users to join a table to a table-valued function. Therefore, any translation of a Cross Apply operator will also require the translation of a table-valued function into Sisense syntax. There is no single solution to this, and will need to be addressed on a case-by-case basis.