Thanks for the quick response David, it seems to me that perspectives is more about defining a subset of tables from within the same database. Doesn't seem like I can have individual perspectives point to different dbs but maybe I've overlooked something.
Ideally, we could have Elasticube_Base, Elasticube A (points to db A), Elasticube B (points to db B)... And then an update to Elasticube_Base could be applied to all Elasticubes.
Hey mckenziedubois ,
I do not have real experience with your use case. I do think there is a solution that can make this possible, if you are not afraid of getting your hands dirty with programming. Sisense supports creating/updating datamodels via API (https://sisense.dev/guides/restApi/datamodels.v2.html).
You could create a template datamodel which has some dynamic variables (like connector configuration), which you can then fill in on the fly while posting it to Sisense. It might take some time in setting up, but I think in the end you could easily push new versions to all the cubes.
Hamza
Hi Hamza,
During my research today I think I came to the same conclusion that the API is the way to go. Doesn't look like Sisense has any out of the box solutions.
Thanks,
