Urgent : Attribut relashionship

[MIB]

Hi,

My dimension ‘Product’ is based on a surrogate key. I have also 9 others
attributs:
• Product Code, Product Short Label, Product Long Label (same KeyColumns but
different NameColumn)
• SubCategory Code, SubCategory Short Label, SubCategory Long Label (same
KeyColumns but different NameColumn)
• Category Code, Category Short Label, Category Long Label (same KeyColumns
but different NameColumn)

And my hierarchy is based on short label for category and subcategory, and
the Product Code for the lowest level: Category Short Labet --> Subcategory
Short Label --> Product Code

My question is how to link Category Long Label, Category Short Label,
Category Code with SubCategory Code, SubCategory Short Label, SubCategory
Long Label.

Thanks