Once you are in the Reports screen, you can navigate, filter, and open Jedox Web reports created and published to the Report Manager. By default, the app will display reports published to the report group marked as default.
See Jedox Web documentation for more information on creating and publishing reports.
See Tags in Jedox Mobile for more information about additional tags available in Jedox Mobile.
Note to iOS mobile app:
The fonts Arial, Comic Sans MS, Courier New, Garamond, Georgia, Lucida Console, Lucida Sans, Palatino Linotype, Times New Roman, Trebuchet MS, and Verdana are supported .
The fonts Arial Black, Calibri, Segoe UI, and Tahoma are not supported and will be displayed with the font Arial.
Once the report is opened, you can use the Back button to close the report and navigate back to the Report screen. You can use the Share icon in the top left corner to share/display a report via native share control, e.g. send a current snapshot as a PDF attachment via email.
In the Ad-Hoc Reports area. you have the option to open, modify, organize, and create new ad-hoc reports. These reports are dynamic reports managed by the app. You can use the buttons at the bottom of the screen to switch between layouts:
Below are descriptions of the layout options:
- Power grid (spreadsheet-like layout):
- Bar chart:
- Line chart:
- Pie chart:
- Map (possible if the data source contains latitude and longitude attributes):
When in Power Grid layout, you can use the toolbar on the upper right side of the screen. The icons are described below.
- Toggle data bars: toggles display of data bars in cells of the power grid.
- Swap: swaps dimensions on column and row axes.
- Filter: applies filter criteria to point-of-view dimensions.
- Edit: edits the layout of the view, such as which dimension will be displayed.
- Share: uses standard share functionality on the device to open the current layout in third-party applications, e.g. opening the current data grid as a PDF attachment in the mail client on the device.
The same controls (except for Toggle data bars) work in other layouts.
Creating a new report from the Ad-Hoc Reports screen
To create a new ad-hoc report, click on the plus symbol (+) from the top right corner of the Ad-Hoc Report screen (bottom left on Android devices). This will open a Create/Edit view dialog:
By default, this dialog will preset:
- Name of the report to New Report
- Database to the first database for current connection
- Cube to the first cube from the selected database
- Column to the first dimension in the selected cube. Dimension corresponds to the dimension whose elements will be shown in the columns.
- Row to the second dimension in cube. Dimension corresponds to the dimension whose elements will be shown in rows.
- Filter will not be set but can be used to preselect point of view, i.e. header elements. Aliases, i.e. alternative labels used for display, are supported as of Version 6.0.
- Zero suppression, when turned on, will filter out elements that don’t contain data/0 values. Dimensions containing attributes for latitude and longitude will be automatically marked for use within the GEO widget. It is also possible to automatically create these two attributes based on geographical data.
Clicking on “Done” will create and open new Ad-Hoc Report.
Creating a duplicate Ad-Hoc Report
It is possible to create a new Ad-Hoc Report as duplicate of an existing Ad-Hoc Report by tapping on the top right corner on the report tile you want to duplicate. This action will open a pop-up menu. Select Create copy to create a copy of the existing report with the same settings and open it. A number will be added as a suffix to the name of the newly created report; for example, if the original report was called “My Report”, the newly created report will be called “My Report 1”.
From the same menu, you have also the option to edit or delete the report:
Creating a new Ad-Hoc Report from Reports screen
If a Jedox Web report contains information about the database and cube used, i.e. exposed in-session variables jdx_database and jdx_cube (see Jedox Web documentation for more information on session variables) then an additional button will be visible in the top right corner of the screen. Tap on that button to open the Ad-Hoc Report definition dialog:
The Documents screen shows all documents that are stored within Jedox Web and available for the current user. These documents can include third-party content not managed directly by Jedox, e.g. PDF, PowerPoint files, images, videos, as well as folders, etc.
If you try to open a document for which there is a native app on the device to handle this file format, Jedox Mobile will offer to open the document in this app automatically, e.g. in Excel, PowerPoint, or Acrobat Reader.