Stored Subsets

(Fomerly Local Subsets)

Subset settings can be stored, or saved, for the current user or for all users. There are two options for storing subsets:

  • In the Subset editor, select all the settings you want for your subset and then click Save.


  • In the Subset editor, click the + icon under the Stored subsets section and enter the name for the subset. Then choose the settings you want and click Save.

Both options prompt you to give your stored subset a name and decide whether it is a Private or Global subset.

The following actions are available in Subset editor > Stored subsets:

Add a new subset - allows you to set up and add a new stored subset.

Delete subset - allows you to delete the selected subset.

Edit subset name - allows you to edit the name of the subset. You cannot change the subset group (Global or Private).

Set as default subset - allows you to set the selected subset as a default. This option only works on Global subsets. When opening Subset editor on new ComboBoxes, DynaRanges, etc, the dialog checks for the existence of flagged default subset and selects it if found.
Order of stored subsets - stored subsets can be ordered alphabetically ascending, descending or by creation.

You can insert both types of subsets from the Subset editor:

  1. Select a sufficiently large area in the spreadsheet for the subset.
  2. Open the Subset editor.
  3. Select the desired database.
  4. Select the dimension for which the subset is stored.
  5. Select the group Private subsets or Global subsets.
  6. Select the stored subset.
  7. Click Paste or Paste stored.

You can see the saved global subsets in the Paste view dialog in the respective dimension below the selection of elements. Private subsets are not displayed here. If you modify the definition of a stored subset on the server, all the reports using this formula get the new results.

You can also handle saved subsets in the Modeler.

  1. To add a subset, go to the Dimension Properties tab of any dimension and expand the Subsets section.
  2. Give your subset a name and a description.
  3. Click Ok. The Subset Editor is displayed, allowing you to configure the subset.
  4. Click Save and Close. The saved subset is now available on the list.

To remove a Subset from the list, click .

Note: when the Stored subset is selected from a ComboBox in the Modeler’s elements grid, element sorting is taken from the subset and users can override subset element sorting through the sorting options in the context menu. However, if the stored subset is created with an activated picklist filter with the option "As preselection in sort order" in Modeler, the element sorting from stored subset cannot be overridden with elements grid sorting.

Updated September 27, 2022