How to reduce complexity of a custom dimension

Summary:

One of our customers has an issue with consolidation times, that we think is caused by the growth of a custom dimension (as we've already looked at and optimized most other areas).

We would like to test to see whether a reduction of complexity in this custom dimension will help with consolidation times, but are looking for a practical way to do that (while keeping historical data).

Content (please ensure you mask any confidential information):

Application setup:

• DSO application
• Empty FCCS_10 rule
  (removed recently because we could solve it in the integration, which helped a bit)
• No partner elimination