Skip to Content
0

How to load a BW hierarchy from a HANA table

Dec 14, 2017 at 04:53 PM

81

avatar image
Former Member

We have data in a HANA table that we would like to use to build a hierarchy within BW.

It seems hierarchy datasources are not supported from HANA using DB connect as the option is not available to select when creating the datasource.

We have tried numerous other ways but the main challenge seems to be with the hierarchy header; we are unable to get this to just load once, as it would via flat file, and just get the error "More than one text specified for hierarchy header for language EN"

Any thoughts on how this can be achieved simply?

Thanks

Josh

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

1 Answer

avatar image
Former Member Dec 15, 2017 at 08:39 AM
0

We have found and used a work around using an export datasource and transfer rules following the blog post below, however still keen to find a more modern / standard approach to this as it feels very outdated using transfer rules in a 7.4 BW on HANA system.

https://blogs.sap.com/2012/06/19/generating-custom-hierarchies-in-sap-bi-bw-using-custom-datasource/

Share
10 |10000 characters needed characters left characters exceeded