Skip to content

Setup

Dashboard Setup

Clever Dashboard two key concepts - measures and dashboards.

Dashboard Setup Card

The data for dashboards is collected from OData web services which are hosted in your Business Central system. User credentials must be entered to retrieve this data.

The Base URL is populated when the setup card is opened. If you are using Clever Dashboard in an on-premise installation of Business Central you may need to overwrite this URL. Clever Dashboard must be able to call a service tier with OData services installed to retrieve data for dashboard measures.

Select a Username which appropriate permissions sets to read the dashboard data from the list of users. When doing this you will be prompted to create and copy a Web Service Access Key from the corresponding card.

This is a password which is used only for accessing web services as the selected user.

If dashboard measure data cannot be retrieved by the job queue (see below) then an email can be sent to the Error Logging Email specified here. The sender of that email should be specified in the Sender Email. The user credentials enters on the SMTP Mail Setup page must have permission to send as this email address.

The Job Queue tab displays the status of the job queue entry which will collect the data displayed on the dashboards.

The Job Queue Entry record can be created with the Create Job Queue action.

Dashboard Measures

Dashboard Measures provide a way to define the data that must be collected - the column(s) that you are interested in and any aggregate function (sum, count, average) that should be performed on the data.

See Dashboard Measures

Dashboards

Dashboards group up to six measures together to display. Link them to one or more user profiles in Business Central to have the dashboards display on the Role Center of users with that profile.

See Dashboards

Job Queue Setup

The Job Queue Entry can be created with the Create Job Queue action on the Dashboard Setup page. Alternatively a job may be created manually to run codeunit 9030859 (Schedule Measure Eval. CDSBTMN).

By default the job queue entry is set to run every 15 minutes every day of the week. These settings can be altered as appropriate.