SAP BPC 10.1 Classic Flat file Master data load Description Col Issue

[vinoogan]

Hello Expert

We are moving Account dimension Hierarchy members from Production to Dev for testing.

When I include Description column in flat file load, Account dimension fails due to description having "," as special character. I also tried using TAB in Delimiter: Transformation rule did not work.

If i remove the Description Column, then i was able to update the Account Dimension. Please advise.

Thanks

Vinoo

[former_member186338 · Accepted solution]

When you are exporting, use transformation file with the row in OPTIONS:

OUTPUTDELIMITER=TAB

As a result you will have correct TAB delimited file.

Import it with:

DELIMITER=TAB

[benniejayfguevarra]

Hi Vinoo,

There's a TEXTQUALIFIER= " option. Just make sure that your csv ot tab delimited has that text qualifier.

Thanks,

Bennie Jay Guevarra

[N1kh1l]

vinoogan

If you exported the file from Dimension administration window then it would have exported as .csv format. First open this file in excel and delete all extra columns and rows by simply selecting them.( Ctrl Shift right for columns and Ctrl Shift down for rows. ). Now save this file as Tab Delimited .txt firmat. ( File Save as ). Now use a transformation file with TAB as delimiter. This should solve your issue.

-Nikhil

[former_member186338]

To my mind, it's not a good idea to export from Dimension administration window. Better to use normal DM export of MD to text file with transformation file including OUTPUTDELIMITER=TAB.

[johnnbc]

Can we see the whole load file width - the error is saying you are trying to load a text string to a numeric property