Apex Code Development You need to sign in to do that
Don't have an account?
Arjunmca Multilevel data model design
Hi,
I have to create data model with 5 levels of objects. All are master details relationships.
Account --> Regions -->Country --> Unit --> Line Of Business.
An Account ( Pfizer) can have many regions - Europe, Asia, NA
A Region( Ex: Europe) can have many countries - UK, France, Germany.
A Country( UK ) have many units - Pfizer UK1, Pfizer UK2, Pfizer3.
An Unit ( Pfizer UK1) have many Line Of Business - Health , Carrier, Wealth.
As you all know that from child to parent we cant query more than 3 levels. Also i would like to do native reports.
What is the best data model design to this problem
Thanks.
I have to create data model with 5 levels of objects. All are master details relationships.
Account --> Regions -->Country --> Unit --> Line Of Business.
An Account ( Pfizer) can have many regions - Europe, Asia, NA
A Region( Ex: Europe) can have many countries - UK, France, Germany.
A Country( UK ) have many units - Pfizer UK1, Pfizer UK2, Pfizer3.
An Unit ( Pfizer UK1) have many Line Of Business - Health , Carrier, Wealth.
As you all know that from child to parent we cant query more than 3 levels. Also i would like to do native reports.
What is the best data model design to this problem
Thanks.