This is something to be aware of. If you compile the AOT visual studio projects node (AOT > Visual Studio Projects > Dynamics AX Model Projects), it modifies the SSRS report in the current layer you are in. This doesn’t happen if you do a full …
Read more →I have been working as part-time BI and Sharepoint Developer/Admin alongwith my routine AX development. While working with Analysis Services and Cubes Processing, I have come across several errors, In today’s post, I will list down the troubleshooting steps involved to solve one such error, Hope it helps somebody out there…..
Read more →Query node objects, in AX 2012 has received some major overhauls, with giving us the ability to now offer having use, for example, and more complex outer joins, as well as non-exist joins. These kinds of improvements, along with others helps lend themselves to the use of Query Elements from the AOT for a multiple use scenario’s. This is where the concept of the Query Element, being slated as a reusable API comes into play. Before we continue forward with that concept, there are some really nice resources from MSDN on this topic I think it’s important to share. Mostly, how to create and make use of query elements….
Read more →I came across this sometime back now. The “Goal” value in the Profitability Analysis report on RoleCenterpage pages does not show the budgeted values.
Going through the KPI underneath the Report I found:
-The general ledger KPIs in the anal…
In a recent post, I talked about AX 2012 and Diving into BI Analytics as a starting point back into a series of post around The BI Story for AX 2012. The point of this series of post, is to drive understanding of the BI options in Dynamics AX, and ther…
Read more →We run into issue that whenever we used a Microsoft Dynamics AX configuration file with a Reporting Services instance (as mentioned in here: http://technet.microsoft.com/en-us/library/hh389774.aspx) the following error was reported the first …
Read more →Error in processing cubes Only dimension attributes and attribute relationships can have translations in Standard Edition. Solution: Delete the analysis project, temp directory with the analysis project and the analysis project in the AOT. Use the wizard to build the project.
Read more →