Master Data Text Loading via Flat file-Data flat file not reading !!

[Former Member]

Hi All,

I am trying to load master data text from flat file to BPC in that way I have followed below steps,.

*Uploaded file(.csv format) to server

**One more step I have tried was Added one column to flat file i.e language=E,..even then I am getting same status.

*Created Transformation file as shown below,while validating I am getting this status.

As shown in above flat file I am having records,but it is not reading !! please suggest me the correct format of transformation file or any thing to do ??

Versions--BPC 10.1 classic, SP24, MS Excel-2013 BW 7.4

Many Thanks in advance !!

[andrewdiaz2000 · Accepted solution]

Hi Sri,

Have you created a DM package and run . can you post the status of package.

Regards,

Andrew.

[Former Member · Accepted solution]

Hello Andrew,

In transformation file it is showing zero records,..

For trail,I have created DM package and ran,..it gives below warning.

package status

[former_member186338 · Accepted solution]

Incorrect package/chain used!

Correct: /CPMB/IMPORT_MASTER

Vadim

[Former Member · Accepted solution]

Hi Vadim,

For Master data Attributes I have used marked in dark color

For Text loading,Please find my DM package which I have been used,marked in yellow color

Please suggest me if any thing I did wrong in making flat file or transformation file??

[former_member186338 · Accepted solution]

IMPORT_MASTER will import everything you need from text file including description!

Vadim

[former_member186338 · Accepted solution]

Please explain the full process of master data loading you want to implement!

[Former Member · Accepted solution]

While loading both attributes and description(text) at a time also

it is giving same status as below, when validating transformation file

[former_member186338 · Accepted solution]

Do you properly select the csv file? Is it comma delimited? Please show the csv file in notepad!

[Former Member · Accepted solution]

Hello Sri,

Give mapping correctly according to your flat file with Internal Dimension properties.

and run package i.e /CPMB/IMPORT_MASTER (both for attributes and text)

Ex:     ID=ID

          EvDescription=(your flat file col 2 id)

          Dimension property=(your flat file col 3 id)

follow same for all fields in flat file.

[Former Member · Accepted solution]

Thank you Ravi & Vadim.

I have given mapping for all fields as mentioned, it gives me correct validation record.

Finally master data loaded into Dimension with description as well.

I have used only one DM package/chain for both text and attributes.