Impacts of managing large volume of values in each COA Segment

Summary:

Hi All,

We have a client requirement wherein each chart of Account segment potentially will be holding approx 100,000+ values.

Looking for your views and experience to understand the potential challenges and Impact on reporting, governance, and ongoing maintenance and cube. Any relevant documentation or references would also be really helpful. Additionally, as an information the Chart of Accounts include up to 12 segments.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):