cancel
Showing results for 
Search instead for 
Did you mean: 

Overwriting a Live model with .smodel file in order to share shared formulas

PaulN052
7 - Data Storage
7 - Data Storage

Hi all,

I have two live models that are exact copies of each other. I want to be able to share the shared formulas I created for one model on the other model. I was curious to find out if I am able to overwrite one live model with the .smodel file of the model where the shared formulas were created. Thank you.

1 ACCEPTED SOLUTION

AssafHanina
Sisense Team Member
Sisense Team Member

Hey Paul, 

in case you are working on Version L2023.1 and later, Sisense provide the ability to export Smodel include the Shared Formulas. 
In Version L2023.1 (Please find the release notes here), Sisense release the Option to Export data model with the Following assets: 

  • Data Security
  • Formulas 
  • Hierarchies

In order to Extract the Smodel with the shared formulas:

  1. Click Export 
  2. Include Formulas
  3. Export
  4. AssafHanina_0-1692029597866.png

in the second step:

  1. Import the SModel 
  2. Possible to Merge Formulas (In case there's existing Formulas)
  3. Possible to Overwrite the existing model (Make sure to Change the Database Credentials as needed)

AssafHanina_1-1692030007764.png

Best Regards

Assaf

Assaf

View solution in original post

1 REPLY 1

AssafHanina
Sisense Team Member
Sisense Team Member

Hey Paul, 

in case you are working on Version L2023.1 and later, Sisense provide the ability to export Smodel include the Shared Formulas. 
In Version L2023.1 (Please find the release notes here), Sisense release the Option to Export data model with the Following assets: 

  • Data Security
  • Formulas 
  • Hierarchies

In order to Extract the Smodel with the shared formulas:

  1. Click Export 
  2. Include Formulas
  3. Export
  4. AssafHanina_0-1692029597866.png

in the second step:

  1. Import the SModel 
  2. Possible to Merge Formulas (In case there's existing Formulas)
  3. Possible to Overwrite the existing model (Make sure to Change the Database Credentials as needed)

AssafHanina_1-1692030007764.png

Best Regards

Assaf

Assaf