Saving Subsets


Subset settings can be saved (stored) 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, 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).

IN PREVIEW: 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 existence of flagged default subset and selects it if found.

*This option is only IN PREVIEW. To see the button available in UI, you must enable it. For more information on how to do it, see how to turn these options on and off.

You can insert both types of subsets can be inserted 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 saved global subsets in the Paste View dialog in the respective dimension below the selection of elements. Private subsets are not displayed here. This is implemented in Jedox Excel Add-in and in Jedox Web.

Removing a stored subset definition

To remove a stored subset definition, you must delete the value from the cube, like in the example below:

  1. In Jedox Web, go to Query > New View.
  2. The Paste View window opens. Click to see the attribute cubes.
  3. Select the #_#_DIMENSION_ cube and set the following view:

  4. Click Paste. The view is pasted on the spreadsheet, displaying a value in the DefaultSubset dimension for every stored subset:

  5. Select the value and delete it.
  6. Save the document.

* Formerly called Local Subsets.