Forum Discussion

MikeGre's avatar
MikeGre
ETL
08-14-2025
Solved

Data Security Synchronization between Elasticubes

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" .

 

administration
Data Models
  • HamzaJ's avatar
    HamzaJ
    08-22-2025

    Hey MikeGre​ ,

    Great find. I took a look at it and...;

    1. 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.
    2. It doesnt seem it does a lot of validations. I only see it validates cubes exists or not
    3. Yes. It should work. Linux only btw

    Hamza

7 Replies

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    08-14-2025

    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

  • DRay's avatar
    DRay
    Sisense Employee
    09-17-2025

    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.

  • DRay's avatar
    DRay
    Sisense Employee
    08-20-2025

    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.

  • MikeGre's avatar
    MikeGre
    ETL
    08-20-2025

    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! :) 

    • HamzaJ's avatar
      HamzaJ
      Data Integration
      08-22-2025

      Hey MikeGre​ ,

      Great find. I took a look at it and...;

      1. 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.
      2. It doesnt seem it does a lot of validations. I only see it validates cubes exists or not
      3. Yes. It should work. Linux only btw

      Hamza