Hi Friends,
I am working on FI-AR Aging report on 0FIAR_C03 Cube. My BI objects for calculations are:
0DEB_CRE_DC (KeyFigure)
0NETDUEDATE (Char)
When user execute the query, he has to key-in few variables:
Type-In date (default is todays date)
Aging Basket (user configurable 0-30 days, 31-60 days, etc.)
Calculation needed:
Current Due Amount = 0DEB_CRE_DC, whenType-In date is greater or equal to Net Due Date
Past Due Amount = 0DEB_CRE_DC, when Type-In date is less than Net Due Date
Current and Past Due Amount should be displayed on Aging colums (0-30days, 31-60 days, etc)
If anyone has done similar queries please help.
Thank you and regards,
~S