Short for column: , langu - Master data upload using flat file error

[Former Member]

SAP Netweaver 10.0, SAP BW 7.3

Hi

I am facing the following error when uploading the master data using a flat file, where neither I have mentioned "Langu" in Flatfile nor property in the dimension. can anyone help me with the reason for it and the solution.

Thanks

BK

[Former Member · Accepted solution]

Hi BK,

If you are loading through flat file....then the mapping should be as follows

ID=*COL(1) (If ID column is column no.1 in your flat file)

EVDESCRIPTION=*COL(2)

ACCTYPE=*COL(3)

PARENTH1=*COL(4)

What is your name of Hierarchy in BPC H1 or PARENTH1????? Hopefully your flat file is in .CSV format and not just excel file.

Regards,

JP

[former_member186338 · Accepted solution]

Why do you think that only *COL(...) syntax will work???

The import file has a header and field names from the header can be used:

ID=ID

EVDESCRIPTION=DESCRIPTION

ACCTYPE=ACCTYPE

PARENTH1=H1

[Former Member · Accepted solution]

Yes Vadim....I know the fact that headers can also be used in mapping. But in my known knowledge sometimes it doesnt work and I always prefer the this STD way first.

[Former Member · Accepted solution]

Hi JP,

My flat file is in CSV format only. Hierarchy name in BPC is PARENTH1 and Flatfile is H1. Changed the Transformation file mapping to PARENTH1 = H1. the error is attached.

BK

[former_member186338 · Accepted solution]

Sorry, but "sometimes it doesnt work" - never happened with me

[former_member186338 · Accepted solution]

But what is the issue? Look on my answer!

[former_member186338 · Accepted solution]

What's wrong with the line:

SKIP=0

???

Can you provide screenshots with better resolution???

[former_member186338 · Accepted solution]

And can you show the screenshot of the dimension administration?

[Former Member · Accepted solution]

I changed the mapping like you mentioned, but the error says the account Dimension has invalid member ID

[Former Member · Accepted solution]

here is the account dimension admin

[former_member186338 · Accepted solution]

Now you have:

It means that some ID in your text file is incorrect (containing some reserved characters or...)

[former_member186338 · Accepted solution]

Try to import only few lines with base members!

[Former Member · Accepted solution]

I tried creating a new transformation file and it is working now.

Thanks

BK