Friday, May 24, 2013

AX2012 SSRS error when trying to add a data method

Normally, adding a new data method to a SSRS report in a ReportModel project will automatically build the xxx.budinessLogic project.
I don't know how to reproduce this, but today I ran into a problem that when I try to add a data method to a SSRS report (which had no data methods previously) I get an error message saying:

"could not resolve xxx.BusinessLogic from the AOT. Verify that the Buiness logic library property is set correctly, the referenced project is added to the solution and loaded"

The work around is actually fairly straight forward:
1) Add a new report in the same solution.
2) Add a new data method in the new report. By doing so the businessLogic project is created like it should.
3) Delete the report created in step 1.
Well, took me awhile to think of trying this. But at least I can move on now. =]

Saturday, May 18, 2013

AX2012 R2 Data Import Export Framework:"Treenode object not initialized"

There is a bug in Data Import Export Framework (AX2012 R2) custom object generation wizard in the part where it is cleaning up table relations of the entity table. One example of the problem is when creating a new entity for CustGroup, it will generate an error.  (Details can be found here:)

In the CustGroup example, DefaultDimension is imported as String (e.g. MainAccount-Department-CostCenter) and not an Int64 value. Hence the relation between the Dimension field (a RefRecId) and the reference table (DimensionAttributeValueSet) no longer applies and should be deleted. That is where the bug hits.

In the DMFGenerateEntityTable.modifyRelations method, the cursor which is suppose to traverse through all relations is accidentally discarded when deleting the table relation. Make the following changes to fix it:

This posting is provided "AS IS" with no warranties, and confers no rights.