Data Security Synchronization between Elasticubes

Question

I was wondering if there is a possibility to synchronize the data security between elasticubes.

For example, I have Elasticube A & Elasticube B which use one field (the same) for data security.

Elasticube A is updated Monthly.

Elasticube B is updated Weekly.

The question is, if there is a functionality or a way to synchronize them. eg. If a change is done to Elasticube A, to synchronize the access rights of Elasticube B "automatically" .

Hamza Jap-Tjong · Accepted Answer

Hey MikeGre​ , Great find. I took a look at it and...; It works with custom code e.g. jupyter notebooks. This is implemented within the elasticube functionality. You can create a cube, select this notebook and it will ran with every cube refresh. Cube refreshes you can schedule. You could also implement this in the source cube and everytime it refreshes it will copy the DS to another cube. It doesnt seem it does a lot of validations. I only see it validates cubes exists or not Yes. It should wor...

DRay · Answer

Hi MikeGre​ , I’m following up to see if the solution offered by HamzaJ worked for you. If so, please click the 'Accept as Solution' button on their appropriate post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help. Thank you.

Michalis Gregoriou · Answer

Hey @ HamzaJ​ DRay​ ! I accidentally came across this old community post which I believe is what we need. Automatically Copy Data Security Rules Between Data Models (including Elasticube to Live and Live to Elasticube) | Sisense After carefully reading it, there are a few questions that remained unanswered: How to trigger this automatically? Additional Validation logic when creating RLS rules via API If it's working in latest Sisense Versions?

Michalis Gregoriou · Answer

Hey both!

Thank you for following up on my question!

HamzaJ thanks for the details! I was aware that "duplicating" an elasticube would keep the Data Security roles, something I was intending to do!

My main question was mainly focusing on-top of this step. For example, after re-importing an elasticube keeping the data security rules synchronized! I assume that a python script will do [?], but I was hoping something if there was an easier or a more simplistic feature to synchronize the Data security rules between 2 [or more] elasticubes!

Not sure if this question, or similar was raised, maybe it would be an idea for future development or if it's already on the roadmap.DRay could enlighten us! :)

DRay · Answer

Hello MikeGre​ , I’m following up to see if the answer from HamzaJ​ by worked for you. If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help. Thank you.

Hamza Jap-Tjong · Answer

Hey MikeGre​ , This is not possible. You could manually export the updated model and import it as the older model, e.g. export elasticube B and import it as elasticube A. However this does mean that the elasticubes are also the same in regards to tables and fields etc. Otherwise you could use a python script to pull the datasecurity from B and push it to A. Hamza