I have a Month/Year field in a Fact QVD (I have multiple Transnational Fields as well), where I have last 18 Months (Jan - 15, Dec - 14, Nov - 14, Oct - 14...... Aug - 13). Now while Loading into Script, I want to fetch only last 12 months.
What would be the logic to write in Load Script?
Thank you very much. Am checking it now.
But one query please-
Will this condition monthstart(addmonths(today(),-12)) ignore the Current Month? (I don't need Feb - 15, need Jan - 15 and backwards).