Elasticube Custom Table Dashboard Dependencies

[Milan]

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.

[HamzaJ]

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]

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]

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

[Milan]

Thanks for the explanation @HamzaJ , we use Sisense Cloud, but the same should exist. We'll explore the Plug and Play solution you mentioned, before digging into MongoDB.

[Benji_PaldiTeam]

Hi @Milan ,

@HamzaJ this is definitely a great suggestion.

If you encounter this use case regularly and want to use a UI tool, I recommend taking a look at our "Field Analyzer," which we created just for this purpose.

Cheers,

Benji

[email protected] 

Paldi Solutions | Sisense Experts for Embedded Analytics Tools