Forum Discussion

rbortoluzzi's avatar
rbortoluzzi
Data Storage
11-13-2023
Solved

Shared Formulas

Good morning,

 
I'm starting to use Shared Formulas on Sisense and I would like to know how we do the release of them for another environment.
 
This is my situation:
 
1. I have a dashboard in DEV, where I created the shared formulas and used them in some widgets
2. The dashboard was exported from DEV and imported on PROD, but I had to manually recreate all the shared formulas and also edit widget by widget to change the formula, because the formulaRef changed.
 
Is there a way to deploy from DEV to Prod the shared formulas?
 
Thanks a lot,
 
  • Liliia_DevX's avatar
    Liliia_DevX
    11-13-2023

    Hi,

    If you have the same model on the DEV and production servers, please try to export the .smodel from the DEV server including formulas and then import this model to the production server.

    Export:

    Import:

    After that please build the imported ElastiCube and the shared formulas should appear in the list.

    Please check if this flow allows you to import/export the shared formulas along with the datamodel.

    Best Regards, Lily

3 Replies

Replies have been turned off for this discussion
  • Liliia_DevX's avatar
    Liliia_DevX
    Sisense Employee
    11-13-2023

    Hi,

    If you have the same model on the DEV and production servers, please try to export the .smodel from the DEV server including formulas and then import this model to the production server.

    Export:

    Import:

    After that please build the imported ElastiCube and the shared formulas should appear in the list.

    Please check if this flow allows you to import/export the shared formulas along with the datamodel.

    Best Regards, Lily

    • rbortoluzzi's avatar
      rbortoluzzi
      Data Storage
      11-13-2023

      Hi Lili,

       

      I forgot to mention that the models are not the exactly the same in Dev x Prod. So I can't import and export as you suggested.

      Do you have another approach to that?

       

      Bests,

      Renan Bortoluzzi

      • Liliia_DevX's avatar
        Liliia_DevX
        Sisense Employee
        11-14-2023

        Hi Renan,

        Thanks for the additional details! Since shared formulas are tied to a model, they could only be transferred along with it for now. However, your request would be a great fit for the Product Feedback Forum. The Product Feedback Forum is THE place where Sisense users can help shape the future of Sisense products by offering feedback. In the Product Feedback Forum, feel free to:
        • Submit and share original ideas
        • View ideas submitted by other Community members
        • Comment and kudo on ideas that impact you

        Please check out our video tutorial below on how to get started with your first submission: https://vimeo.com/sisense/819225960?share=copy

        Best Regards, Lily