Dynatables

Dynatables enable you to create and access In-Memory DB Views directly within Jedox Web, independent of Jedox Web Spreadsheets. Featuring an intuitive user interface (UI), Dynatables ensure that users across various roles can harness the full potential of Jedox's analytical capabilities. Whether you are a novice user exploring data or an experienced analyst crafting sophisticated reports, the ability to create and manipulate Dynatables empowers you to derive meaningful insights tailored to your specific needs.

The Dynatables UI is integrated into the top-level navigation of Jedox Web, alongside sections like Reports, Designer, and Modeler.

For convenience and accessibility, you can also open it using the keyboard shortcuts "Alt + T" on Windows or "Option + T" on macOS.

Creating new Dynatables

If you have the minimum access rights of "W" for the sub-set view, you can see a "Create Dynatables" button in the new Dynatables section.

By clicking this button, you will be able to select a database and cube, and see the dimensions that are part of the selected cube inside the Dynatables. You can then customize your Dynatables by dragging and dropping the dimensions into the different sections of your Dynatables.

Notes:

  • Lists and Virtual Dimensions are currently not displayed in the Source or POV section while creating a Dynatable.

  • When you open the Cube dropdown in the Source section, any cubes containing empty dimensions will be hidden, making them unavailable for selection.

Opening existing Dynatables

When you click on the Dynatables in the navigation bar, you will see a complete list of all the stored Dynatables. You can sort the Dynatables list in ascending or descending order based on the Name, Database, Cube, and Modified (default sort: descending) columns. You can open the Dynatable you wish to explore by clicking on it.

Keep in mind that Dynatables containing Lists or Virtual Dimensions may currently experience issues or disruptions. When hovering your mouse over these Dynatables, you will encounter a message preventing you from opening them. Access to these Dynatables will be made available in future releases.

Modifying Dynatables

To alter the presentation of your report, you can use "Pivot." You can drag and drop one or more dimensions into your Dynatable sections or interchange the dimensions displayed in the Point of View (POV), Rows, and Columns. You can also drag and drop dimensions from the Point of View (POV), Rows, and Columns sections to the Source area.

You can search for and select elements and aliases in the row and column dimensions. The selected elements are visualized as tags within the Pivot interface. You can expand or collapse the inner elements within any dimension in Rows and Columns, or perform Cross Drill Down on them.Additionally, you can choose an "Alias format" to customize how aliases are displayed.

Element selection in POV dimensions in Source

You can select a single or multiple elements for the Point of View (POV) dimensions in Pivot. When doing so, a "Select Element" window will appear on the screen. In this window, you can easily choose your desired elements by clicking on the respective row and column dimensions.

Stored Subsets as a source

You can also use a stored subset as a source for a dimension, allowing you to easily apply a simple or complex combination of elements. This feature enables you to utilize intricate combinations based on Data, Attribute, and Picklist filters, giving you quick access to predefined element groups with just a few clicks and eliminating the need to rebuild extensive filters from scratch.

This process can also be executed at a more granular level, allowing you to select specific elements for the dimension that sources its elements from a stored subset. By narrowing down your selection, you can tailor the data to display only the most relevant or critical elements for your analysis.

Please note that Subsets are currently not available in the Canvas context.

Zero suppression

Zero Suppression in Jedox is a feature that enhances data visualization and reporting by hiding rows, columns, or data points with zero values. This functionality helps improve readability and focus by displaying only relevant, non-zero data, eliminating unnecessary clutter in your charts, tables, or reports. By using Zero Suppression, you can create cleaner and more efficient reports that highlight meaningful insights.

You can enable Zero suppression through the button on the main Dynatables UI.

Unfreezing header and rows

By default, the column and row headers are frozen, ensuring they remain visible at all times as the user navigates through the Dynatable. The fixed headers provide a consistent reference point, enhancing the overall usability and efficiency of the Dynatable. To unfreeze the header and rows, simply right-click on them and select "Unfreeze column header."

Saving Dynatables

After customizing a Dynatable to suit your preferences, you can save it for future use. When saving, a confirmation prompt will appear to ensure your action is intentional. Additionally, if you need a similar Dynatable with minor adjustments, you can use the "Save As" feature to create a duplicate and save it under a unique name or ID.

Note that Dynatables can be saved according to the user's Role Rights, which are categorized as follows: D (Full Rights), granting the ability to create both Global and Private Dynatables; W (Write), enabling the saving of Private Dynatables; R (Read), allowing users to only view Dynatables; and N (None), providing no access to the Dynatables.

Deleting Dynatables

You can delete a Dynatable using one of the following methods:

  • Using the "Delete" Key:

    • To delete a single Dynatable, select it and press the Delete key.

    • To delete multiple Dynatables, open the Dynatable menu, select the desired Dynatables using CTRL + Click or SHIFT + Click, and press the Delete key.

  • Right-Click Menu: Right-click on the Dynatable you want to delete and select Delete from the context menu.

  • Options Menu: Click the Dynatable's Options menu (three vertical dots) and choose Delete from the list.

User rights for deleting Dynatables

Note that deletion privileges depend on user permissions: users with "W" rights can delete private Dynatables, while those with "D" rights can delete both private and global Dynatables. If a user lacks the required permissions, an error message will display: "Insufficient rights to delete the Dynatable." Deleted Dynatables will also be removed from the Modeler.

Dynatable in Canvas

You can also use Dynatables within Canvas to create visually appealing and user-friendly reports that enhance data presentation and accessibility. For detailed guidance on how to get started, see the Adding Native Components to Canvas article.

Updated December 13, 2024