Running Calculations in the Background for Views and Reports
  • 1 Minute to read
  • Dark
    Light
  • PDF

Running Calculations in the Background for Views and Reports

  • Dark
    Light
  • PDF

Article summary

Views and Reports can run a calculation when the user clicks Save. By default, when a calculation is run from a view or report, it runs in the background, which prevents users from continuing to work. However, Power users can set an application-wide setting to run calculations in the background for all views and reports that trigger calculations. Those calculations must have been created with the Run in Background field set to Yes. After the calculation has completed its processing, an email is automatically sent to the user that triggered it.

Our recommendation is to set this option to Yes.

  1. In SpotlightXL, navigate to Manage > Application Administration > Application Settings. Scroll down to the Calculation Property section. After making changes, click Save. Then log off and login again to see the effect of the changes.
     ModelingImagesManagecalcbackground11.png

  2. Select Model > Calculation to ensure that the calculation was set up with Run in Background set to Yes.
     ModelingImagesManagecalcbackground21.png

  3. You can see a list of all calculations and their current background setting by choosing Model > Setup. Select the model, then scroll down to the Calculations section.
     ModelingImagesManagecalcbackground31.png

  4. Verify that the calculation is set up to run when the user clicks Save from a view or report by reviewing the view or report properties.
     ModelingImagesManagecalcbackground4.png

     ModelingImagesManagecalcbackground5.png

  5. When the user clicks Save in the view or report, they see the following message:
     ModelingImagesManagecalcbackground61.png

    Note:

    The view or report does not refresh the data automatically after the user clicks Save.


Was this article helpful?