Forum Discussion

Milan's avatar
Milan
Cloud Apps
10-17-2022

Elasticube Custom Table Dashboard Dependencies

Similarly to viewing dashboards dependents on an elasticube, is there a way to view dependencies of tables (custom or otherwise)?

 

The use case is removing tables that have been created but are no longer needed. There is no quick way identifying if a dashboard is using a given table, with out going through all dashboards and identifying the tables by looking at every single widget.

Dashboards & Reporting

5 Replies

Replies have been turned off for this discussion
  • HamzaJ's avatar
    HamzaJ
    Data Integration
    10-18-2022

    Hi Milan ,

    You could create a datamodel and import data from Sisense's Application-DB (mongoDB). You can then import dashboard and widget data including which tables/columns are used as filters or in widgets. 

    • Milan's avatar
      Milan
      Cloud Apps
      11-09-2022

      Hi HamzaJ ,

      Thank you for this suggestion, I'm not too familiar with Sisense's Application-DB. Is this something that you have attempted? If so, could you outline some steps to produce this?

       

      • HamzaJ's avatar
        HamzaJ
        Data Integration
        11-09-2022

        Hello Milan ,

        It depends if you are on Linux or Windows. On windows I think you can do localhost:27017. On linux its sisense-mongodb:27017 . On Linux it could perhaps have a different name. It depends on how it is installed. You could do kubectl -n sisense get pods which should reveal how your mongodb is named.

        Collection is PrismWebDB

        After that you should be able to select the tables from Sisense'Application DB. It will take sometime figuring out what is where, but it should be doable. An alternative could be Benji's Field Analyzer which is more plug and play

         

        Hamza