Recompiling views

[gdartigueeis]

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 commands, in this case this would allow to refresh data that would be selected by the jdbc connector.

[dougnewton]

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.