web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Request: Input on limiting dimension values of a custom dimension to a specific legal entity

(1) ShareShare
ReportReport
Posted on by 79
Hello,

I was just brought on to a project of an organization who has recently gone live. They are utilizing a financial dimension, let's call this one /Activity/, this dimension is a custom dimension. The issue is they are realizing that they want to utilize different activities for different legal entities, some may be shared but they are going to roll out quite a few LEs with their own respective activities. They will need to use legal entity override to suspend activities in the LEs where they should not be available. Just the thought of this solution gives me chills when considering the maintenance of this, each time they add an activity going forward they will need to suspends the activity in approx. 15 LEs. Even doing this through Excel is not very user friendly. 

Do you have any suggestions on how to deal with this situation order to make it as intuitive and easy to maintain as possible? Could a customization be recommended, or perhaps is it worth reviewing exchanging the dimension for a new one that is entity based and tied to a unique for such as resources for example? 

Any input on how to make a custom dimension more legal entity specific would be greatly appreciated.

BR,
Oskar
I have the same question (0)
  • Verified answer
    Kevin Xia Profile Picture
    Microsoft Employee on at
    Request: Input on limiting dimension values of a custom dimension to a specific legal entity
    Hi,
    You can consider creating a new entity-based dimension, such as EntityDimension. In this way, each legal entity has its own set of activities associated with that dimension. And create another database table to store the enumeration values for the different activities. This simplifies maintenance because the activity is directly associated with a specific legal entity. Or when you feel like a lot of work, you can consider using data management framework for data updates and imports, which enables you to update dimension values in bulk and reduce manual effort.
    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans