I am currently working in SAP Design Studio 1.2 version and BW queries as source. I am in need to list last 36 months (like Aug 2013, Sep 2013, etc) on one of the drop down box and depends on which data will be displayed on dashboard. I get the latest month and year value from the source query but i do not see any option of creating loop or next\while such that i can do coding to produce it dynamically. I know that it is currently not available in 1.2 version but is there a way to do this?
Example : Current month is Apr 2013
I will require drop-down box to show Apr 2013, Mar 2013 till . May 2010.