Is there a way to Loading SAP BW hierarchy to Datashpere ?

[aczeitner]

Hey Specs 

Is there a way to load SAP BW hierarchies to SAP datashpere ?

I am trying to find standard way to load hiearchies already generated in BW to SAP datashpere ?

Is there any standard way apart from trying to build up everything from the hierarchy tables ?

I have some prompt in my BW that are filtering hierarchy nodes in the query and I want to replicate the same behaviour in Datashpere 

Thanks for all guidance

[MKreitlein · Accepted solution]

Hello @aczeitner 

I think this Blogs comes just in time for you 🙂 

https://community.sap.com/t5/technology-blogs-by-sap/part-2-import-sap-bw-4hana-queries-into-sap-dat... 

There you have one example of the Customer Infoobject and all it's tables ... unfortunately it seems to work only with BW4 and BW Bridge.

If you have a BW on HANA, you probably need to create CDS Views to transfer the data into manually created Datasphere tables.

BR, Martin

[aczeitner · Accepted solution]

Thanks Sadly I am on BWonHana and we are some months away from BW bridge. Anyway what I did is to import the Hierarchy table and the Hierarchy text table and whit that I could import the most relevant things for the Hierarchy 🙂