Hi,
I'm trying to create new records with YTD values.
Therefore I need to select all records of the current selected year.
(in case JAN values are changed, all following month values have to be changed as well)
Following the script code so far:
// Add EUR for statistical keyfigures *SELECT (%ACCSET%, "[ID]", P_ACCT, "[RATETYPE]='STAT'") *XDIM_ADDMEMBERSET P_ACCT = %ACCSET% *SELECT (%TIMSET%, "[ID]", TIME, "[LEVEL]='MONTH'") *XDIM_ADDMEMBERSET TIME = %TIMSET% *WHEN P_ACCT.RATETYPE *IS "STAT" // CURR = LC, P_MEASURE = YTD *REC(EXPRESSION=([MEASURES].[YTD]), P_MEASURE="YTD") // CURR = EUR *REC(FACTOR=1, RPTCURRENCY="EUR") *REC(EXPRESSION=([MEASURES].[YTD]), RPTCURRENCY="EUR", P_MEASURE="YTD") // CURR = CHF *REC(FACTOR=1, RPTCURRENCY="CHF") *REC(EXPRESSION=([MEASURES].[YTD]), RPTCURRENCY="CHF", P_MEASURE="YTD") *ENDWHEN *COMMIT
(for your information: P_MEASURE was created to deal with currency issues
YTD values converted at todays rate vs. cumulated monthly values at month rate)
The script selects currently all defined time periods with LEVEL = MONTH.
Something like
*SELECT (%TIMSET%, "[ID]", TIME, "[LEVEL]='MONTH'" AND "[YEAR]=%TIME_SET%.YEAR")
did not work.
Can anyone give a hint how to restrict the selection to current year values?
Thanks.
Regards
Steve
Edited by: Steve Scheidig on Feb 18, 2011 6:50 PM