How to implement a MS SQL Stored Procedure with a Cross Apply

[intapiuser]

Sisense does not currently support the Cross Apply operator but below shows a viable alternative.

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 (see below) for a table to call the stored procedure. 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.