Set up Executive Dashboard

Owned by Pawandeep Singh (Deactivated)
Last updated: 21/02/2018
2 min read

Use this article to set up the Executive Dashboard



Step-by-step guide

  1. First check if the executive dashboard is active from application table using the below script
select * from application where code = 'Executive.Dashboard'

        If it's not active then use the below script to make it active

update application set active =1, licensed =1, displayorder = 11, updatedby = 1 where code = 'Executive.Dashboard'

With this you should be able to see Executive Dasboard app on logging into customer's environment

2. Setting up the related jobs. Following jobs are required to be set up to make this app to function -

i. Job 34 - Generate Dashboard Datawarehouse -

  • Set this Job to ACTIVE
  • Scheduled Type = Standard
  • Timeout minutes = 240
  • Run Every Minutes = 10


  • Job Parameter set up as below

 ii. Job 83 - Populates the FlightFollowPerformance table.

  • Set this job to ACTIVE
  • Scheduled Type = Standard
  • Timeout minutes = 20
  • Run Every Minutes =360

iii. Job 86 - Update FlightFollowPerformance table

  • Set this job to ACTIVE
  • Scheduled Type = Standard
  • Timeout minutes = 20
  • Run Every Minutes =360


3. Testing the SET UP Jobs -

Use the below scripts to test if the above jobs are executing successfully -

select * from dbo.jobqueue where jobid=34 order by runat desc -- 34 Generate Dashboard Job
select * from dbo.jobqueue where jobid=83 order by runat desc -- 83 Populates the flight followperformance table
select * from dbo.jobqueue where jobid=86 order by runat desc -- 86 Update FlightFollowPerformance table


Use the below scripts to test if data is being populated in FlightFollowPerformance table

Select top 100 * from dbo.FlightFollowPerformance


4. Setting up the Application setting and UPMT setting for otpService

Use the below scripts for the same:

For UPMT Setting - Replace the xx with customer code.

update dbo.userpreferencemastertemplate set value='https://xx.merlot.aero/services/OtpGraphicsService.svc' where preference='otpService'

For Application setting -

update dbo.applicationsetting SET VALUE='~/../Common/OtpService.svc' where name='otpService'


Once all the above steps are done, login to customer environment > Executive Dashboard and check if it populated the data like below - 
ExecDashboard.png