Load Transaction Data From Infoprovider - Delimiter Parameter in transformation file

[former_member690707]

Hello experts,

We have a strange behaviour when loading transactional data from a BW infoprovider.

In development server, in transformation file, we have set "DELIMITER = , " and it validates correctly.

In production server, we have to set "DELIMITER = ; " to let it validate correctly. If we use "DELIMITER = ," we receive an error.

Everything else is exactly the same in both servers.

I'm trying to find what parameter (or else) could be different between dev and prod, but I haven't found anything.

Do you have any ideas about what I could check?

We are running SAP BPC 10.1 classic on Netweaver 7.50, with MSSQL 12 db.

[former_member186338]

Use TAB for load from BW infoprovider!

[former_member690707]

Thank you Vadim,

I know that TAB is the recommended choice. In this case I was doing assistance for a customer who developed his own loading packages and is facing this issue. I will recommend to him to use TAB, but I'd also like to know the reason why the "delimiter" has to be set differently in the two servers.

[former_member186338]

simoneoropallo

Simply use TAB!

If you want to understand the issue details - create a very simple routine badi and debug it....