Whats happening with my Procurement and Sourcing reports!?
On some installations of Dynamics AX 2012, reports that should be summarizing the data by country or region do not display the data correctly. You will notice this when displaying reports in the Procurement and Sourcing module, as well as reports in other modules. These reports are based off the standard Dynamics AX 2012 OLAP cubes. Specifically, the “Purchase cube” is used for these reports. The vendor dimension in this cube is based off of the “VendTableCube” view – this is where the problem exists. To see an example of the problem, go to Procurement and Sourcing, Reports, Statistics, Spend Analysis, and run the Spend by country/region report.
Why?
As mentioned above, this report, and several others in the Procurement and Sourcing module, is built off of the VendTableCube view. If you were to use the table browser to look at this view, you can see that none of the address information (City, CountryRegion, County, etc.) is populated.
How to fix it
To fix this problem, update the range for ValidTo to “12/31/2154 12:00:00 am” .. “12/31/2154 11:59:59 am”. This will include any rows from the DirPartyPostalAddressView that have not yet expired. In Dynamics 365 for Finance and Operations, the OLAP cubes have been replaced by Power BI reports. If you’re looking for more information about those, click here!