6 Replies Latest reply: Mar 13, 2012 8:39 AM by Ethan Jewett RSS

Issue with the /CPMB/EXPORT_TD_TO_FILE transformation file.

Esteban Perez
Currently Being Moderated

Good evening to all,

 

We have to export data from a cube to a text file. To do this we have create in the BPC (NW 7.5 SP 09) a package with the process chain /CPMB/EXPORT_TD_TO_FILE but when we execute the package, we get an error. We think that the error is generated by the transformation file. In the chainu2019s log we can see that the process didnu2019t finish successful, the Appl Source and the clear BPC tables variants are in red and we get this error u201CJob or process BPCAPPS waiting for eventu201D.

 

 

Can anybody help us?

 

 

our transformation file is like this:

 

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

 

*MAPPING

DIMENSION_1=/CPMB/NAMEDIMENSION_1

DIMENSION_2=/CPMB/NAMEDIMENSION_2

DIMENSION_3=/CPMB/NAMEDIMENSION_3

DIMENSION_4=/CPMB/NAMEDIMENSION_4

DIMENSION_5=/CPMB/NAMEDIMENSION_5

Amount=/CPMB/SDATA

 

 

*CONVERSION

 

Is this the proper use of the TF in this case?

The complete error log:

 

/CPMB/MODIFY completado en 0 segundos

/CPMB/APPL_TD_SOURCE completado en 2 segundos

/CPMB/CLEAR completado en 0 segundos

-

-


MEASURES=PERIODIC

TRANSFORMATION= DATAMANAGERTRANSFORMATIONFILESTF_EXTRACCION_PLANO.xls

FILE= DATAMANAGERDATAFILESprueba1.txt

ADDITIONINFO= Sí

(Selección de miembros)

CONCEPTO_FI:

FUENTE:

GRUPOCAME:

MONEDA:

SOCIEDAD:

TIEMPO: 2011.ENE

VERSION: 

-

-


Nom.tarea TRANSACTION DATA SOURCE

Error de sentencia MDX: Valor CONTCORMOL                      /CPMB/T5DDIW

Aplicación: FINANZAS status de paquete: ERROR

 

Thanks in advance,

Best regards

 

Actions