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