We have around 100K derived dimension values that need to be imported into our Gold environment. There are several iterations when we need to do it. We also would like to manage our derived dimension values via an integration.

Current issues:

• it takes a few days to load 100K records via the Derived dimensions values data entity because it calls the standard dimension framework.
• it takes a few days to delete a section in the Derived dimensions when there are many values. The application becomes irresponsive. MS ticket 2310310050001102.
• updating derived dimension values via an integration is slow.

Business impact: it delays the project timeline because the team need to wait until the dimensions are loaded.

Proposal: expand the scope of the Financial dimension service to these scenarios.