Skip to Content
0
Sep 20, 2012 at 07:02 AM

Dynamic memberset with time

48 Views

Hi,

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.FEB .....

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.

Best Regards,

Rakesh