Skip to Content
0
Feb 22, 2011 at 05:16 PM

ERROR Select TIME

29 Views

Hi all!

I have this code, and we want that the user choose 2010.jul, 2010.aug,......2011.jun (all are in fiscal year , 2011.inp) in the package of DM.

When we select more than one periodo an error occurs. Only works when the user select only one period, p.e 2010.jun

My TIME_DIM is PERIODO

The error is: Select FISCAL from mbrPERIODO where ID='2010aug'

*SELECT(%V_MRC%, ID, Marca, TIPO = 'C_CAPACIDAD')
*SELECT(%ANIOF%, FISCAL, PERIODO, ID='%PERIODO_SET%')
*SELECT(%MERC%, ID, MERCADO, TIPO_CLIENTE='CANAL')
*SELECT(%V_MARCA%, DISTINCT(MARCA), MARCA, TIPO = 'C_CAPACIDAD' AND MARCA <>'')
*SELECT(%V_MERCADO%, DISTINCT(MERCADO), MERCADO, TIPO_CLIENTE='CANAL' AND MERCADO <>'')

*XDIM_MEMBERSET IndicadorF = IND_A1, IND_A10
*XDIM_MEMBERSET Marca =%V_MRC%
*XDIM_ADDMEMBERSET MARCA=%V_MARCA%
*XDIM_MEMBERSET Mercado = %MERC%
*XDIM_ADDMEMBERSET MERCADO=%V_MERCADO%
//*XDIM_MEMBERSET SociedadF = 
*XDIM_MEMBERSET Moneda = EUR
*XDIM_MEMBERSET TipoDato = MAN_INPUT
*XDIM_MEMBERSET Escenario = Budget 
*XDIM_MEMBERSET Periodo = %ANIOF%
*XDIM_ADDMEMBERSET Periodo = %Periodo_SET%

*WHEN PERIODO
*IS %ANIOF%
	*WHEN MARCA
	*IS %V_MRC%
		*WHEN MERCADO
		*IS %MERC%
			*WHEN INDICADORF
			*IS IND_A1
				*REC(EXPRESSION= GET(INDICADORF="IND_A10") * GET(MARCA=MARCA.MARCA, MERCADO=MERCADO.MERCADO, PERIODO="%PERIODO_SET%"), PERIODO="%PERIODO_SET%")
			*ENDWHEN
		*ENDWHEN
	*ENDWHEN
*ENDWHEN
*COMMIT