CRM Terriroty hierarchy to BI
The Territory hierarchy in CRM is defined in the way where the BP post code is assigned to Position(emplyoee) as territory attributes. The BP(account) is determined based on the post code when it is created.
The Hierarchy structure looks like Country -> Region -> Employee assigned to Territory.
Each employee would be responsible for a ZIP code and the Account would be automatically determined to the employee based on the zip code.
But for my reporting in BI I want to also pull the account into the hierarchy in BW. I would like to see the hierarchy in the form of Country -> Region -> Employee assigned to Territory -> Account Number.
Is there a way where I can pull the account number as well in the hierarchy or is there a table in CRM which has this information.
Could you please help me with this.