Calculations in SpotlightXL Honor Group Access for ESMs

Calculations (accessed by navigating to Model > Calculation ) created in SpotlightXL honor Group Access defined for External Source Model (ESM) maps and formulas. ESM maps are used in Calculations to define the way data will populate in a Master model with data from an ESM. The Calculation itself executes the map when run. Formulas can be applied to manipulate data in the ESM to produce a specific output; for example the concatenation of two columns of data into one.

A Contributor user must have navigation access and Group Access to be able to select an ESM map or Formula from the Name list-box once either of these selections are made in a Calculation. Using the image below for example purposes, let’s say ESM Map is selected (highlighted in yellow) in the Type column. The next step is to select the map name in the Name column. Only the maps where the Contributor user has access to the Target Model selected in the Map will appear in the Name column for selection. If the Contributor user has access to no maps, none will appear in the Name column.