Stored Views


In the screenshot below, the button Save as… allows you to store every view definition on the server as a global view (accessible to all users) or as a private view (accessible only to the current user).

Note: You cannot store views on attribute cubes.

After changes in a stored view the button Save… will be active to save just made changes:

The buttons in the highlighted section allow you to add a new view. You can also edit, duplicate or delete the currently active view. In Jedox Web, you can also flag/unflag a stored view as default. When you open the Paste View dialog, it checks for a default stored view and selects it, if found.

If you work with Excel Add-in, you can also use the following keyboard shortcuts:

Ctrl+N to add new view Ctrl+D to duplicate view Ctrl+S to save current view
F2 to edit view Del to delete view Ctrl+Shift+S to save as for current view

You can see all the global and private views of a selected cube in Modeler > Cube properties > Views. You can also flag/unflag a stored global view as default.

You can also access the Stored Views directly from the ribbon. This allows you to paste and edit them.

Jedox Web ribbon

Excel Ribbon

Any saved View will fallback to a default, such as a default read element, first root element or default subset, in scenarios such as:

  • An element used in the header or rows/columns was renamed or deleted.
  • An hierarchy was changed.
  • A stored subset in a View was renamed
  • A user with no Read rights to a certain element used in the View tries to open it.