Forum Discussion

gabrielladawn's avatar
gabrielladawn
Data Storage
06-17-2025

How to Dynamically Switch Between Multiple Data Models in a Single Dashboard?

Hello

I am building a dashboard where different user groups need to view similar KPIs sourced from different ElastiCubes. For example; one group uses the Sales_US model & another uses Sales_EU. Rather than duplicating dashboards for each data model, I am exploring ways to dynamically switch between data sources within a single dashboard using a parameter or user/group attribute.🙂

Has anyone implemented a solution where the dashboard automatically pulls from the relevant data model based on user login, group / a dropdown selector? 😇 Ideally;  I would like to avoid duplicating widgets and dashboards, and instead create a flexible design that changes context based on the selected (or detected) model.🤔Checked https://docs.sisense.com/main/SisenseLinux/embedding-dashboards-and-widgets.htm related to this and found it quite informative.

If this isn’t natively supported, are there any creative workarounds using Sisense Blox, embedding API / script-based redirection/Generative AI Course ? 😇 I’m open to hybrid approaches as long as they maintain a good user experience.

 

 Thanks in advance!🙂

dashboards & reporting
Data Models

2 Replies

  • Benji_PaldiTeam's avatar
    Benji_PaldiTeam
    Data Pipeline
    06-18-2025

    Hi gabrielladawn​ ,

    Great question — this is a common challenge when managing multi-tenant or regionalized data access in Sisense.

    Sisense actually supports this use case via Dynamic Elasticube Switching (Dynamic EC), which allows dashboards to switch between data models at runtime based on user, group, or other parameters — without duplicating dashboards or widgets. This keeps your dashboard design centralized and scalable.

    You can learn more about this approach here:
    https://community.sisense.com/discussions/build_analytics/set-dashboard-data-sources-by-user/1343

    If you need help configuring this behavior, including managing data security and setting up dynamic switching logic, feel free to reach out. We’d be happy to guide you through best practices or plugin support if needed.

    [email protected]

    Paldi Solutions - Number #1 Sisense Plugins Developer 

  • Ido_QBeeQ's avatar
    Ido_QBeeQ
    ETL
    06-17-2025

    Hey gabrielladawn​ 

    I believe what you're looking for is the Dynamic Elasticubes plugin, free and pre installed on Linux,

    Have look at the link below

    https://www.sisense.com/marketplace/add-on/dynamic-elasticubes/

    If you need any assistance in setting it up or if we can further help in any way, please don't hesitate to reach out, we're always here to help.

    If you have any other questions don't hesitate to reach out,

    We're always here to help

     

    Ido from QBeeQ

    QBeeQ - Gold Sisense Partner

    [email protected]

    Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news