See the separate page on Testing Methodology for the different testing steps
1 - Unit Testing Status:
Entity-Level Testing:
| PI | Data Object / Epic | Entity |
Completeness | Consistency | Uniqueness | Timeliness| Test Results |
Q2 | GBU | V_DIM_gbu | |
| V_DIM_group_of_activity |
|
| V_DIM_activity1 | | Jira |
|---|
| server | Jira |
|---|
| serverId | bbf5f9ee-7f3e-3274-bb6e-be12673f2166 |
|---|
| key | PC-364 |
|---|
|
|
| Exchange Rate | V_DIM_exchange_rate |
|
Customer | V_DIM_customer_corporate_group |
|
| V_DIM_customer_segmentation |
|
| V_DIM_customer | | Jira |
|---|
| server | Jira |
|---|
| serverId | bbf5f9ee-7f3e-3274-bb6e-be12673f2166 |
|---|
| key | PC-365 |
|---|
|
Testing results
| Google Drive Live Link |
|---|
| url | https://docs.google.com/spreadsheets/d/1kYUp8tGMsTAPCVzq9lJh0nHxqqNBA0mwCLwWMKbPuW8/edit#gid=1088090706 |
|---|
|
|
Product/Material | V_DIM_material | | Jira |
|---|
| server | Jira |
|---|
| serverId | bbf5f9ee-7f3e-3274-bb6e-be12673f2166 |
|---|
| key | PC-370 |
|---|
|
| Jira |
|---|
| server | Jira |
|---|
| serverId | bbf5f9ee-7f3e-3274-bb6e-be12673f2166 |
|---|
| key | PC-366 |
|---|
|
| Jira |
|---|
| server | Jira |
|---|
| serverId | bbf5f9ee-7f3e-3274-bb6e-be12673f2166 |
|---|
| key | PC-371 |
|---|
|
Testing Results
| Google Drive Live Link |
|---|
| url | https://docs.google.com/spreadsheets/d/1kYUp8tGMsTAPCVzq9lJh0nHxqqNBA0mwCLwWMKbPuW8/edit#gid=1840164139 |
|---|
|
|
| V_DIM_package_type |
|
| V_DIM_product_hierarchy |
|
| V_DIM_product_line |
|
| V_DIM_material_group |
|
| V_DIM_material_type |
|
Q3 | Markets | V_DIM_gbr_market |
|
| V_DIM_gbr_segment |
|
| V_DIM_gbr_application |
|
| V_DIM_gbr_enduse |
|
KDO-Level Distinct Values Testing:
Testing script:
| Google Drive Live Link |
|---|
| url | https://colab.research.google.com/drive/1g1pm42v4HPU6--H2q6XHns9ZlfdGrrQA |
|---|
|
Testing output file:
| Google Drive Live Link |
|---|
| url | https://docs.google.com/spreadsheets/d/17LgyJBG2dIlW0Fc7ovxFWUMVbTYOS7-fUOi4d8eOYMc/edit#gid=0 |
|---|
|
| Data Object | Attribute | Table in Lake | Attribute in Lake | RAG | Match Ratio | Comments | Actions |
| GBU | GBU | V_DIM_gbu | GBU_Lake | OK | 100.00% | > Transformation Required. Requires concatenation of fields | |
discussed- defined
- > Transformation implementation
|
| Product/Material | Material_Name | V_DIM_material | material_name | DQ | 97.26% | > 61 out the 62 Product Names have Product Code in the Sample
> When matching to the lake by Product Code, 61 are found with potential DQ Issues
> The one not found is 209081 / AUGEO® CRYSTAL DRUM 210 KG | |
Registered Mark- registered mark
- >BASTIDAS-ext, Pau / AzadehDefault logic implementation definition
- > Default logic implementation implementation
|
| Product/Material | Material_Code | V_DIM_material | material_id | DQ | 99.72% | >The Material_Names not matched contain vales that seem to be default values "OTHER INDUSTRIAL SERVICES", "NONE", "OTHER PASS THROUGH ADMINISTRATION","WATER", "ELECTRICITY", "GAZ NON RAW MATERIAL", "AUGEO® CRYSTAL DRUM 210 KG" | |
- > Default logic implementation
|
| Customer | Ship_To_Name | V_DIM_customer | customer_medium_name | DQ | 98.68% | > All except 1 of the unmatched have Ship_To_Code
> At least some not matching names due DQ Issues ("ACT CHEMICAL CO., LTD" Vs. "ACT CHEMICAL CO.. LTD")
> Unmatched: WP1_400/NOT ASSIGNED |
> NA |
| Customer | Ship_To_Code | V_DIM_customer | customer_id | OK | 99.86% | > 4 codes not found, 1 is set as NONE | |
|
| Customer | Sold_To_Name | V_DIM_customer | customer_medium_name | DQ | 98.88% | > All except 1 have code
> At least some not matching due DQ Issues in the names
> Unmatched: WP1_400/NOT ASSIGNED > |
NA No action - Attributed to DQ Issues | |
to be applied- implementation implementation
|
| Customer | Sold_To_Code | V_DIM_customer | customer_id | OK | 99.86% | > 2 codes not found, 1 is set as NONE | |
to be applied- implementation implementation
|
| Customer | Sold_To_Group | V_DIM_customer | customer_corporate_group_name | DQ | 97.78% | > All except 1 have code
> At least some not matching due DQ Issues in the names > Several customer ids can be found under the same Sold_To_Group, which is a rolled-up customer level. So it should not be retrieved from customer id. Additionally, the Sold To Group Id is not available in the transparency dashboard. |
- >BASTIDAS-ext, Pau / Azadeh to follow-up: Discussion needed to see if we need to take the ID from Salesforce, including Frank, Naveen, Ayoub...
|
- > Analysis is required to see if the dashboard has everything that is in CRM
|
| GBU | Group_of_Activity | V_DIM_group_of_activity | Group of Activity Lake | OK | 87.50% | > Only unmatched value is "NOT ASSIGNED (#)"
> Transformation Required. |
> Default Logic to be appliedBASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
| Region | Country_Ship_To | V_DIM_country | Country Ship To Lake | OK | 98.86% | > Only unmatched value is "NONE"
> Transformation Required. | |
> Default Logic to be applied- > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
| Region | Country_Sold_To | V_DIM_country | Country Sold To Lake | OK | 98.80% | > Only unmatched value is "NONE"
> Transformation Required. | |
> Default Logic to be applied- > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
| Region | GBU_Region | V_DIM_geo_zone | GBU Region Lake | OK | 83.33% | > Only unmatched value is "NONE"
> Transformation Required. | |
> Default Logic to be applied- > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
| Markets | End_Use | V_DIM_gbr_enduse | gbr_enduse_name | OK | 98.61% | > Only unmatched value is "NONE" | BASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default
|
Logic to be applied- logic implementation implementation
|
| Region | GBU_Zone_H1 | V_DIM_mini_zone | GBU Zone H1 Lake | DQ | 50.00% | > 3 unmatched values "CS/# (#)", "EUROPE (EU)", "NONE"
> Transformation Required. | BASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
> Europe > Default logic to be applied |
| Markets | Market | V_DIM_gbr_market | gbr_market_name | OK | 81.82% | > 2 unmatched values "NOT ASSIGNED", "NONE" | BASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default logic
|
to be applied- implementation implementation
|
| Customer | GBU_Customer_Segment | V_DIM_customer_segmentation | GBU Customer Segment Lake | OK | 60.00% | > 4 unmatched values "NOT ASSIGNED", "NONE", "NOT YET ASSIGNED", "NOT VALID"
> Transformation Required. | BASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
> Default logic to be applied |
| Customer | Group_Customer_Segment | V_DIM_customer_segmentation | Group Customer Segment Lake | OK | 60.00% | > 4 unmatched values "NOT ASSIGNED", "NONE", "NOT YET ASSIGNED", "NOT VALID"
> Transformation Required. | BASTIDAS-ext, Pau / Azadeh - > Default logic implementation definition
- > Default logic implementation implementation
- > Transformation requirement to be discussed
|
> Default logic to be applied |
| Product/Material | Product_Name | V_DIM_material | commercial_material_group_name | DQ | 15.33% |
NA | > Matching logic based on GBU needs to be applied (this is for Novecare)> Default logic to be applied | > Product Name should be matched to the Material Group Name, which is higher level of the material name. These two need to be separated | BASTIDAS-ext, Pau / Azadeh - > Potential gap of Material Group Name to be analysed
- > Default logic implementation definition
- > Default logic implementation implementation
|
| Product/Material | Product_Name | V_DIM_material | material_name | DQ | 84.73% | > All except 1 have code
> At least some not matching due DQ Issues in the names > |
Product Name should be matched to the Material Group Name, which is higher level of the material name. These two need to be separated> Pau to investigate Ayoub feedback is that this should not match to material name but Material Group Name but it does not | - > GURRAM-ext, Naveen Investigate if matching workings for Material Group Name --> Only one value matched (OFFICE SVCS), non of the others
|
- match.
- > Default logic implementation definition
- > Default logic
|
to be applied- implementation implementation
|
| Product/Material | Product_Code | V_DIM_material | commercial_material_group_id | OK | 99.94% | > The only unmatched is a "NONE" value
> Transformation required to remove the zeros in front of the number | |
to be applied- implementation definition
- > Default logic implementation implementation
|
