Jedox Reports


Reports in Jedox Web are based on spreadsheets which are created, modified, and saved in the Designer. For end users (who are supposed to use Reports for analyzing data, or enter planning figures), these spreadsheets are then published in the Reports component.

The Reports component has the following advantages:

  • Database reports with DynaRanges are displayed in an activated state, meaning that the DynaRanges expand to show a row (or column) for each line of the DynaRange’s subset result. If the dimension used as source for a DynaRange subset changes (for example, if new elements are added), the Report will automatically reflect this change.
  • You can work with variables in Jedox Database Reports, for example by mapping variables and thus dynamically creating different instances of Reports.
  • End users can enter data in unlocked cells, change Combobox selections, and interact with the report in other ways, but they cannot change the underlying design of the report.

The actions that are available to a user in the Reports component depend on the rights given in the access rights object “ste_reports”. For more information, see Rights Objects in Jedox.

Reports can be displayed in two states. For administrators and application designers, they can be shown in Designer Mode, allowing you to change the report hierarchies, create new hierarchies, etc. Also, you can create a hyperlink to specific reports and use them in external applications, such as web pages or web portals; they can be created in reports properties.

For end users, Reports can be shown in User Mode, allowing them only to view the report hierarchies and open reports.

The mode shown to a user is controlled via the access rights object “ste_reports” defined for that user’s role in scope Administration (i.e., in the OLAP server’s system database).

The Reports component starts with the report group “Models,” which doesn’t have any reports after a new installation:

After changing to “Demo Reports”, the tile-based view control allows you to see and open reports as well as navigate to folders. All items are displayed in a hierarchical structure and ordered alphabetically. To open a report, click on the folder icon.


Adding a Thumbnail to a Report

For each report in Designer you can upload your own icon by using the context menu (right click – Properties – Thumbnail – Upload Thumbnail). Only PNG files up to 400×300 pixels are allowed.

You can also find the standard symbols used on the individual file types <Jedox>\httpd\app\docroot\ui\common\res\img\def\cf\covers.

Just as in Designer, you can also create new Report Groups in Reports (equivalent to a database rgrp* in Jedox) and create new report hierarchies (equivalent to dimensions in rgrp*):
You can create a new folder with the folder icon or from the context menu:

You still need to create reports in Designer, which you can then drag as a so-called nodal point into a folder or report hierarchy. To see how to do this, check Example: Report with a ComboBox and DynaRanges.