Skip to Content
0

BW Hierarchy InfoObject from HANA View

Apr 08 at 11:19 PM

63

avatar image
Angelo Sagnori

Hi experts,

I have a requirement to get hierarchy created in a HANA view to BW InfoObject. I'm using SAP BW 7.4, I can fill in the master data of the infoobject from a Hana View, but I can not get the hierarchy created in the view. Has anyone managed to make this work?

I found the topic below but nothing conclusive:

https://archive.sap.com/discussions/thread/3665843

Attached screeshot of infoobject.

Thanks in advanced!infooject.pnghana.png

infooject.png (54.4 kB)
hana.png (70.7 kB)
BW (SAP Business Warehouse)
SAP HANA | BW SAP HANA Data Warehousing | hana | hierarchy | infoobjects
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Matthias Kadletz Answered
Apr 09 at 09:29 AM
0

Hi Angelo,

as I can see you have an InfoObject based on a HANA view with Master Data Read class "Attribute view". BW queries do not support a direct consumption of HANA hierarchies. In such cases you have to use remote hierarchies.

Remote hierarchies are basically like a user exit where you can freely define in ABAP coding how to fill the hierarchy information. It could be an option to use such an ABAP class to access the HANA hierarchy information.

Regards,
Matthias

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Angelo Sagnori
Apr 09 at 07:52 PM

Hi Matthias,

Thanks for the quick response, I'll check if I can use the remote class, because my hierarchy is not standard, it was customized in a Z table because of the specific needs of the business and consumed in Hana views.

Thank you!

1
Comment