cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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.
Rate this article:
Version history
Last update:
‎03-02-2023 08:27 AM
Updated by:
Contributors