unable to validate the Transformation file

[Former Member]

Hi Guru's,

When i am trying to Validating Transformation file i am getting the following error.

[Start validating transformation file]
Validating format of transformation file
Validating options…
Validation on options was successful
Validating mappings…
Validation on mappings was successful
Validating conversions…
Validation on conversions was successful
Creating the transformation xml file; wait a moment
Transformation xml file saved successfully

Connecting to server...
Begin validate transformation file with data file…
[Start test transformation file]
Validate has successfully completed
ValidateRecords = YES
Cannot find generated document content in DB Table
Error: Validate with data file failed

I maintained the following Mappings in Mapping Section.

ACCOUNT=RACCT

C_SEGMENT=SEGMENT

C_PRCTR=PRCTR

CON_ENTITY=RBUKRS

C_Category=RVERS

C_DataSrc=*newcol(INPUT)

Groups=CURTYPE

Intco=RASSC

RptCurrency=*NEWCOL(LC)

SIGNEDDATA=BALANCE

FLOW=RMVCT

Time=FISCPER

We are not maintaining any COnversion file. That is not required for our requirment.

Kindly help me on that issue.

Regards,

Srinivasan.

[Former Member]

Hi Srinivasan,

Please try Raghu's suggestion; since BPC NW is case sensitive, this might be the problem.

In case it doesn't resolve the issue, can you please share the entire transformation file and the structure of the source.

[raghu_ram]

Hi Srinivasan,

Please change the line C_DataSrc to C_DataSrc =*NEWCOL(INPUT) and validate the Transformation file and see if it works.

Regards,

Raghu

[Former Member]

Hi Raghu,

Thanks for the reply and i follwed as per your guidance i am getting the following error.

[Start validating transformation file]
Validating format of transformation file
Validating options…
Validation on options was successful
Validating mappings…
Validation on mappings was successful
Validating conversions…
Validation on conversions was successful
Creating the transformation xml file; wait a moment
Transformation xml file saved successfully

Connecting to server...
Begin validate transformation file with data file…
[Start test transformation file]
Validate has successfully completed
ValidateRecords = YES
Cannot find generated document content in DB Table
Error: Validate with data file failed.

I maintai the Transformation file like this.

ACCOUNT=RACCT

C_SEGMENT=SEGMENT

C_PRCTR=PRCTR

CON_ENTITY=RBUKRS

C_Category=RVERS

C_DataSrc =*NEWCOL(INPUT)

Groups=CURTYPE

Intco=RASSC

RptCurrency=*NEWCOL(LC)

SIGNEDDATA=BALANCE

FLOW=RMVCT

Time=FISCPER

But beforethat i am trying to upload a flat file i am getting the "BAD REQUEST ERROR" for that i uploaded file in Backend like UJFS-->WEBFOLDER-->DATAMANAGER.

I updated like that.

Is it a problem.

thanks in advance.

Srinivasan.

[Former Member]

Hi Srinivasan,

For uploading a flat file, it is better to use the "upload file" feature in BPC excel.

If you dont want to use this feature and want to upload directly in UJFS, then you should use "upload file for DM".

Hope this helps.

[Former Member]

Hi Expert,

When i am trying to upload using Data manager facing the "Bad Server" Problem.

That's the reason i uploaded from Backend and validating the file from Front end .

a small clarity because of that i am getting the issue.

Regards,

Srinivasan.

[raghu_ram]

Hi Srinivasan,

Please check the extension of the file which you are uploading, save it in .csv format and upload again.

Regards,

Raghu

[Former Member]

Hi Srinivasan,

Its ok if you are uploading it in backend. But have you looked into my suggestion?

When you upload a file in UJFS, you have 2 options:

1. Upload file

2. Upload file for DM

Which option did you use?

You need to use the 2nd option.

What is the extension of your file?

Hope this helps.

[Former Member]

Hi Nilanjan,

Sorry to saying this i saw one thread you recommended this option when ever your front end is not working. I am using .CSV format. Now i am able to loading using front end.

Can you please help me. In my flat file i have different accounts how will i maintain all in the Account Conevrsion file. Is there any way. For example in my Account dimension i have 700 accounts in my flat file i have 300 accounts . shall imaintain all of these accounts.

Please guide me .

Regards,

Srinivasan.

[Former Member]

Hi Srinivasan,

Maintaining conversion file can be a bit tricky.

You definitely have the option of maintaining separate lines for each of the accounts in your flat file. However, this will increase the amount of work and maintenance. Is it worth it?

If you can find some sort of pattern, then you can make use of it.

You will get some tips from the below link from help.sap:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/81/94a8a5febd40268d5c59b4fc31be37/content.htm

Hope this helps.

[Former Member]

Hi Expert,

I am trying to upload the flat file it is saying the "104 is non-numerical in line 2; rejected"(my whole file is rejected because of this reason).

My concern is is BPC doen not allow th efollwoing number format "104,560.00".

Please help me on this issue.

Regards,

Srinivasan.

[raghu_ram]

Hi Srinivasan,

Please check the SAP Note 1231909 for your issue.

Regards,

Raghu

[Former Member]

Hi Raghu,

Thanks for the valuable reply and can you please help me on this line they mentioned please change the line "Change the message 062 to "Dimension:SIGNEDDATA member:&3 is

non-numerical in Line &1, was rejected"

But they are not specified any thing to change frpm that line to another line.

Regards,

Srinivasan.

[raghu_ram]

Hi Srinivasan,

That Note is for BPC 7.0 release, not sure whether it can be applied for 7.5 NW or not. In your Transformation file mappings you have SIGNEDDATA=BALANCE, is BALANCE the keyfigure in BW side.

Regards,

Raghu

[Former Member]

Yes my K.F is Balance.

Regards,

Srinivasan.

[Former Member]

Hi Guru's,

Any help on this issue.

Kindly help me on this.

Thanks in Advance,

Srinivasan.