Using calculation mappings

General¶

Calculation Mappings are very useful for performing various calculations based on integer or float numbers associated with particular dimension values for successive calculations (for example, displaying financial metrics in several different currencies for each value of a particular dimension). You can create several mappings for any dimension in your project. Mapping names are unique across each project.

Creating a Calculation Mapping¶

To create a Calculation Mapping:

Use the the save_calc_mappings u-Slicer API method.

Adding an Existing Calculation Mapping to u-Slicer UI¶

To add an existing Calculation Mapping to u-Slicer UI:

Open your slicer.
Select the desired dimension.
Create a Custom Data Column with the following formula: map(name).

Viewing the List of Available Calculation Mappings¶

To view the list of available Calculation Mappings:

use the list_calc_mappings u-Slicer API method.

Deleting an Existing Calculation Mapping¶

To delete an existing calculation Mapping:

Use the delete_calc_mappings u-Slicer API method.