Skip to Content
avatar image
Former Member

SAP HANA View - Parent Child Time Hierarchy


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


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 21, 2017 at 06:57 PM

    Hi Julian,

    We support level based hierarchies (LBH) now.


    Add comment
    10|10000 characters needed characters exceeded