Forum Discussion

abhinavt's avatar
abhinavt
Cloud Apps
06-18-2024
Solved

Pass Dashboard Filter value to Data Model as a Parameter

Hi Team, I was wondering if there is way to pass one dashboard filter value ( report id ) to the SQL query in the Data Model. We have a scenario, when a user loads the dashboard one of the dashboar...
dashboards & reporting
Data Models
  • abhinavt's avatar
    abhinavt
    07-31-2024

    Hey David,

    We found a working solution for this, we were advised to convert all our dashboard filters to background filters. Later we made some changes to the code while embedding such that only the relevant selections from our embed platform are passed to each dashboard filter.

    Note :This cannot be done through the frontend dashboard unless we add dependent filters. However, it's great that we found a solution through embedding.

     

javiers's avatar
javiers
Data Storage
07-17-2024

Hi @abhinavt,

I'm not sure if I fully understood your use case but here are my 2 cents:

  • You can create dynamic query imports in your data model based on user parameters https://docs.sisense.com/main/SisenseLinux/importing-data-with-custom-queries.htm#DynamicImportQuery
  • You can update the user parameter value for a user with the Sisense API (/user-parameters endpoints)
  • So you can save the request_id per user as a parameter and update it via the API whenever you need it. If you configure the table in the datamodel to be filtered by the parameter,  every time it changes, the table  will be updated.

Wish it helps you!

abhinavt's avatar
abhinavt
Cloud Apps
07-22-2024

Hi Javiers,

We have discussed this workaround with the Sisense developer support team. Unfortunately this doesnt fit our use case as users can open multiple tabs with different request ids. But they have suggested a solution to convert filters to background filters and some JAQL changes while embedding. This helped to pass relevant filters for each but background filter.

Although we are working to make sure the background filters stay single select (for our use case) as by default bg filters are multi select  and will update once we found a permanent solution.