HANA Calculation View - Hierarchy with Intervals

Hi Experts,

I have a requirement of creating some of the financial reports with data modeling handled in HANA. I have the account hierarchy extracted from SAP into BW, the hierarchy has a range. I have been able to create parent-child hierarchy for non-interval hierarchies but not sure how do we go about the hierarchy with intervals. Does anyone has created any similar solution.

I know the standard BW generated hierarchies in HANA do not support intervals. So any custom solution will be great.

System HANA 1.0 SP12

Regards

Bhawick