There are cases where the Sisense queries have to read from views. Would you consider allowing to issue queries like “ALTER database.materializedView REBUILD” instead of only allowing select comman...
Recompiling views
dougnewton
12-22-2023ETL
Or a variation of this -- put your materialized-view recompilation statement in a stored procedure.
Then allow Sisense to call stored procedure(s), for any of the connections defined in the cube, at the beginning of the build.