Skip to Content
0
Former Member
Feb 18, 2011 at 05:48 PM

BPC 7.0 SP6 Script Issue

12 Views

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