Skip to Content
0
Former Member
Jul 05, 2011 at 12:59 PM

MDX logic issue (migrating from BPC 4 to 7)

14 Views

Hi Experts,

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

Simeone

*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