Knowledge Base Article

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

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.
Updated 03-02-2023
No CommentsBe the first to comment