Skip to Content
0
Former Member
Jul 20, 2008 at 03:30 PM

Adding New Records Using BPC Data Manager

37 Views

Hi All,

Thanks for reading my post.

I have a requirement in which file format is as given below

Account|Category|Time|RptCurrency|Amount|Quantity

I am able to upload Amount into my application, I need to update Quantity into another account. I have tried options using *NEWCOL(A) with combinations of with and without Header file format. In case of without header my Transformation is as following:

============================================================

*OPTIONS

FORMAT = DELIMITED

HEADER = NO

DELIMITER =

SKIP = 0

SKIPIF =

CREDITNEGATIVE=NO

VALIDATE_RECORDS=YES

*MAPPING

ACCOUNT = *COL(1)

CATEGORY = *COL(2)

DATASRC = *COL(3)

ENTITY = *COL(4)

RPTCURRENCY = *COL(5)

Time=*COL(6)

AMOUNT=*COL(7)

*CONVERSION

============================================================

I need to add another Mapping to read the Quantity coming in the file but moment I do that, BPC Transformation reports error that Account dimension is already mapped and in second case when I have two columns in the file with Header, Data manager reports error "DUPLICATE SIGNEDDATA"

I may end up having another dimension to store quantity, will appreciate your comments which can be give me some hints to fix this issue.

Regards,

Umesh