Hello BW/BI experts,
I need your ideas here.
I have a table T with fields T.A, T.B, T.C. All fields have data, but the data in ECC source system is not organized in a hierarchy structure.
I need to create a hierarchy structure in BW as in the follow
A _BValu1
_BValue2
_BValue3_CValue1
_CValue2
Etc.
Can you pls share your valuable knowledge and experience on how to achieve this ?
I tried to use A infoObject as external to B hierarchy OBJCT , and B as external to C hierarchy IOBJ, but it not working to me. I gives me the following error :
Error deriving hierarchy InfoObject from field
Thanks for sharing your valuable experience and knowledge
JHN