The Administration panel (shown below) and authorized access areas are visible to users with at least R rights for one of the following objects: ste_users, ste_conns, ste_logs, ste_licenses, ste_sessions, ste_settings, ste_perf, or audit.
Users, Groups, Roles
Here you can edit users, groups, and roles for each Jedox connection (i.e., the connection to an OLAP server running behind Jedox Web) for which you have access rights. You can create or delete users, groups, and roles or change their details if you have at least D rights on the objects involved in user management (user, group, password, and rights). Otherwise, you will get an error message when you select a connection from the drop-down list in the user management settings.
When assigning rights within roles, we distinguish between Splash (S), Full Control/Delete (D), Write (W), Read (R), and No Access (N). For a legal object, only those rights that can actually be granted appear in the list.
Here you can create or delete database connections and servers, or change their details.
To consider the assigned rights, the check mark for “Use login credentials” must be set. Otherwise, the rights of the user name entered for the connection would be considered.
A special case is the “internal” connection. This connection is defined in the configuration files of Jedox Web to the OLAP server with the metadata and the System database for the authentication of the users. This connection does not exist as an object in the Connection Manager, and it cannot be changed.
Users have access to the internal connection only if they belong to a role with full rights on all of the following objects: user, group, password, and rights.
Note: as of Jedox 4.0, users with no “visible” access to a particular connection cannot use that connection in workbook formulas. Previously, such connections might be used for back-end purposes, such as changing a password via a static connection with admin credentials. On all levels, users are only able to work with connections they have access to.
Here you will find log messages for the installed Jedox modules. They can be sorted in a variety of ways, such as by date, Log Type (Apache, Spreadsheet Server, OLAP Server, etc.), or by Log Level (Warning, Error, etc.). Selection changes are only displayed after clicking the Refresh button. The log messages can be exported as a CSV file. The old, renamed Tomcat messages (e.g. file.log.1) are not displayed.
As of Jedox 5.0, the log messages of the supervision server (SVS) are also displayed.
Here you can activate and manage your licenses. Click on the links below for more detailed descriptions about these topics:
- License activation in Jedox Web and Excel Add-in
- Assigning licenses, deleting assignments, and removing licenses in Jedox Web
- Automatic assignment of licenses
Here you will find the running sessions. Your own session is marked with an asterisk. Double-click on a user session to get the current OLAP jobs and the license used.
To stop a job, select the corresponding user session and then the desired job in the “Active jobs” tab. Click on the “Stop Job” button (indicated below) to cancel this job.
Here you will find various settings, such as the default storage path and data for sending emails. They can be changed with a double click.
For details on settings, see Overview of Jedox Web Settings.
Jedox Performance Monitor can log and display information for several key performance measures, including system hardware resources, number of logged-in users, etc.
You can find a more detailed description in the article Performance Monitor.
OLAP lets you store audit information for specific cubes. The audit information keeps track of all individual cell changes, such as the cell path, time of change, user, new value, operation (Splashing, Copy), etc.
You can find more details in the article Audit Information.