I'm facing an SAC challenge.
I have a dimension of SKUs with various properties such as weight, use, dosage, market, and package.
Each SKU has an associated cost uploaded through ETL.
My objective is to validate the accuracy of the uploaded costs.
To achieve this, I plan to create a systematic flow that analyzes the reasonability of the costs.
The approach involves grouping SKUs with a specific number of common attributes and then applying a threshold to identify significant cost differences.
For instance, I will start by grouping SKUs with 7 common attributes and examine cost differentials.
Subsequently, I will repeat the process for SKUs with 6 common attributes, and so on.
Can you guide me on how to construct an effective flow for this cost validation process?