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...
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.