Hi community,

I’m working in a project for a Chile Police and I need to know if it’s possible to build a hierarchy in Deepsee like Zone- Prefecture – Comisaria – Destacamentos (there are 4 levels of police units) , but these information are only in one table that has the code, the father ,description and UnitType. (it’s recursive) . Example:

UNI_CODIGO UNI_PADRE UNI_DESCRIPCION UNI_TIPOUNIDAD
1 20 OTRA REPARTICION  
10 2.380 38A. COM. PUENTE ALTO 50
20   DIR.NAC.SEGUR.Y ORDEN PUBLICO 10
30 8.855 TENENCIA CARRETERA ARICA 70
40 8.740 1RA. COM. ARICA (AGR) 40
45 40 1RA. COM. ARICA 50

 

The idea it’s to build dimensions bases in expression to build this. Is it possible ?

Thanks a lot.