Processing Standard AX Cubes outside USA

If you are sitting outside USA and you are trying to process the standard AX cubes (SSAS); Two of the AX classes can make you fool, and you will see many errors inside Event Viewer and on the user profile pages(Role Centers Of AX). Those two classes are as under.

1. VendDueSummaryDP
2. CustDueReportSummaryDP

Both of above classes got a method named as getSQLStatement()

The method has the query to extract data, and both of these two classes are using direct SQL to get data from SQL server directly (SQL connection). The moment you will process the cubes it will take the date in NON-USA format, such as DD/MM/yyyyTimeInMM:HH:SS

That will not work in Direct SQL server if your SQL server is not accepting this date format. To fix this issue you can fix SQL query inside DP classes.