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_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 parameters. It's used to filter out employeed for which the last pay occuperd for too long time. It is set to 2 by default.

The variable can be overriden 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 consults core.dashboards_store/dbt_project.yml to find the default value and see an example of the specification of this variable.

# cssxx_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 schoolboard. The emp_actif.rdl can be found in a core.dashboards_store/reporting/emp_actif/emp_actif.rdl