Skip to Content
1
Former Member
May 08, 2012 at 07:34 AM

Script Logic Variables in Select Statement

516 Views

Hello BPC experts,

We are trying to get all the months that are greater than the one that we have entered by the pop-up in the datamanager package.

We are working with the following syntax that used to work in other proyect over BPC 7.5 NW, but it is not working in our case in BPC 10 MS.

The variable in LE2 is only getting one month and not all the months greater than the proposed one. For instances if we are entering 2012.SEP, the variable %LE2% should store 2012.SEP, 2012.OCT, 2012.NOV and 2012.DEC, but it is only getting 2012.SEP.

These are the instructions we are using.

*SELECT(%MONTH_PLAN%,"[BASE_PERIOD]",TIME,"[ID]"=''TIME_SET")

*SELECT(%CY%,"[YEAR]","TIME","[ID]='%TIME_SET%'")

*SELECT(%LE2%,"[ID]",TIME,"[BASE_PERIOD]>='%MONTH_PLAN%' AND [CALC]='N' AND [YEAR]='%CY%'")

Please let us know if you have any ideas.

Best regards and thanks in advance!!