[CC] (Marlo-BI) Create ETLs to Regional Program intersect dimension

CCAFS / MARLO-BI

MARLO BI module is a set of Dashboards created to help users to analyze their information registered in MARLO.

GNU General Public License v3.0

0 stars 0 forks source link

[CC] (Marlo-BI) Create ETLs to Regional Program intersect dimension #14

Closed ccastiblancoCGIAR closed 3 years ago

ccastiblancoCGIAR commented 3 years ago

To create the ETLs for regional program intersect dimension to include Deliverables' reg programs' information

[x] Create queries related to deliverables regional programs and tested on prod environment
[x] Create ETLs related to regional programs intersect dimensions and deliverables' information
[x] Create and modify Jobs related to regional programs intersect dimension process
[x] Test ETLs on local environment.
[x] Copy ETLs on Doppler and testing the execution

Deliverable: ETLs and job created and modified Move to Review when: ETLs tested on local environment Move to Closed when: ETLs tested on Doppler .

ccastiblancoCGIAR commented 3 years ago

ETL for stg_pre_group_reg_programs, created

This ETL has two inputs, one for OICRs' regional programs and other for Deliverables' regional programs.

Regional programs came from the same source as flagships.

ccastiblancoCGIAR commented 3 years ago

ETL for stg_intersect_group_reg_programs created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

ETL for dim_intersect_group_reg_programs, created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

ETL for stg_br_group_reg_programs created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

ETL for br_group_reg_programs, created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

ETL for dim_regional_programs, created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

Pentaho Job: dim_intersect_reg_programs_process, created and tested in local environment

ccastiblancoCGIAR commented 3 years ago

Pentaho Job: 03_intersect_dimensions_process, modified to add the regional program process job. Tested in local environment.

ccastiblancoCGIAR commented 3 years ago

ETLs tranfered to Doppler and tested in production environment

ccastiblancoCGIAR commented 3 years ago

Pentaho Job: dim_regional_programs_process, created

Pentaho Job: 01_basic_dimensions_process modified to add dim_regional_programs_process: