create a hirechachy using this function

[fkeuroglian]

Hi Expert

I have a field "KEY" that contain the information about the structure that i have to create

i would like to create to different fields depend on the field key that contain the structure that i want.

For example

key= CtoVentas-commerce and i want to create a dimension 1 that contains CTOVENTAS and a dimesion 2 that contain COMMERCE and have this hirechachy structure, that said that commerce belong to CTOVENTAS.

how i have to apply the function HIRECHACHY in the script to create this?

i attache the qvw and qvd for example

thanks a lot

Fernando K.