on 01-07-2014 3:40 AM
Hi Experts,
Like Work Breakdown Structure Hierarchy(PRHI), we want to have something similar in HANA.
Question: Is it possible that multiple HANA views refer to some hierarchy table in HANA (like PRHI) for all its hierarchy requirements. Incase not, what should be the best alternative to get similar ERP hierarchies in HANA.
Regards,
Rahul
Hi Rahul,
As per my knowledge for building any hierarchy, first we should know the order of the hierarchy and then built it in Attribute view like
POSNR->PSPHI->UP->DOWN->LEFT->RIGHT.
Then we can use this Attribute view in other Information views by joining to it.
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
Have you implemented the WBS hierarchy in HANA?
If yes then could you please share.
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'd recommend using Data Services or another ETL tool to get a clean hierarchy table (i.e. parent-child or level hierarchy) that you can leverage for your reporting (i.e. either natively via hierarchies in Attribute/Calculation Views, or via navigation paths defined in your universe for relational sources).
In theory - you could write some SQL against PRHI (and probably PRPS) and use it to define your own custom hierarchy column view in SQL, but I'd recommend against this for many reasons - you won't (easily) know how "clean" your source hierarchy data (and hierarchies are very sensitive to "badly structured" data) and custom hierarchy column views aren't available as repository objects - making their maintenance and reusability quite complex and limited, respectively.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.