Sometimes, the simplest mistakes are also the most common ones. Something, that many people forget is to shrink the transaction logs after a model store code move. See, what happens is that code moves are very intense on the transaction logs. The transaction logs then grow to ridiculous sizes (many, many Gigabytes) and eventually the…
People always ask me what it takes to be successful on assignment after assignment. I suppose that I’ve had a good run lately. I’ll tell you right now that it is based on your ability to innovate solutions that end up in a company gaining competitive advantage. As AX practitioners we can never stop striving…
Your SharePoint AX configuration is starting to look good. It has some serious Excel functionality that is going to make you look like a hero when the business gets their hands on that Excel data. But you want more. You want your AX users to also have access to PowerView and gorgeous dashboards. We’ll do…
You’ve probably noticed in this series that we are installing more than just the reporting extensions. Silo BI AX setups are the enemy. They limit our ability to effectively use the latest ease of use technologies and cause people to walk away with a bad, mistaken view of AX Business Intelligence. I’ve walked on many…
Like many organizations, my client had noticed the loads of awesome competitive advantage and Business Intelligence that SharePoint offers. The problem, however, is that SharePoint and Dynamics AX are both complicated by themselves. When you have to deal with two complicated systems and make them play nice, things become exponentially harder. After many months of…
I just had to get my techno-functional on to solve a very complicated problem for a client. Afterwards, I had noticed several cases of people noting this on the internet with no solutions or the wrong solutions specified. So, I thought that I would take the time to explain the problem and how to fix…
I just wanted to let everyone know about a gotcha that I had to deal with at a client’s location with SharePoint SP1 and Enterprise Portal. As anyone knows who has had to install Enterprise Portal a few times in a SharePoint 2013 environment, you had better install the Secure Store Service and actually generate…
Wouldn’t it be great if you could just figure out the SQL that would allow you to pull Dynamics AX data from that complicated financial table setup. Recently, I had a client give me a challenge where they wanted me to come up with a way that they could utilize their existing staff who had…
In the final part of our series, our hard work has paid off. You will be able to generate a general ledger report that is fast, and that will allow for our users to query dimensions however they like. We want our users to really see the power of AX and nothing does that like…
Now, in my continuing mission to ensure that my blog devalues my skills as an AX Technical Architect/Consultant, I’m going to give away more of my precious secrets. If you understand this post, you will have learned a very, very strong tactic for extracting data with SQL – and not just financial data. The other…