Once you logged in to a Jedox account, the first screen you will reach is the reports section, which lets you navigate, filter and open Jedox Web reports created and published to the Report Manager in Jedox Web.
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.
By tapping on one of the reports, the report opens in a new screen:
Please note that reports get automatically resized to your device resolution. With a pinch-zoom gesture (moving two fingers away from each other or closer to each other on the screen) the size of the report can be adjusted to the zoom level that meets your requirements:
All the controls available inside the report are available in Jedox Mobile just the way you are used to in Jedox Web. But most of the controls have a responsive alternative to make them easier usable on a mobile device (e.g. drop-down menus or the planning assistant).
On the top of the report screen you can close the report and go back to the navigation screen again by tapping on the back button on the left side. On the right side, there’s a share button to share a snapshot of the report via the usual channels provided by your operating system.
By selecting “Ad-hoc Reports” in the navigation bar you will get to the Ad-hoc report section of the app. Here you can see previously created Ad-hoc reports or create new ones.
By tapping on the Add-button on the top-right corner, you can create a new Ad-hoc report. If there are no Ad-hoc reports yet, there is also a button in the information screen “Add Ad-hoc report” at the bottom.
You will be directed to the following screen after pressing one of those two buttons:
You have to enter the following information in order to create a new Ad-Hoc report:
- Title: a unique name for your new Ad-Hoc report (make sure that this name is not already used by another Ad-Hoc report).
- Database: the Jedox database that is used to fetch the information from.
- Cube: the Jedox cube with the dimensions you want to use in your Ad-Hoc report
- Column: the axis dimension on the horizontal side
Row: the axis dimension on the vertical side
Zero-suppression: if this option is enabled, the Ad-Hoc report displays only dimension elements which contain non-zero values.
After tapping on “Done” on the upper-right corner, you will be automatically taken to the newly created Ad-Hoc report. The first view that opens is the Grid view. You can also choose the following graphical representations of your data with the buttons on the bottom of the screen:
- Bar chart:
- Line chart:
- Pie chart:
- Map chart:
To use the map chart, please select a dimension containing country names as elements as the row dimension and put a SQLite database file in the installation folder of the Jedox Suite that contains a table called „geo_countrys“ with the following columns:
name: country name as used in the according Jedox OLAP dimension
longitude: longitude of the country
latitude: latitude of the country
Also please set the following two keys in Jedox Web – Administration – Settings:
Value: path to the SQLite database file relative to the Jedox Suite’s installation directory root (Linux) / absolute path (Windows)
In the top-right corner of the Ad-Hoc report’s screen there are five different buttons to change settings for your current Ad-Hoc report:
- 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 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.