How to model multi-level hierarchies in DV 2.0 ?

Data Vault 2.0
,
1

Hello DV Community,

I wish to understand what’s the best way, in your opinion, to model multi-level hierarchies (e.g. retail merchandise product hierarchies) according to the DV 2.0 standard.

Below is an expected data from source:

Screenshot 2024-04-23 at 3.29.02 PM
Screenshot 2024-04-23 at 3.29.02 PM2832×1320 421 KB

Please observe the line items highlighted in orange colour. Formal → Men → Shirts has been reclassified to Casual → Men → Shirts in 2024 vs 2023.

Merchandise[SubSubCategoryId] is foreign key in Product[CategoryId].

How do we model it in Raw vault all the way upto Dimension model in Information Mart layer so that we are able to do analysis over time period over this reclassification ?

Please guide.