I am currently builing an Account Receivables cube in SSAS by extracting data using SSIS from the CustTrans and CustSettlement tables of a Microsoft Dynamics AX 2009 installation.
I need to rebuild historical ageing information for the last 6 months for customers. For each date, I should be able to show the outstanding amounts and the age buckets.
I am finding it very difficult rebuilding history from the CustTrans and CustSettlement tables.
Thanks in advance.