trying to build the denorm table for sample hierarchy