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 :
Microsoft Dynamics AX (Archived)

Updating Default Dimensions on Master data tables in time

(0) ShareShare
ReportReport
Posted on by 231

Hi,


I want to ask if anyone have any experience in creating a functionality that would allow user to:

keep history of dimension value changes on master data tables and allow to enter new dimension value that is valid for a given time range.

What I want to accomplish is to create a generic solution for all master tables that would allow storing default dimension values with time range. At the same time I would like to minimize the number of modifications in AX code.

Do you have any experience in building such framework?

What would you suggest as best entry points in the application code.

Best regards,

Sebastian

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    299,024 Super User 2025 Season 2 on at
    RE: Updating Default Dimensions on Master data tables in time

    Hi Sebastian,

    You can create a single table storing default dimension field with also a table and record reference. In addition it needs to have a start and end date. (Effective from and to)

    The wish to prevent the number of objects involved is not possible. On every point where the default dimension is used, you need to check in this table if there is a date effective default dimension available. In several methods it is just doing a call like this:

    salesTable.DefaultDimension  = _custTable.DefaultDimension.

    So in fact it is just copying an integer value.

    Also you need to check how the current default dimensions are managed on forms. The forms does not have the controls. These are dynamically added when opening the form.

    This will be not an easy customization...

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans