How can I create a performance indicator to select historical and future data.

I am using the GET.DATES.OF.PERIOD, but not sure how this works.

I am retreiving data for past periods up to this current period, but I would like to get future periods/data in my chart.

Hi,

You can access the help information of the macros defined for EPM/EIS if you go to the session 'Maintain Performance Indicators', and run the session help.

This macro has 6 arguments:
perf.ind, year, year part, period number.
5 and 6 are reference arguments: start date, end.date.

So, if you pass in the future period number, you should get the dates you're after.

Andre

I found that this only runs up to current date. I have the start and end date in my program, also, the calander is beyond the current period, but no luck.

you can always query the tables directly...

Hi,

Here is part of the code of the macro, in case you're interested. Of course the version you're using could be different...

domain tgeis.ccal ccal | Calendar code

start.date = 0
end.date = 0
select tgeis011.ccal:ccal
from tgeis011
where tgeis011.pind = :perf.ind
selectdo
select tgeis003.*
from tgeis003
where tgeis003._index1 = {:ccal, :year, :yrpt}
selectdo
start.date = tgeis003.psdt(pern)
if pern = 13 then
end.date = tgeis003.lped
else
if tgeis003.psdt(pern + 1) > 0 then
end.date = tgeis003.psdt(pern + 1) -1
else
end.date = tgeis003.lped
endif
endif
selectempty
|* Calendar of PI not filled for specified period
return( -2 )
endselect
selectempty
|* PI not present
return( -1 )
endselect

return( 0 )
}

When executing this session, the session quits when it reaches the current period. Is this part of the session functionallity

tgeis0214m000