I am working on BPC 7.5 evdre where I am having Time in Rows and Accounts in Columns .
2012.JAN FRD Rate LC Forecast Total Sales .....
2012.MAR... so on
Here I want to dynamically decide to populate the Months (for which I have the logic built in excel).But memberset selection doesn't allow to select excel cells.
I can do it using EVTIM and EVGTS but it would be too much complex and unnecessary performance burden.
Basically I want the system to get first month of the current year to till next 3 years.
e.g. say 2012.SEP (current month) so the Report should show 2012.JAN to 2015.SEP
or if it is 2012.OCT then Report should show 2012.JAN to 2015.OCT....so on.
Now to manage it I can handle it in Excel very easily but limitation comes as I can't manage it dynamically with EVDRE memberset for time dimension.
Any help would be most welcome.