System administration tasks

On this page:

The first user who will sign up in Private eazyBI will get the System Administration access rights. If you want to add the system administration rights for existing users, then find the user in System Administration / All Users page, edit it and select System admin checkbox. If a user is a system administrator then on the top right corner there will be System Administration menu visible.

A system administrator can access all eazyBI accounts data as well as perform additional system administration tasks that are described below.

Settings

In the Settings page you can edit the database connection parameters and the Private eazyBI license.

All users

A system administrator can search all users, see accounts that they own or have access to as well can completely delete user. When deleting user then only user data are deleted, owned accounts still remain in system.

From all users list system administrator can click on user accounts to switch and see data in these accounts.

Pages

A system administrator can create additional static pages or local help pages.

After clicking the Create new page button you should enter page name. E.g. if you will create a page with a name example-page-name then you will be able to access it with URL /eazybi/pages/example-page-name (which should be prefixed with your host name to get full URL).

If you would like to create local help page then prefix page name with help/. E.g. a help page with a name help/example-help-page will have a URL /eazybi/help/example-help-page.

In the page body you can use Markdown formatting as well as HTML fragments. Click Preview button to see how your draft page body will be rendered.

System events

By default all failed eazyBI web requests are logged in system events as well as report and dashboard creation, update and delete events. Event name describes type of web request that failed. Here are most typical event names that can appear in system events:

create.calculated_member.eazybi
update.calculated_member.eazybi
These events appear when a user is creating or modifying calculated member formula and has entered invalid MDX formula syntax. Expand Payload details to see entered formula and error message. If you see that some user is regularly having problems with entering correct MDX formulas then you know that you should help them with additional training about calculated member formulas.
pivot_table.query.eazybi
select_set.query.eazybi
eazyBI failed to execute generated MDX query. Possible reasons are that query execution timeout has been exceeded or query is too complex for Mondrian OLAP engine or eazyBI generated MDX is not valid. Expand Payload details to see failed MDX statement as well as exception details.
connection.olap.eazybieazyBI failed to establish Mondrian OLAP engine connection. Most probably this error can happen if database connection settings are invalid.
process_action.action_controllerSome unexpected exception when processing web request. Take a look at Error and Payload details and provide details to eazyBI support if such error happens regularly.

Background jobs

There are several background job queues in eazyBI:

  • regular_import – for source application imports that are scheduled at a regular frequency.
  • application_import – for source application imports that are started manually.
  • file_import – for uploaded source file imports.
  • dashboard_email – sending emails for dashboard email subscriptions.

You can see the status of background job queues (as well as currently running background jobs) from the eazyBI System administration / Background jobs page.

By default, one parallel background job can be executed in each queue. If you would like to increase the size of the queue, then specify size setting for this queue in config/eazybi.toml file, for example:

[job_queue.application_import]
size = 2

If you would like to limit that no background jobs are executed during some hours then specify either disabled_hours or enabled_hours setting, for example:

[job_queue.application_import]
disabled_hours = "9-18"

or

[job_queue.application_import]
enabled_hours = "0-9,18-24"

In both cases, manual data imports will not be done from 9:00 to 18:00 (using the default eazyBI server time zone).

If you change disabled_hours or enabled_hours setting, then it will be checked each 10 minutes. If you change size setting then you need to restart Private eazyBI.