Skip to Content
0
Former Member
Jan 17, 2012 at 10:58 PM

BPC 7.5 NW SP5 - Question regarding Transformation file for exporting data

41 Views

Hi Experts,

I have a requirement to export data from a BPC application to App.server/UJFS. There are currently 13 dimensions in the application. The user requires the output file to contain only three dimensions followed by the amount(signdata), namely

| COSTCENTER | ACCOUNT | TIME | AMOUNT |.

How do i handle the same in transformation file?

Currently i am using the following transformation file but i am having issues validating it.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

OUTPUTHEADER=*COSTCENTER,ACCOUNT,TIME, PERIODIC

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

COSTCENTER=*COL(2)

ACCOUNT=*COL(4)

TIME=*COL(13)

AMOUNT=*COL(14)

I tried to remove the OUTPUTHEADER from *options and tried but it still gives the same issue.

Please help me as to how i can handle this scenario.

Thanks,

Victor