Deployment

Databases

The paie database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

Marts

The following marts must be enabled for the dashboard to work. Please refer to the enabling a mart section for more information about how to enable a mart.

• human_resources

dbt project specification

Update your cssXX.dashboards_store/dbt_project.yml file with the following snippet.

# cssXX.dashboards_store/dbt_project.yml
models:
  core_dashboards_store:
    marts:
      human_resources:
        +enabled: True
    dashboards:
      human_resources:
        emp_actif:
          +enabled: True #  Enable the models from the core repo
      interfaces: # Enable the paie interface
        paie:
          +enabled: True

configuration

Configuring the nbrs_sem_dern_paie

The nbrs_sem_dern_paie variable is used as a recency parameter. It's used to filter out employees whose last pay happened too long ago. It is set to 2 by default.

The variable can be overridden by setting the nbrs_sem_dern_paie variable in the dbt_project.yml file, in the vars section and under the emp_actif key. Please consult core.dashboards_store/dbt_project.yml to find the default value and see an example of this variable's specification.

# cssXX.dashboards_store/dbt_project.yml
vars:
  emp_actif:
    nbrs_sem_dern_paie: 1

A double yolk egg : using the Report builder: empl_actif.rdl

An SSRS report is available to export the list of active employees of the school board. The emp_actif.rdl can be found in core.dashboards_store/reporting/emp_actif/emp_actif.rdl.