Skip to Content
avatar image
Former Member

DM Package ends with Failed status

Jun 02, 2017 at 11:16 PM | 239 Views

Hi, experts! I need your help.

I have a DM Package that calls a Logic File, as usual. The thing is that it is currently ending with a Failed status, even when the underlying logic is working perfectly and I'm getting the expected results written back to the cube. Do you guys have any idea what could be causing this issue?

This is the advanced logic:

PROMPT(RADIOBUTTON,%SELECTLOGIC%,"Seleccione el criterio a aplicar",1,{"Monto","Porcentaje"},{"S02_IN_MONTO.LGF","S02_IN_PORC.LGF"})
PROMPT(SELECT,,,,"%CURRENCY_DIM%,%TIME_DIM%,FUENTE_DATO,ORDEN,%ENTITY_DIM%,%ACCOUNT_DIM%")
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,%SELECTLOGIC%)

Thank you all!

Best regards,

Javier.

SAP Business Planning and Consolidation, version for SAP NetWeaver
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Vadim Kalinin
    Jun 05, 2017 at 10:11 AM

    This line is missing in your advanced script:

    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

    Required!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 05, 2017 at 03:01 PM

      You are right!... Now it works flawlessly... I must have deleted it while I was editing.

      Thanks again!

  • avatar image
    Vadim Kalinin
    Jun 03, 2017 at 07:33 AM

    sample log please. And the text of logic file for this log.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 05, 2017 at 12:37 AM

      It works as expected. No errors...

      LGX:

*XDIM_MEMBERSET CECO = BAS(TOTAL)
*XDIM_MEMBERSET CUENTA = BAS(TOTAL)
*XDIM_MEMBERSET AREA = CONTAB
*XDIM_MEMBERSET TIEMPO = BAS(2017.TOTAL)
*XDIM_MEMBERSET VERSION = Budget_v2
*XDIM_MEMBERSET FUENTE_DATO = PXQ
*WHEN CUENTA
*IS *
*REC(EXPRESSION = %VALUE%, FUENTE_DATO = INPUT)
*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------
LOG:

LOG BEGIN TIME:2017-06-04 20:33:30
FILE:\ROOT\WEBFOLDERS\BUDGETING \ADMINAPP\PPTO\TEST.LGF
USER:3776569
APPSET:BUDGETING
APPLICATION:PPTO
[INFO] GET_DIM_LIST(): I_APPL_ID="PPTO", #dimensions=24 
AREA,CANAL,CECO,CUENTA,DESTINO,DIVISION,FUENTE_DATO,MATERIAL,MEASURES,MONEDA,MONEDA_REPORTE,ORDEN,ORIGEN,OWNER,PAIS,PROVEEDOR,PTOGEO,SENTIDO,SOCIEDAD,SUBRUTA,TIEMPO,TIPO_GASTO,TIPO_SERVICIO,VERSION

#dim_memberset=6 
CECO:10BRB04IG6,10BRB05I33,10BRB05I84,10BRE67I02,10BRE67I08,...5419 in total.
CUENTA:3101001006,3101001998,3101001999,3101002006,3101002007,...707 in total.
AREA:CONTAB,1 in total.
TIEMPO:2017.01,2017.02,2017.03,2017.04,2017.05,...12 in total.
VERSION:Budget_v2,1 in total.
FUENTE_DATO:PXQ,1 in total.

REC :%VALUE%

CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 1.00 ms. 48  RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :1.00 ms.
48  RECORDS ARE GENERATED.
CALCULATION END.

ENDWHEN ACCUMULATION: 48  RECORDS ARE GENERATED.

DATA TO WRITE BACK:
AREA	CANAL	CECO	CUENTA	DESTINO	DIVISION	FUENTE_DATO	MATERIAL	MONEDA	MONEDA_REPORTE	ORDEN	ORIGEN	OWNER	PAIS	PROVEEDOR	PTOGEO	SENTIDO	SOCIEDAD	SUBRUTA	TIEMPO	TIPO_GASTO	TIPO_SERVICIO	VERSION	SIGNEDDATA
CONTAB	NA	NA	4105001013	MIA	PI	INPUT	B767-33A	USD	TRX	NA	PUJ	NA	NA	NA	NA	NORTE	NA	MPJ	2017.01	NA	NA	Budget_v2	438612.40 
[... ETC]


48  RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :1.00  ms.


SCRIPT RUNNING TIME IN TOTAL:3.00 s.
LOG END TIME:2017-06-04 20:33:32

      Thanks.

      Best regards,

      Javier.

  • avatar image
    Edward Masarri
    Jun 05, 2017 at 01:51 PM

    Can you run SLG1, in BW backend, and select the time restriction. It will give you logs of your run.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded