I'm trying to migrate this simple piece of logic from version 4 to version 7 of BPC (on SQL 2008). In version 4 (on SQL 2000) the code works perfectly while in version 7 does not post any figure. The only modification I've done to the original script was to specify the hierarchy number as the entity dimension (ENTITA) has two different hierarchies.
Does anybody know how I can fix this? Thanks
*QUERY_TYPE = 2 *XDIM_MEMBERSET PROCESSO = QR_FASE6 *XDIM_MEMBERSET TEMPO = %SET% *XDIM_MEMBERSET SCENARIO = %SET% *XDIM_MEMBERSET DRIVER = NO_DRIVER *XDIM_MEMBERSET CONTI = FILTER([CONTI].members, [CONTI].properties("FASE") = "FASE6") *SELECT (%DEST6%, "[ID]", "ENTITA", "[FASE6] = 'X'") *SELECT (%DRV6%, "[ID]", "DRIVER", "[FASE6] = 'X'") *FOR %CDCDEST6% = %DEST6% *BEGIN [ENTITA].[H1].[#%CDCDEST6%] = ([CONTI].[C_TOT], [ENTITA].[H2].[FASE6], [PROCESSO].[TOT_DA_RIBALT]) * ([DRIVER].[%DRV6%],[CONTI].[DRV_PERC],[PROCESSO].[INPUT],[ENTITA].[H1].[%CDCDEST6%]) *END *NEXT *COMMIT
Edited by: Simeone Zanoli on Jul 5, 2011 3:00 PM