Skip to Content
0

BW Hierarchy InfoObject from HANA View

Apr 08 at 11:19 PM

123

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Matthias Kadletz
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

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