Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Dimension sets not upd...
Microsoft Dynamics AX (Archived)

Dimension sets not updating properly

(0) ShareShare
ReportReport
Posted on by Dan Vandermeulen 700

Hello,

 

I have some of our dimension sets set up to update balances during the posting process.  However, I find myself having to rebuild / update balances in the Dimension set form quite often.  If these are set up to update during posting, why would I have to update manually at all?  Anyone else having this issue and or have a solution?

 

Also today while trying to update a dimension set balance I received the following message:

"The dimension set balances are already being loaded." 

I noticed that the Rebuild balance option was not available.  (I have system admin so I should see it)  The only way I could get the dimension set to update was to delete and re-create a new dimension set.  Any suggestions, or should I simply resign myself to having to rebuild/update balances periodically.

Thank you!

*This post is locked for comments

  • John Hannan Profile Picture
    John Hannan 1,235 on at
    Re: Dimension sets not updating properly

    Hi Dan,

    To fix the Dimension Set that is stuck in "The dimension set balances are already being loaded", go into the DB and flip the values on the DimensionHierarchy.FocusState stuck Dimensions Sets from ‘In Process’ to ‘Initialized’.  When you return to the dimension sets you will be able to manually initialize again.

    This is a bug...to keep it from happening, you can implement hotfix 2708448.  From there our, your dimension sets set to automatically update on posting will be up to date!

    John

  • Pedro Rodriguez Profile Picture
    Pedro Rodriguez 2,245 on at
    Re: Dimension sets not updating properly

    Ok,

    I enabled again the recalculation of all my dimension hierachiers and the table DimensionFocusUnprocessedTransactions  is empty again.

    If the problem reproduces again I have thought to disable the option "Update balance during the posting process" on the dimensions hierarchies and update the balance periodically with a batch job. Also if this happens we may report to Microsoft because it clearly seems a bug.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Dimension sets not updating properly

    Seems to be a bug indeed. Pending records are deleted when recalculating balances. No need to delete these.

    Records with state 'Inprocess' should be deleted if they still exist after recalculating balances but only for the recalculated dimension set.

  • Pedro Rodriguez Profile Picture
    Pedro Rodriguez 2,245 on at
    Re: Dimension sets not updating properly

    Hi I have checked and in this table I have a lot of records with:

    "FocusDimensionHierarchy" with the recid of the dimension hierarchy that have the problems, "GeneralJournalEntry" with some repeated IDS but not all the same, "State" = Pending.

    Not sure if I should delete everthing here!

    But it clearly seems a Microsoft bug. Do you think?

    Thanks!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Dimension sets not updating properly

    Hi,

    Same problem at customer site here.

    Seemes that problem is caused by records in table DimensionFocusUnprocessedTransactions. After updating balances all pending records from updated dimension set are deleted. What remains are records with state inProcess. These are the records which cause the problem. I our case 2 identical records (only recid differs).

    Deleted those records because after rebuilding balances nothing has to be processed anymore.

    regards,

    Peter

  • Pedro Rodriguez Profile Picture
    Pedro Rodriguez 2,245 on at
    Re: Dimension sets not updating properly

    Hi,

    In our system it also get crashed and I get also the message "”The dimension set balances are already being loaded" .

    To make the calculation again available I followed the steps below but I still dont know the source of the error so I have to make this fix daily :-(

    rif.kiamil.com/.../try-to-update-you-ax2012-financial-dimension-set-but

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Dimension sets not updating properly

    The trial balance is in a difference table from the live data that is why it needs to be updated.   Most clients I see update with the scheduler.    Key to this is have a small number of Dimension Sets.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans