CRM Terriroty hierarchy to BI

[Former Member]

Hello,

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.

Thanks,

KK

[Former Member]

Any one could you please help me with the below issue.

thanks,

KK

[enginimaldb]

Hi,

did you solve your problem. Can u pls explain me how u load the CRM BP hierarchy into BW?

Kind Regards

Engin