Apply preset filters to an Embedded Dashboard using Sisense Js

We are embedding a Pivot Table dashboard using Sisense.js and the pivot table needs to be filtered specific to the user that's viewing the data. We did figure out how to filter the table using a jaql query, but that Jaql only seems to work with an iFrame and not a sisense.js embed.

satyamarigold

Posted 2 years ago·Last reply 1 year ago

6 comments

DRay

·1 year ago

Hi satyamarigold,

I know it's been a while, but I wanted to check and see if you were able to get this resolved. Can you let us know?

DRay

·2 years ago

Hi satyamarigold,

Thank you for reaching out. Are you passing a specific user to Sisense? If so, Sisense will apply data security to the results. If not, how are you managing the user?

satyamarigold

OP2 years ago

User authentication is on our platform (where we are embedding the dashboard) and is not linked to the Sisense user. So it would be customized by a filter on the column

DRay

·2 years ago

Hi satyamarigold,

Thank you for the follow-up. To confirm, you have a value that you are using JAQL to pass through the iframe to Sisense, but that isn't working with embed.js. Is that correct? If so, are you seeing any error messages in the browser logs?

satyamarigold

OP2 years ago

No if we use the iframe embed - the jaql works. But we want to use sisense.js instead which does not work for some reason.

DRay

·2 years ago

Gotcha. I recommend creating a support case to see why the sisense.js isn't working. They will be able to dig into this further.