Hierarchy in DeepSee

Question

JAQUELINE KRIEGER · May 31, 2018

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.

#InterSystems IRIS BI (DeepSee) #Cubes