For example, we have a dimension called Product that has a SKU number. I want to add a Product Name dimension and Product Type dimension to each entry in the exiting Product dimension, so we'd be able to filter the metrics on either of the three dimensions ( Product Name, Product Type, Product).
Assuming your product name is a s.prop you can create a sub category break down. Then use SAINT to upload any desired secondary dimensions and pull reports on them. Check classification Hierarchy in admin.