1 - Unit Testing Status:

Entity-Level Testing:

PI	Data Object / Epic	Entity	Test Results
Q2	GBU	V_DIM_gbu	Status: Test Evidence: Comments: Actions: Mukti Patel to drive the actions to fill this table
		V_DIM_group_of_activity
		V_DIM_activity1
	Exchange Rate	V_DIM_exchange_rate
	Customer	V_DIM_customer_corporate_group
		V_DIM_customer_segmentation
		V_DIM_customer
	Product/Material	V_DIM_material
		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 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	> Transformation requirement to be 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	> Fix Data Quality Issues with Registered Mark > Find the remaining products not containing registered mark > Default 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"	> Missing Product Codes to be found at the source > 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	> Default logic implementation definition > Default logic implementation implementation
Customer	Ship_To_Code	V_DIM_customer	customer_id	OK	99.86%	> 4 codes not found, 1 is set as NONE	> Ayoub to check the source of the codes to see where they coming from > Default logic implementation definition > Default logic implementation implementation
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 > No action - Attributed to DQ Issues	> Default logic implementation definition > Default logic implementation implementation
Customer	Sold_To_Code	V_DIM_customer	customer_id	OK	99.86%	> 2 codes not found, 1 is set as NONE	> Ayoub to check the source of the codes > Default logic implementation definition > Default logic 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.	> 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 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 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 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 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"	> Default logic implementation definition > Default 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.	> Default logic implementation definition > Default logic implementation implementation > Transformation requirement to be discussed > "Europe" is the one real gap, needs to be added. All the others are Not Assigned
Markets	Market	V_DIM_gbr_market	gbr_market_name	OK	81.82%	> 2 unmatched values "NOT ASSIGNED", "NONE"	> Default logic implementation definition > Default logic 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.	> Default logic implementation definition > Default logic implementation implementation > Transformation requirement to be discussed
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.	> Default logic implementation definition > Default logic implementation implementation > Transformation requirement to be discussed
Product/Material	Product_Name	V_DIM_material	commercial_material_group_name	DQ	15.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	> 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 > Ayoub feedback is that this should not match to material name but Material Group Name but it does not	> 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/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	> The gap seems to be in what/where/how do get the names out of the codes > Transformation required to remove the zeros in front of the number > Default logic implementation definition > Default logic implementation implementation

Space shortcuts

Page tree

1 - Unit Testing Status:

Entity-Level Testing:

KDO-Level Distinct Values Testing:

Space shortcuts

Page tree

Detailed Testing Status

1 - Unit Testing Status:

Entity-Level Testing:

KDO-Level Distinct Values Testing: