Description of Reports


Reports in Jedox Web are based on spreadsheets which are created, modified, and saved in the Report Designer. For end users (who are supposed to use Reports for analyzing data, or enter planning figures), these spreadsheets are then published to the “Reports” panel. The Reports panel 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 can not change the underlying design of the report.

The actions that are available to a user in the “Reports” panel 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, 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  such as the OLAP server’s system database.

When loading, the Reports start screen shows a tile-based view control. The tile view control allows you to see and open reports as well as navigate to folders. To open a report, click on the folder icon.


Adding a thumbnail to a report

For each report in Report 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 Reports Designer, you can also create new Report Groups in Reports (equivalent to a database rgrp* in Jedox) and you can 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 Report Designer, which you can then drag as a so-called nodal point into a folder or report hierarchy. This see how to do this, check Example: Report with a ComboBox and DynaRanges.