See the separate page on Testing Methodology for the different testing steps

1 - Unit Testing Status:

Entity-Level Testing:

PIData Object / EpicEntityTest Results

Q2

GBU

V_DIM_gbu


V_DIM_group_of_activity
V_DIM_activity1

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Exchange RateV_DIM_exchange_rate


Customer

V_DIM_customer_corporate_group
V_DIM_customer_segmentation
V_DIM_customer

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Testing results

Product/Material

V_DIM_material

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

Testing Results

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:

Testing output file:

Data ObjectAttributeTable in LakeAttribute in LakeRAGMatch RatioCommentsActions
GBUGBUV_DIM_gbuGBU_LakeOK100.00%> Transformation Required. Requires concatenation of fields
Product/MaterialMaterial_NameV_DIM_materialmaterial_nameDQ97.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


  • > Ram Atirajyam / Youness HSINA Fix Data Quality Issues with Registered Mark
    > Find the remaining products not containing registered mark
  • >BASTIDAS-ext, Pau / AzadehDefault logic implementation definition
  • > Default logic implementation implementation


Product/MaterialMaterial_CodeV_DIM_materialmaterial_idDQ99.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"
CustomerShip_To_NameV_DIM_customercustomer_medium_nameDQ98.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
CustomerShip_To_CodeV_DIM_customercustomer_idOK99.86%> 4 codes not found, 1 is set as NONE
CustomerSold_To_NameV_DIM_customercustomer_medium_nameDQ98.88%

> All except 1 have code
> At least some not matching due DQ Issues in the names
> Unmatched: WP1_400/NOT ASSIGNED

> No action - Attributed to DQ Issues

CustomerSold_To_CodeV_DIM_customercustomer_idOK99.86%> 2 codes not found, 1 is set as NONE
CustomerSold_To_GroupV_DIM_customercustomer_corporate_group_nameDQ97.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
GBUGroup_of_ActivityV_DIM_group_of_activityGroup of Activity LakeOK87.50%> Only unmatched value is "NOT ASSIGNED (#)"
> Transformation Required.

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
  • > Transformation requirement to be discussed
RegionCountry_Ship_ToV_DIM_countryCountry Ship To LakeOK98.86%> Only unmatched value is "NONE"
> Transformation Required.

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
  • > Transformation requirement to be discussed
RegionCountry_Sold_ToV_DIM_countryCountry Sold To LakeOK98.80%> Only unmatched value is "NONE"
> Transformation Required.

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
  • > Transformation requirement to be discussed
RegionGBU_RegionV_DIM_geo_zoneGBU Region LakeOK83.33%> Only unmatched value is "NONE"
> Transformation Required.

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
  • > Transformation requirement to be discussed
MarketsEnd_UseV_DIM_gbr_endusegbr_enduse_nameOK98.61%> Only unmatched value is "NONE"

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
RegionGBU_Zone_H1V_DIM_mini_zoneGBU Zone H1 LakeDQ50.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
MarketsMarketV_DIM_gbr_marketgbr_market_nameOK81.82%> 2 unmatched values "NOT ASSIGNED", "NONE"

BASTIDAS-ext, Pau / Azadeh

  • > Default logic implementation definition
  • > Default logic implementation implementation
CustomerGBU_Customer_SegmentV_DIM_customer_segmentationGBU Customer Segment LakeOK60.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
CustomerGroup_Customer_SegmentV_DIM_customer_segmentationGroup Customer Segment LakeOK60.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
Product/MaterialProduct_NameV_DIM_materialcommercial_material_group_nameDQ15.33%> 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/MaterialProduct_NameV_DIM_materialmaterial_nameDQ84.73%

> All except 1 have code
> At least some not matching due DQ Issues in the names

> 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 implementation implementation
Product/MaterialProduct_CodeV_DIM_materialcommercial_material_group_idOK99.94%> The only unmatched is a "NONE" value
> Transformation required to remove the zeros in front of the number
  • >GURRAM-ext, NaveenThe gap seems to be in what/where/how do get the names out of the codes
  • > Ram Atirajyam / Youness HSINA Transformation required to remove the zeros in front of the number
  • > Default logic implementation definition
  • > Default logic implementation implementation




  • No labels