Hello.
I have a very specific requirement and I'm not sure how to proceed. We have a Customer hierachy define in our system which is then used in BI. Whenever my Customer (0CUSTOMER_ATTR) Datasource is extracted from ECC to BI, I'd like to set an attribute of my 0CUSTOMER equals to a Parent Node value from my Customer hierarchy based on my Customer #.
As an example, here's what my hierarchy looks like:
~ROOT
80001001 WALMART
00006505 WALMART STORE #1
00006749 WALMART SOUTH-WEST
00004284 WALMART RIVERSIDE
80001002 COSTCO
00001848 COSTCO NORTH
00002189 COSTCO PRICELESS
80001003 TOYS'R'US
...
...
So, basically, I have an attribute of 0CUSTOMER that I'd like to be equals to 80001001, 80001002 or 80001003 based on the customer # I'm processing.
I know I can get some information out of SETLEAF, SETNODE and SETHEADER tables on ECC; I had a look at theses tables but can't find anythings that looks like my existing customer hierachy.
Any help would be appreciated. Thanks!
John.