Skip to Content
0
Former Member
Nov 26, 2012 at 05:06 PM

Issue with using Output delimiter in Transformation file

148 Views

In BPC MS version,We are using the following transformation file for getting an output file based on the input file using the convert step in BPC Package.
In the below transformation file,the columns from ENTITY to SIGNEDDATA are BPC dimensions and the rest such as CCDESC,ACCTDESC,CCGL and ACCTGL are required to be published in the output file.It is working fine in BPC MS version and in the NW version,the transformation file is not getting validated by showing an issue with Output delimeter as it can be used only for export.
And when I try to generate the file,it is not getting the extra columns in the file.I am not able to use the same transformation file that is used in BPC MS.

My goal is to have the extra clomuns(CCDESC,ACCTDESC,CCGL,ACCTGL) along with BPC dimensions in the output file so that users can do the detailed reporting in case they need to look at the GL account or the cost center details which are not a part of BPC Dimension. Once the output file is generated with the extra columns we can load the same into a BW DSO and the users can use the same as an reference in case they need to validate the BPC Model against Input Data. Since this functionality works in Microsoft we will like to know if this works in NW and incase not then is there any other solution in terms of providing the detailed report to the users.


*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ~
OUTPUTDELIMITER = ~
SKIP = 0
SKIPIF =
CONVERTAMOUNTWDIM=
CREDITNEGATIVE = YES
MAXREJECTCOUNT = 65000
VALIDATERECORDS = NO
*MAPPING
ENTITY = ENTITY
CATEGORY = CATEGORY
TIME = TIME
COSTCENTER = COSTCENTER
ACCOUNT = ACCOUNT
REPCURRENCY = *NEWCOL(LC)
GEOGRAPHY = GEOGRAPHY
INTCO = INTCO
PRODUCTTYPE = PRODUCTTYPE
DATASRC = *NEWCOL(GLTB_LC)
SIGNEDDATA = SIGNEDDATA
CCDESC = CCDESC
ACCTDESC = ACCTDESC
CCGL = COSTCENTER
ACCTGL = ACCOUNT
*CONVERSION
ACCOUNT = CONV.XLS!ACCOUNT
COSTCENTER = CONV.XLS!COSTCENTER