Hey Specs !
We usually create hierarchy manually from ECC and excel/csv source from time to it would be nice to create hierarchy from transactional data (like in Oracle SQL server with connect by or MS SQL Serverrecursive call).
I am wondering what is/are the best approach to generate BW hierarchy from transactional data.
Is there any function module for it or some kind of approach that would do the trick ?