Skip to Content
0
Former Member
Apr 17, 2010 at 12:33 PM

Package with script logic CANCELLED

38 Views

Hi everybody,

I am trying to implement a very simple script logic that removes negative values from the Units account.

*XDIM_MEMBERSET C_CATEGORY=%C_CATEGORY_SET%

*XDIM_MEMBERSET TIEMPO=%TIEMPO_SET%

*XDIM_MEMBERSET MERCADO=%MERCADO_SET%

*XDIM_MEMBERSET ORG_VENTAS=%ORG_VENTAS_SET%

*XDIM_MEMBERSET CUSTOMER=BAS(TOTALCUSTOMERS)

*XDIM_MEMBERSET PRODUCT=BAS(00001)

*XDIM_MEMBERSET P_DATASRC=DRIVER

*XDIM_MEMBERSET ACCOUNT_SIM=Unit

*XDIM_MEMBERSET TIPO_CLIENTE=BAS(TOTAL_TOP)

[ACCOUNT_SIM].[#Unit]=IIF(([ACCOUNT_SIM].[Unit])*(-1)<0, 0, [ACCOUNT_SIM].[Unit])

*COMMIT

When I execute it with the Data Manager the result of the package is "Cancelled". I have one large dimension ("Customer" with more than 2000 elements) but there are not too many records in the database now. However, when I restrict the number of elements, the package works fine. It seems like a memory issue, I don't know... We are using SAP BPC NW 7.0 SP5

Any idea out there? Is our logic not 'optimized' for BPC?

Thanks a lot,

Mr. Albert Mas