Skip to Content

SAP HANA View - Parent Child Time Hierarchy

Mar 27, 2017 at 07:05 AM


avatar image
Former Member


i'm currently trying to set up a parent child time hierarchy in a HANA View.

Background: Since level based hierarchies are not supported by SBOC (SAP Business Objects Cloud), i'm not able to use the default HANA Calc. View - Type Time. Too bad, since the view presents a prepared level based time hierarchy...

As the data types need to be the same for parent and child column, i'm not able to prepare a hierarchy with the following levels (bottom to top)

- Date
- Month
- Quarter
- Year

To be able to set this up properly, i need a different data type for date and for all others.

As far as i can see, my only options are to use a datatype like varchar or decimal to be able to store the values.

But both have their disadvantages:
- Varchar cannot be sorted well
- Decimal looks not good in reports.

Has somebody an idea how to accomplish this?

Best Regards


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
John Leggio
Aug 21, 2017 at 06:57 PM

Hi Julian,

We support level based hierarchies (LBH) now.


10 |10000 characters needed characters left characters exceeded