The Administration component (shown below) and authorized access areas are visible to users with at least R rights for one of the following objects:
Hovering over any object in the Administrator enables the card functionality of that object. You can then navigate to one of the options in the card functionality, or simply enter that object by clicking on the card.
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 add (1) or delete users (2), 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.
With the search button (3) you can start a search for any entry in the current table.
The user table has following columns: User name, Full name, Description, Last login, Creation time and User status (4). In each column header you can open a pulldown menu with commands to sort the column ascending / descending and with checkmarks to display / hide columns of the current table.
After the selection of one row (5) , the corresponding area for editing is shown (6) to perform actions on the selected object. By pressing the key Ctrl or Shift you can also select multiple rows to perform actions.
When assigning rights within roles, we distinguish between Splash (S), Full access (D), Writable (W), Read only (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 connections of any type that can be used as a reference in Jedox Integrator, with the exception of connection type ODBC, which is used only in Jedox Web Spreadsheets. Permissions can also be defined here.
Connections can be created, edited, and deleted. Connections created here can be used in Jedox Spreadsheets by referring to their name. In the case of OLAP connections, they can also be used in Integrator projects as Jedox Global connections.
Jedox connections require specification of the network interface and port where the OLAP server is accessible. By default, the localhost connection already exists and points to the OLAP server included in the installation. You can create additional connections to other OLAP instances in your environment.
Jedox connections also require a username and a password. However, it is possible (and usually recommended) to omit these fields in the following two scenarios:
- The connection points to the OLAP server that is included with the standard installation, and is configured to be used by Jedox Web for the storage of metadata and authentication of Jedox Web users. This is the case for the default localhost connection in standard installations.
- The connection points to a separate OLAP server that uses the same System database (and thus the same set of users) as the internal one.
The username and password fields can be omitted by setting the checkbox to Use Login Credentials in the Connection Settings dialog, as shown below:
Setting this option ensures that every time this connection is used, it will happen in the context of the Jedox user who is currently logged in, and that user’s access rights are applied. In the first scenario above (connection pointing to the internal server), no additional session will be created for such a connection, and thus no additional license seat will be used. Note: the interface entered for the connection must be exactly the same as the interface specified in the config.php file for the CFG_PALO_HOST key. By “interface”, we mean not only the same physical server, but the same “address” you are using, such as internal IP or internal/external DNS.
By contrast, you can choose to specify a username and password and not set the Use Login Credentials option. In this case, any instance of this connection will run in the specified user’s context, with that user’s access rights, and an additional session will be created in the OLAP server. The default connection localhost_static is configured in this way. Such a connection can be useful for Integrator projects that require a specific user or set of access rights.
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.
You have access to the internal connection only if you have a role with full rights on all of the following objects:
Note: If you have no “visible” access to a particular connection, you cannot use that connection in workbook formulas. Previously, such connections could be used for back-end purposes, such as changing a password via a static connection with admin credentials. On all levels, you are only able to work with connections they have access to.
Here you can find log messages for the installed Jedox modules. They can be sorted in a variety of ways:
- by Log Type (Apache, Spreadsheet Server, OLAP Server)
- by Log Level (Warning, Error)
Selection changes are only displayed after clicking the Refresh button. The log messages can be exported as a CSV file. The old ones, renamed Tomcat messages (e.g. file.log.1) are not displayed.
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 can find the running sessions. Your own session is marked with a star. 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 can modify various Jedox Web settings as well as add new and even custom settings for your Jedox installation. For details, 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. For details, see Performance Monitor.
The Jedox In-Memory DB can store audit information for specific cubes. The audit information keeps track of all individual cell changes, such as the cell path, time of change, users, new values, operations (splashing, copy), etc. For details, see Audit Information.