Hey there,
Basically, you need to make database optimization in order to have the query executed fast so Sisense would be able to serve it in a fast matter. You can achieve this by limiting the amount of the data in the table, using a table instead of the view, or choosing the correct amount of the columns in the pivot table. Please let me know if you need additional assistance on this.
Sincerely,
Oleksii
