Jedox View Tab

When you open or edit a View, the contextual tab “Jedox View” will be displayed next to the Jedox Add-in ribbon. tab contains all features for managing View content, layout, and appearance.

Save View

Choose between saving the changes to this View (Save) or saving them as a separate View (Save as).

Undo

Use this option to reverse your last action. You can reverse more than one action.

Redo

Use this option to reverse your last undo action. You can only use the redo command if you have previously used the undo command.

Edit View

Allows you to edit the content of the inserted View on your current sheet. You can edit the elements within the selected dimensions of the POV, rows and columns, as well as add or remove the available dimensions.

Keep

Allows you to keep only the selected data elements of a dimension from rows or columns.

Remove

Allows you to remove the selected data elements of a dimension from rows or columns.

Suppress Zeros

Use this option to hide cells with null values.

Number Format

Enable or disable the displayed Views' number format from the Modeler directly in Excel and ensure the consistency wherever they are used (even in Microsoft Word). Note that the option always shows “Enable” if no number format is set for the displayed View in the Modeler.

Swap Axes

Allows you to exchange the entries in the row titles area with those in the column titles area.

Invert Hierarchies

Invert the order of the consolidated elements, i.e. display the parent element below its child elements.

Repeat Elements

Repeat elements if your View has nested dimensions.

Detach View

Detaching the View will display the PALO functions of the corresponding cells within the worksheet, allowing you to change the layout, format of the cells, positioning of parts of the View, and other aspects.

Rebuild View
Views' context-dependent capabilities, such as expanding / collapsing of rows and columns or multi-selection of header dimensions, do not work with detached Views. To use these features again, you must rebuild the View.

Jedox View Tab

Related videos