AX OLAP Cube Setup – Transaction Date not Saved

Today I saw an issue with the AX Cube definition manager not saving a new value for “Transaction date” on the measures tab. A user makes a change but when they go back to check it’s not saved. This only occurs when the user follows a specific sequence of actions, the steps to recreate and the solution…

1

Performance – SysDeletedObjects40 – Keep updated Objects

One of the key performance improvements that can be implemented for AX4 (and should apply to AX2009 also) is to disable the SysDeletedObjects40 (label is “keep updated objects” in en-us) configuration key. In older version of AX, memo fields were used on a lot of the main tables (memo field can cause performance issues), in…

1

Performance – memo/ntext fields

Performance issues in AX can be some of the most difficult to troubleshoot. Particularly as there’s so many different areas which can potentially be the cause/solution to the issue. This post will just talk about one of the potential causes of bad performance, no doubt we’ll cover some more performance issues in later posts. One…

1

AOT Query Browser – same as Table Browser

There is a really handy tool available from the axaptapedia site, it allows you to run a table browser type form against AOT query objects:If you’re creating queries in the AOT,it’s useful to be able to see the data they return before you go to the trouble of building the object that will use the…

1

AX Client Crashes on Startup

I had a problem where for a certain user the AX Client would crash on startup, because of the nature of the problem it was difficult to get in to debug to see what the cause was.After a bit of digging around it turns out that info.workspaceWindowCreated() was the source of the problem, some dodgy…

1